Using Serviceguard Extension for RAC, 2nd Edition, February 2005 Update
Table Of Contents
- Using Serviceguard Extension for RAC
- 1 Introduction to Serviceguard Extension for RAC
- 2 Serviceguard Configuration for Oracle RAC
- Planning Database Storage
- Installing Serviceguard Extension for RAC
- Configuration File Parameters
- Creating a Storage Infrastructure with LVM
- Building Volume Groups for RAC on Mirrored Disks
- Building Mirrored Logical Volumes for RAC with LVM Commands
- Creating RAC Volume Groups on Disk Arrays
- Creating Logical Volumes for RAC on Disk Arrays
- Oracle Demo Database Files
- Displaying the Logical Volume Infrastructure
- Exporting the Logical Volume Infrastructure
- Installing Oracle Real Application Clusters
- Cluster Configuration ASCII File
- Creating a Storage Infrastructure with CVM
- Initializing the VERITAS Volume Manager
- Preparing the Cluster for Use with CVM
- Starting the Cluster and Identifying the Master Node
- Converting Disks from LVM to CVM
- Initializing Disks for CVM
- Creating Disk Groups for RAC
- Creating Volumes
- Oracle Demo Database Files
- Adding Disk Groups to the Cluster Configuration
- Using Packages to Configure Startup and Shutdown of RAC Instances
- Starting Oracle Instances
- Creating Packages to Launch Oracle RAC Instances
- Configuring Packages that Access the Oracle RAC Database
- running cluster:adding or removing packages
- Writing the Package Control Script
- Using Serviceguard Manager to Write the Package Control Script
- Using Commands to Write the Package Control Script
- Customizing the Package Control Script
- Optimizing for Large Numbers of Storage Units
- Customizing the Control Script for RAC Instances
- Configuring an Oracle RAC Instance Package
- Using Serviceguard Manager to a Configure Oracle RAC Instance Package
- Enabling DB Provider Monitoring
- 3 Maintenance and Troubleshooting
- Reviewing Cluster and Package States with the
- Managing the Shared Storage
- Removing ServiceGuard Extension for RAC from a System
- Monitoring Hardware
- Adding Disk Hardware
- Replacing Disks
- Replacement of I/O Cards
- Replacement of LAN Cards
- Monitoring RAC Instances
- A Blank Planning Worksheets
Serviceguard Configuration for Oracle RAC
Using Packages to Configure Startup and Shutdown of RAC Instances
Chapter 2 67
Information for Creating the Oracle RAC Instance Package on a
SGeRAC Node Use the following steps to set up the pre-package
configuration on a SGeRAC node:
1. Gather the RAC Instance SID_NAME. If you are using Serviceguard
Manager, this is in the cluster Properties.
Example: SID_NAME=ORACLE_TEST0
For an ORACLE RAC Instance for a two node cluster, each node
would have an SID_NAME.
2. Gather the RAC Instance package name for each node, which should
be the same as the SID_NAME for each node
Example: ORACLE_TEST0
3. Gather the shared volume group name for the RAC database. In
Serviceguard Manager, see cluster Properties.
Example: /dev/vgora92db
4. Create the Oracle RAC Instance Package directory
/etc/cmcluster/${SID_NAME}
Example: /etc/cmcluster/ORACLE_TEST0
5. If you are using the command line copy the Oracle shell script
template from the ECMT default source directory to the package
directory.
# cd /opt/cmcluster/toolkit/oracle
# cp oracle.sh /etc/cmcluster/${SID_NAME}/${SID_NAME}.sh
# chmod 755 /etc/cmcluster/${SID_NAME}/${SID_NAME}.sh
Example:
# cd /opt/cmcluster/toolkit/oracle
# cp oracle.sh /etc/cmcluster/ORACLE_TEST0/ORACLE_TEST0.sh
# chmod 755 /etc/cmcluster/ORACLE_TEST0/ORACLE_TEST0.sh
6. Gather the package service name for monitoring Oracle instance
processes. In Serviceguard Manager, this information can be found
under the “Services” tab.
SERVICE_NAME[0]=${SID_NAME}
SERVICE_CMD[0]=”etc/cmcluster/${SID_NAME}/${SID_NAME}.sh
monitor”
SERVICE_RESTART[0]=”3”