Sun Cluster 3.0 Data Services Installation and Configuration Guide

Chapter 8 Installing and Configuring Sun Cluster HA for Oracle Parallel Server

This chapter describes the steps for installing and configuring Sun Cluster HA for Oracle Parallel Server (OPS) on your Sun Cluster servers. It contains the following procedures:

Overview

You install and configure OPS by using the procedures in the Oracle documentation. Although OPS is not registered with or managed by the Sun Cluster Resource Group Manager (RGM), it depends on the RGM to query cluster information.

You can configure OPS to use the shared disk architecture of Sun Cluster. In this configuration, a single database is shared among multiple instances of OPS that access the database concurrently. Conflicting access to the same data is controlled by means of the Oracle UNIX Distributed Lock Manager (UDLM). If a process or a node crashes, the UDLM is reconfigured to recover from the failure.

In the event of a node failure in an OPS environment, you can configure Oracle clients to reconnect to the surviving server without the use of the IP failover used by Sun Cluster failover data services. This failover process is described in the Sun Cluster 3.0 Concepts document.In an OPS environment, multiple Oracle instances cooperate to provide access to the same shared database. The Oracle clients can access the database by using any of the instances. Thus, if one or more instances have failed, clients can continue to access the database by connecting to a surviving instance.

Installing and Configuring Sun Cluster HA for Oracle Parallel Server

Table 8-1 Task Map: Installing and Configuring Sun Cluster HA for Oracle Parallel Server

Task 

For Instructions, Go To ... 

(Optional) Install volume management software 

"Installing Volume Management Software"

Install Sun Cluster HA for Oracle Parallel Server packages 

"How to Install Sun Cluster HA for Oracle Parallel Server Packages"

Install the UNIX Distributed Lock Manager and Oracle software 

"Installing the Oracle Software"

Installing Volume Management Software

Two possible configurations for Sun Cluster HA for Oracle Parallel Server disks are:

How to Install Volume Management Software

If you are using VxVM, you must first install and configure the VxVM software on the cluster nodes. For details, see the VxVM appendix in the Sun Cluster 3.0 Installation Guide and your VxVM documentation. A separate license is required for VxVM cluster operations; the Oracle documentation describes the licensing requirements.


Caution - Caution -

Failure to install the VxVM cluster license correctly might result in a panic if OPS support is installed without VxVM functioning properly. Prior to installing the OPS packages, run the vxlicense check command to ensure that a valid cluster license is installed.


If you are using the Sun StorEdge A3x00 with hardware RAID support, you have no volume management software to install. In that case, you must install RAID Manager software for A3x00.

Installing Sun Cluster HA for Oracle Parallel Server Packages

Use this procedure to install the packages needed to run Sun Cluster HA for OPS.

How to Install Sun Cluster HA for Oracle Parallel Server Packages

To complete this procedure, you need the Sun Cluster data services CD. Perform this procedure on all cluster nodes that can run Sun Cluster HA for Oracle Parallel Server.

  1. Load the data services CD into the CD-ROM drive.

  2. Install the Sun Cluster HA for Oracle Parallel Server packages.

    The packages vary, depending on whether you are using hardware RAID or VERITAS Volume Manager for your volume manager.

    1. If you are using hardware RAID as your volume manager, install as follows:


      # pkgadd -d . SUNWscucm SUNWudlm SUNWudlmr SUNWschwr
      
    2. If you are using VERITAS Volume Manager as your volume manager, install as follows:


      # pkgadd -d . SUNWscucm SUNWudlm SUNWudlmr SUNWcvmr SUNWcvm
      

Caution - Caution -

After you have installed the Sun Cluster HA for Oracle Parallel Server packages, do not reboot the nodes until the Oracle UDLM package is installed, otherwise a panic occurs.


Where to Go from Here

Go to "Installing the Oracle Software" to install the UDLM and Oracle software.

Installing the Oracle Software

Use the procedures in this section to do the following:

How to Prepare the Sun Cluster Nodes

For the UDLM software to run correctly, sufficient shared memory must be available on all cluster nodes. See the OPS CD for all installation instructions. To prepare the Sun Cluster nodes, you must ensure that:

Perform the following steps as superuser on each cluster node.

  1. On each node, create an entry for the database administrator group in the /etc/group file and add potential users to the group.

    This group normally is named dba. Verify that root and oracle are members of the dba group and add entries as necessary for other DBA users. Verify that the group IDs are the same on all the nodes that run Sun Cluster HA for Oracle Parallel Server. For example:


    dba:*:520:root,oracle 

    You can make the name service entries in a network name service (for example, NIS or NIS+) so that the information is available to Sun Cluster HA for Oracle Parallel Server clients. You can also make entries in the local /etc files to eliminate dependency on the network name service.

  2. On each node, create an entry for the Oracle user ID (the group and password) in the /etc/passwd file and run the pwconv(1M) command to create an entry in the /etc/shadow file.

    This Oracle user ID is normally oracle. For example:


    # useradd -u 120 -g dba -d /orahome oracle
    

    Ensure that the user IDs are the same on all the nodes that run Sun Cluster HA for Oracle Parallel Server.

Where to Go from Here

After setting up the cluster environment for OPS, install the UDLM software on each cluster node. For instructions, see your OPS installation documentation.

How to Install the UDLM Software

You must install the UDLM software on the local disk of each node.

  1. Become superuser on a node in the cluster.

  2. Install the UDLM software.

    Refer to the appropriate OPS installation documentation.

  3. Update /etc/system with the shared memory configuration information.

    You must configure these parameters based on the resources available in the cluster. Decide on the appropriate values, but be sure that the UDLM can create a shared memory segment according to its configuration requirements. The following is an example of the entries to configure in /etc/system:


    *SHARED MEMORY/ORACLE
    set shmsys:shminfo_shmmax=268435456
    set semsys:seminfo_semmap=1024
    set semsys:seminfo_semmni=2048
    set semsys:seminfo_semmns=2048
    set semsys:seminfo_semmsl=2048
    set semsys:seminfo_semmnu=2048
    set semsys:seminfo_semume=200
    set shmsys:shminfo_shmmin=200
    set shmsys:shminfo_shmmni=200
    set shmsys:shminfo_shmseg=200
    forceload: sys/shmsys
    forceload: sys/semsys
    forceload: sys/msgsys

  4. Shut down and reboot all the nodes.


    Caution - Caution -

    Before rebooting, ensure that the VxVM software is installed correctly and the license for cluster operation is valid. Also ensure that the UDLM software is installed and configured correctly, otherwise a panic occurs.


    Refer to scshutdown(1M) for details.

    First, shut down all of the nodes by typing the following command on one node:


    phys-schost-1# scshutdown -g0 -y
    

    For each node, type the following command at the ok prompt:


    ok boot
    

Where to Go from Here

After you have installed the UDLM software on each cluster node and rebooted all the nodes, install the Oracle RDBMS software. For instructions, see the OPS installation documentation.

How to Install the Oracle RDBMS Software

Refer to your OPS installation documentation for instructions on installing the RDBMS software.

Where to Go from Here

When installing the Oracle RDBMS software, create your Oracle database by using the instructions in the Oracle documentation.