Taking Oracle and Sqlnet Resources Offline

1. Log in as root user to a system in the cluster.
2. On each node, take the Oracle and Sqlnet resources in the VCS configuration offline:
     # hares -offline VRT -sys galaxy
     # hares -offline rac -sys galaxy
     # hares -offline VRT -sys nebula
     # hares -offline rac -sys nebula
     # hares -offline LISTENER -sys galaxy
     # hares -offline LISTENER -sys nebula

   These commands stop the Oracle instances running on the specified systems.

Unlinking the Oracle Binary From VERITAS Libraries

If you uninstalled Oracle9i in your environment, proceed to Taking the Oracle Service Groups Offline.

1. Log in as the oracle user.
2. Using vi or another text editor, edit the init$ORACLE_SID.ora file:
     $ cd $ORACLE_HOME/dbs/
     $ vi init$ORACLE_SID.ora

   Set the cluster_database parameter to FALSE:

   
     cluster_database=FALSE
3. Navigate to the following directory:
     $ cd   $ORACLE_HOME/lib
4. Remove the file linked to the VERITAS ODM library.

   For PA systems:

   
     $ rm $ORACLE_HOME/lib/libodmd9.sl

   For IA systems:

   
     $ rm $ORACLE_HOME/lib/libodmd9.so
5. Copy the original ODM library file to remove the Veritas ODM function.

   For PA systems:

   
   $ cp $ORACLE_HOME/lib/libodmd9.sl.oracle
   $ORACLE_HOME/lib/libodmd9.sl

   For IA systems:

   
   $ cp $ORACLE_HOME/lib/libodmd9.so.oracle
   $ORACLE_HOME/lib/libodmd9.so
6. To convert from Oracle RAC binary to Oracle single-instance binary, enter:
     $ cd $ORACLE_HOME/rdbms/lib
     $ make -f ins_rdbms.mk rac_off
     $ make -f ins_rdbms.mk ioracle
7. If $ORACLE_HOME is located on the file systems of the local nodes, perform step 1 through step 6 on each of the other nodes.
8. To verify the state of the Oracle RAC configuration, type:
     $ ldd $ORACLE_HOME/bin/oracle | egrep "lltdb|vcsmm"
   • Oracle single-instance binary is configured if the command does not generate output.
   • Oracle RAC is enabled if the following output appears.

   For PA systems:

   
       /usr/lib/pa20_64/libvcsmm.1 =>  /usr/lib/pa20_64/libvcsmm.1
       /usr/lib/pa20_64/liblltdb.1 =>  /usr/lib/pa20_64/liblltdb.1

   For IA systems:

   
       /usr/lib/hpux64/libvcsmm.1 =>   /usr/lib/hpux64/libvcsmm.1
   /usr/lib/hpux64/liblltdb.so.1 => /usr/lib/hpux64/
   liblltdb.so.1