This section explains how to install and configure Oracle.
Note
Install only Oracle software to all nodes. Do not create a database in this section (Database creation is performed in "2.2.6 Oracle Database Creation and Setting").
In PRIMECLUSTER Wizard for Oracle, environment that Oracle software is installed on shared disk does not supported. Install Oracle software to a local disk of each node.
If multiple ORACLE_HOME are configured on one server, a different user name must be assigned respectively.
If you install Oracle Grid Infrastructure to use ASM on Oracle 11g R2, you must create install user for the Oracle Grid Infrastructure and the Oracle Database installations separately. For information on how to install this configuration, see "2.4.2 ASM (Automatic Storage Management)".
Confirm the contents of "Chapter 5 Notice" before Installing.
Initial setup
Set up the kernel parameter
Set up values in the “/etc/system” file for Oracle in addition to the values for PRIMECLUSTER.
The kernel parameter values vary depending on the implemented Oracle versions.
Refer to the Oracle installation guide. The parameter values should be the same on all the nodes.
Note
For semopm, specify a value of 4 or more.
Oracle User
Create an operating system user account belonging to OSDBA group to allow users to install and operate Oracle. The user ID and the group ID must be the same on all the nodes.
Example
# groupadd -g <groupID> dba # groupadd -g <groupID> oinstall
# useradd -u <userID> -g oinstall -G dba -d /home/oracle -s /bin/sh -m oracle
# passwd oracle
Normally, the group name should be “dba” and “oinstall”.
Set up an environment variable of Oracle user.
Example
(.profile)
ORACLE_BASE=/opt/oracle; export ORACLE_BASE ORACLE_HOME=/opt/oracle/product/11.2.0; export ORACLE_HOME ORACLE_SID=ora; export ORACLE_SID LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH PATH=$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/ucb; export PATH
When “/usr/ucb” is contained in PATH, it needs to be set up after “/usr/ccs/bin”.
Information
For further details, refer to the Oracle manual.
Note
PRIMECLUSTER Wizard for Oracle controls Oracle as the operating system user belonging to OSDBA group(Oracle user).
Be sure to include “$ORACLE_HOME/bin” in the PATH environment variable of the Oracle user.
Check if root user access privileges can switch the user to the Oracle user, using the su(1M) command.
# su - <Oracle user>
A command (e.g. script) that has interactive mode should not be described in Oracle user's profile. (e.g. /etc/profile, .bash_profile, .cshrc, .profile) It may cause failure of resource monitoring or userApplication startup or shutdown.
Environment that Oracle user's home directory and profile are located on the shared disk is not supported. Oracle user's home directory and profile must be located on the local disk of each node.
Installation
Install Oracle software, refer to the Oracle manual.
The database needs to be created on the shared disk when configuration of the cluster system is completed, not when Oracle is installed. The details will be described later in this document(2.2.6 Oracle Database Creation and Setting).