PRIMECLUSTER Wizard for Oracle Configuration and Administration Guide 4.2 - Linux for Itanium -

2.2.2 Oracle Installation and Configuration

This section explains how to install and configure Oracle.

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 identical on all the nodes.

  The kernel parameters can be configured with the sysctl (8) utility when they are executed. The procedures for changing the kernel parameters and setting up the new kernel parameters are explained below.

  
  Before installing Oracle, it is necessary to change the "/etc/sysctl.conf" file and reboot the node.
  For semopm (the third value of "kernel.sem", specify a value of 4 or more.

  
  The following command enables the value of /etc/sysctl.conf for the kernel. You do not have to reconfigure the kernel.
  To change the kernel parameter while the OS is running, use sysctl (8). For details about sysctl (8), refer to the manual pages.

  #sysctl -p [filename] (If filename is omitted, read from /etc/sysctl.conf.)

  
  

• /etc/services

  Set up a port number for the Oracle listener.

  

  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.

  

  # groupadd -g <group ID> dba
  # groupadd -g <group ID> oinstall
  # useradd -g oinstall -G dba oracle
  # passwd oracle

  Normally, the group name should be "dba" and "oinstall".

  Set up an environment variable of an Oracle user.
  
  (.bash_profile)

  ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  ORACLE_HOME=/u01/app/oracle/product/10.2.0; export ORACLE_HOME
  ORACLE_SID=ora
  LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
  PATH=$ORACLE_HOME/bin:/usr/bin:/bin:/usr/bin/X11/:/usr/local/bin; export PATH

  

  • 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 userApplicatoin startup or shutdown.

  
  For further details, refer to the Oracle manual.

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, refer to the RAC Installation Guide.

  
  For further details, refer to the Oracle manual.