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:
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.
Task |
For Instructions, Go To ... |
---|---|
(Optional) Install 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 |
Two possible configurations for Sun Cluster HA for Oracle Parallel Server disks are:
The VERITAS Volume Manager (VxVM) cluster functionality
Sun StorEdgeTM A3x00 with hardware RAID support
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.
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.
Use this procedure to install the packages needed to run Sun Cluster HA for OPS.
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.
Load the data services CD into the CD-ROM drive.
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.
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.
Go to "Installing the Oracle Software" to install the UDLM and Oracle software.
Use the procedures in this section to do the following:
Prepare the Sun Cluster nodes.
Install the Oracle UDLM software.
Install the Oracle RDBMS software.
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:
The Oracle user account and the dba group are set up correctly.
The system is configured to support the shared memory requirements of the UDLM.
Perform the following steps as superuser on each cluster node.
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.
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.
After setting up the cluster environment for OPS, install the UDLM software on each cluster node. For instructions, see your OPS installation documentation.
You must install the UDLM software on the local disk of each node.
Become superuser on a node in the cluster.
Install the UDLM software.
Refer to the appropriate OPS installation documentation.
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 |
Shut down and reboot all the nodes.
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 |
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.
Refer to your OPS installation documentation for instructions on installing the RDBMS software.
When installing the Oracle RDBMS software, create your Oracle database by using the instructions in the Oracle documentation.