Top
PRIMECLUSTER Wizard for Oracle 4.5 Configuration and Administration Guide
FUJITSU Software

2.3.2 Oracle Database Software Installation and Configuration

Site Preparation

Install Oracle Grid Infrastructure and Oracle database referring to Oracle Database manuals and installation guides.

Oracle Grid Infrastructure installation

Install Oracle Grid Infrastructure by referring to the Oracle Grid Infrastructure manual and installation guide.

Note

  • Install Oracle Grid Infrastructure on a local disk of all nodes.

  • Check if root user access privileges can switch the user to the Grid user, using the su(1M) command.

    # su - <Grid user>
  • A command (e.g. script) that has interactive mode should not be described in Grid user's profile.
    (e.g. /etc/profile, .bash_profile, .cshrc, .profile)

  • Environment that Grid user's home directory and profile are located on the shared disk is not supported. Grid user's home directory and profile must be located on the local disk of each node.

Oracle Database installation

Install Oracle Database by referring to the Oracle Database manual and installation guide.

Note

  • Install Oracle Database on a local disk of all nodes.

  • 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.

Database creating and settings

Create a database by referring to the Oracle Database manual and installation guide.

Note

  • If multiple Oracle homes are configured on one server, a different Oracle RAC instance name must be assigned for each Oracle home.

  • If multiple Oracle homes are configured on one server, a different listener name must be assigned for each Oracle home.

Information

In scalable operation with Oracle RAC 11g R2/12c R1, the RMS resource name is generated based on the resource name of Oracle RAC as follows:

Setting change

Operation check

PRIMECLUSTER Wizard for Oracle starts and stops the Oracle RAC instance (database) and Oracle listener after changing from the root user to the Oracle user by using su(1M). Check if you can start and stop the Oracle RAC instance and Oracle listener manually after changing from the root user to the Oracle user by using su(1M) on all nodes in Oracle RAC.
Also, check if crsctl status resource command can be executed by Grid user, and srvctl config database command can be executed by Oracle user.

Example

The following example shows the operation results:

# su - <Grid user>
$ srvctl start listener -n $NODE_NAME -l $LSNR_NAME
$ srvctl stop listener -n $NODE_NAME -l $LSNR_NAME
# su - <Oracle user>
$ srvctl start instance -d $DB_NAME -i $ORACLE_SID
$ srvctl stop instance -d $DB_NAME -i $ORACLE_SID
# su - <Grid user>
$ crsctl status resource -t
-------------------------------------------------------------------
NAME           TARGET  STATE        SERVER          STATE_DETAILS
-------------------------------------------------------------------
Local Resources
-------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       node1
               ONLINE  ONLINE       node2
ora.LISTENER.lsnr
               ONLINE  ONLINE       node1
               ONLINE  ONLINE       node2
ora.asm
               ONLINE  ONLINE       node1
               ONLINE  ONLINE       node2
ora.eons
               ONLINE  ONLINE       node1
               ONLINE  ONLINE       node2
ora.gsd
               OFFLINE OFFLINE      node1
               OFFLINE OFFLINE      node2
ora.net1.network
               ONLINE  ONLINE       node1
               ONLINE  ONLINE       node2
ora.ons
               ONLINE  ONLINE       node1
               ONLINE  ONLINE       node2
-------------------------------------------------------------------
Cluster Resources
-------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       node1
ora.oc4j
      1        OFFLINE OFFLINE
ora.racdb.db
      1        ONLINE  ONLINE       node1         Open
      2        ONLINE  ONLINE       node2         Open
ora.scan1.vip
      1        ONLINE  ONLINE       node1
ora.node1.vip
      1        ONLINE  ONLINE       node1
ora.node2.vip
      1        ONLINE  ONLINE       node2
$
# su - <Oracle user>
$ srvctl config database
racdb
$

Define the full path of the log file

Define the full path of the alert log and the listener log in /opt/FJSVclora/etc/clgetoralog.conf. See the Note in “4.5 clgetoralog - Collect Troubleshooting Information" for details.