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.7 Oracle Database Creation and Setting").
In PRIMECLUSTER Wizard for Oracle, Environment that Oracle on shared disk is 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.
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
Before installing Oracle, it is necessary to change the “/etc/system” file and reboot the node.
/etc/services
Set up a port number for the Oracle listener.
Example
listener 1521/tcp oracle
Oracle User
Create a DBA (database administrator) 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/9.2.0; export ORACLE_HOME ORACLE_TERM=sun-cmd; export ORACLE_TERM ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data; export ORA_NLS33 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”.
See
For further details, refer to the Oracle manual.
Note
PRIMECLUSTER Wizard for Oracle controls Oracle as the Oracle DBA user.
Be sure to include “$ORACLE_HOME/bin” in the PATH environment variable of the DBA 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
Standby operation
Install Oracle using Oracle user access privileges. Install a program on the local disk of each node. 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.
Scalable operation
For information on how to install RAC, see the RAC Installation Guide.
See
For further details, refer to the Oracle manual.
