This section explains how to install and configure Oracle Database software.
Note
Install only Oracle Database 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").
If you install Oracle Database software on the shared disk, using Oracle ASM is not supported. Install the Oracle Database software on a local disk of each node when you use Oracle ASM.
If multiple Oracle homes are configured on one server, a different user name must be assigned for each Oracle home.
If you install Oracle Grid Infrastructure to use Oracle ASM on Oracle Database 11g R2/12c R1, 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 Oracle 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 database in addition to the values for PRIMECLUSTER.
The kernel parameter values vary depending on the implemented Oracle database versions.
Refer to the Oracle database 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 database. The user ID and the group ID must be the same on all the nodes.
Example
Create an operating system user account belonging to OSDBA group (dba) and Oracle Inventory group (oinstall).
# 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
Set up an environment variable of Oracle user.
Set the ORACLE_BASE, ORACLE_HOME and ORACLE_SID environment variables for your Oracle database environment.
Add $ORACLE_HOME/bin into the PATH environment variable.
If the directory where listener.ora is stored is not under $ORACLE_HOME/network/admin, set the TNS_ADMIN environment variable.
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 PATH=$ORACLE_HOME/bin:/usr/bin:/usr/ccs/bin:/usr/ucb; export PATH TNS_ADMIN=$ORACLE_HOME/network/admin2; export TNS_ADMIN
Information
For further details, refer to the Oracle Database manual.
Note
PRIMECLUSTER Wizard for Oracle controls Oracle database as the operating system user belonging to OSDBA group(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)
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
If you install it on the local disk, refer to the Oracle Database manual.
If you install it on the shared disk, refer to "Appendix D Using Oracle Database Software on shared disks”.
The database needs to be created on the shared disk when configuration of the cluster system is completed, not when Oracle Database software is installed. The details will be described later in this document(2.2.6 Oracle database Creation and Setting).