• Options Oracle Software
• Option Oracle Download
• Install Procedural Option Oracle Vm
• Option Oracle Free Download

1. The scripts use a token to represent the working directory, so you can install them from anywhere, but I prefer to place them in the '$ORACLEHOME/demo/schema' directory. Unzip the files into the '$ORACLEHOME/demo/schema' directory. In this example we used the 12.2.0.1 version of the sample schemas.
2. Installing Oracle Version 12c. Once the installation files have been unzipped, you can proceed with installing Oracle Version 12c. Go to “ locationofinstallfiles win3212201client client32” and double-click on the “setup.exe” file located there. (In our example, the location is “C: Install win3212201client client32”.

1) Configure SF Oracle RAC sub-components 2) Prepare to Install Oracle 3) Install Oracle Clusterware/Grid Infrastructure and Database 4) Post Oracle Installation Tasks 5) Exit SF Oracle RAC Configuration Choose option: 1-5,q (1) 3; Select the option Install Oracle Database.

Home -> Community -> Usenet -> c.d.o.server -> Re: Procedural Option, how to install it?

Options Oracle Software

On Jan 25, 9:26 am, 'Frank R.' <tre..._at_gmail.com> wrote:
> Hello,
>
> Some of my fellow developers is getting an ORA-900 error when trying to
> issue an 'exec <PROCEDURE>....' from toad and other external server
> apps.
>
> Regarding the explanation of the error in oracle documentation
> (http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96525/e900.htm)
> it seems that if the PL/SQL info does not appear in the SQL*Plus banner
> the component is not installed.
>
> I tried as suggested:
>
> $ sqlplus '/as sysdba'
>
> SQL*Plus: Release 9.2.0.7.0 - Production on Thu Jan 25 09:00:32 2007
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.7.0 - Production
>
> SQL> select * from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
> PL/SQL Release 9.2.0.7.0 - Production
> CORE 9.2.0.7.0 Production
> TNS for IBM/AIX RISC System/6000: Version 9.2.0.7.0 - Production
> NLSRTL Version 9.2.0.7.0 - Production
>
> SQL> select comp_name, version, status from dba_registry
>
> COMP_NAME VERSION
> STATUS
> --------------------------------------------------
> ------------------------------ ------------------------------
> Oracle9i Packages and Types 9.2.0.7.0
> VALID
> Oracle9i Catalog Views 9.2.0.7.0
> VALID
> Oracle Workspace Manager 9.2.0.1.0
> VALID
>
> I am a bit puzzled since SQL*Plus banner does not show PL/SQL info but
> v$version does. Anyway, I still haven't found in the web/metalink a way
> to reinstall Procedural Option. Can someone help me on this?
>
> Thanks in advance.

You didn't read the error message carefully enough.(BTW: I would stop using non-Oracle locations for the documentation.Oracle may update the documentation. Do you think a separate copy willget updated too?)
>From the same doc

Action: Correct the syntax or install the Procedural Option.

You didn't verify whether the syntax of the affected statement iscorrect, nor did you verify whether the Procedural Option is installed(Likely it is, or otherwise you can't do almost anything).And how to install the Procedural Option is described in theinstallation documentation.Received on Thu Jan 25 2007 - 04:28:02 CST

• This message: [ Message body ]
• Next message: Steve Robin: 'exp getting ora600 and exp 00008 error'
• Previous message: mmccaws2: 'more 8.1: defrag the drive'
• In reply to: Frank R.: 'Procedural Option, how to install it?'

• Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Articles » 12c » Here

This article describes the installation of Oracle Database 12c Release 1 (12.1) (64-bit) on Oracle Linux 6 (64-bit). The article is based on a server installation with a minimum of 2G swap, with SELinux set to permissive and the firewall disabled. The following package groups were included for this installation.

• Base System > Base
• Base System > Compatibility libraries
• Base System > Hardware monitoring utilities
• Base System > Large Systems Performance
• Base System > Network file system client
• Base System > Performance Tools
• Base System > Perl Support
• Servers > Server Platform
• Servers > System administration tools
• Desktops > Desktop
• Desktops > Desktop Platform
• Desktops > Fonts
• Desktops > General Purpose Desktop
• Desktops > Graphical Administration Tools
• Desktops > Input Methods
• Desktops > X Window System
• Applications > Internet Browser
• Development > Additional Development
• Development > Development Tools

An example of this type of Linux installations can be seen here. Alternative installations may require more packages to be loaded, in addition to the ones listed below.

• Oracle Installation Prerequisites
  

Related articles.

Download Software

Download the Oracle software from OTN or MOS depending on your support status.

This article has been updated for the 12.1.0.2 release, but the installation is essentially unchanged since 12.1.0.1. Any variations specific for 12.1.0.1 will be noted.

Depending on your version of VirtualBox and Oracle Linux, there may be some slight variation in how the screen shots look.

Unpack Files

Unzip the files.

You should now have a single directory called 'database' containing installation files.

Hosts File

The '/etc/hosts' file must contain a fully qualified name for the server.

For example.

Oracle Installation Prerequisites

Perform either the Automatic Setup or the Manual Setup to complete the basic prerequisites. The Additional Setup is required for all installations.

Automatic Setup

If you plan to use the 'oracle-rdbms-server-12cR1-preinstall' package to perform all your prerequisite setup, issue the following command.

Earlier versions of Oracle Linux required manual setup of the Yum repository by following the instructions at http://public-yum.oracle.com.

It is probably worth doing a full update as well, but this is not strictly speaking necessary.

Manual Setup

If you have not used the 'oracle-rdbms-server-12cR1-preinstall' package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add or amend the following lines in the '/etc/sysctl.conf' file.

Run the following command to change the current kernel parameters.

Add the following lines to the '/etc/security/limits.conf' file.

Install the following packages if they are not already present.

Create the new groups and users.

Uncomment the extra groups you require.

Additional Setup

The following steps must be performed, whether you did the manual or automatic setup.

Set the password for the 'oracle' user.

Amend the '/etc/security/limits.d/90-nproc.conf' file as described below. See MOS Note [ID 1487773.1]

Set secure Linux to permissive by editing the '/etc/selinux/config' file, making sure the SELINUX flag is set as follows.

Once the change is complete, restart the server or run the following command.

If you have the Linux firewall enabled, you will need to disable or configure it, as shown here or here. To disable it, do the following.

Create the directories in which the Oracle software will be installed.

Putting mount points directly under root without mounting separate disks to them is typically a bad idea. It's done here for simplicity, but for a real installation '/' storage should be reserved for the OS.

Option Oracle Download

Unless you are working from the console, or using SSH tunnelling, login as root and issue the following command.

Add the following lines at the end of the '/home/oracle/.bash_profile' file.

Installation

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

Proceed with the installation of your choice.

If you are doing an installation for an Enterprise Manager repository, remember to do an advanced installation and pick the ALT32UTF8 character set.

You can see the type of installation I performed by clicking on the links below to see screen shots of each stage.

The 'Database Configuration Assistant Complete' screen displays the Database Express 12c URL, which will be something like 'https://ol6-121.localdomain:5500/em'.

Post Installation

Edit the '/etc/oratab' file setting the restart flag for each instance to 'Y'.

If Database Express 12c is not working, check the XMLDB HTTP port. If it is 0, set it to the port you want to use.

Common Errors

Install Procedural Option Oracle Vm

• 'error code 35' : The machine name in the '/etc/hosts' file is not correct. It needs an entry for the loopback adapter (localhost) and the machine name. If you are using DNS for name resolution, you still need the loopback adapter reference in this file.

• 'error code 37' : The DNS not working properly. You may also get this error is the '/etc/hosts' file is not configured correctly.

• 'sqlplus: error while loading shared libraries: libclntsh.so.12.1' : The prerequisites have not been met. Work through them again. Specifically, make sure the 'gcc' package has been installed.

• Listener fails to start - Typically this is due to incorrect name resolution. Make sure the '/etc/hosts' and/or DNS is configured correctly.

• Linking errors - Almost always due to missing prerequisites. Review the setup sections.

For more information see:

Option Oracle Free Download

Hope this helps. Regards Tim...