< Previous  | TOC | Index | Next  >

Uninstalling DBE/AC for Oracle RAC

Uninstalling Veritas DBE/AC 3.5 for Oracle RAC involves the following tasks:

• Stopping gsd (for Oracle9i)
• Stopping applications using CFS
• Unmounting CFS file systems outside of VCS control
• Taking resources offline
• Stopping CRS outside of VCS control (for Oracle 10g)
• Unlinking the Oracle binary from Veritas libraries
• Taking the Oracle service groups offline
• Removing the packages using the uninstallDBAC script

You do not have to remove the Oracle database or uninstall Oracle to upgrade SF Oracle RAC. Refer to the Veritas Database Edition / Advanced Cluster 3.5 for Oracle RAC documentation for more details on uninstalling the product.

Stopping gsd (for Oracle9i)

For Oracle9i, you must stop the gsd processes on all nodes.

 To stop gsd

• As oracle user, stop gsd processes on each node.

  To determine if gsd processes are running, type:

  $ $ORACLE_HOME/bin/gsdctl stat

  If gsd processes are running, stop them:

  $ $ORACLE_HOME/bin/gsdctl stop

Stopping applications using CFS

 To stop applications using CFS

• Stop all applications using CFS mounts outside of VCS control. Ensure processes do not use the CFS mount point.

  To stop the processes using the CFS mount point, use the application-specific commands.

Unmounting CFS file systems outside of VCS control

On each node, unmount any CFS file systems outside of VCS control.

 To unmount CFS file systems that are outside of VCS control

1. Determine the file systems to unmount by checking the /etc/mnttab file. For example:

   # cat /etc/mnttab | grep vxfs | grep cluster

   The output shows each line of the /etc/mnttab file that contains an entry for a VxFS file system mounted in cluster mode.

2. To unmount each of the file systems listed in the output, specify the appropriate mount point:

   # umount mount_point

Taking resources offline

Depending on the Oracle version you use, you must take the appropriate resources offline.

 To take the resources offline

1. Log in as superuser to a system in the cluster.
2. On each node, take the following resources in the VCS configuration offline:
   • For Oracle9i, take the Oracle and Sqlnet resources offline. For example:

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

   • For Oracle 10g, take the Oracle and cssd resources offline. For example:

     To take the Oracle resources offline, run the following commands:

     # hares -offline VRT -sys galaxy

     # hares -offline rac -sys galaxy

     # hares -offline VRT -sys nebula

     # hares -offline rac -sys nebula

     To take the cssd resources offline, run the following commands:

     # hares -offline cssd-resource1 -sys galaxy

     # hares -offline cssd-resource1 -sys nebula

Stopping CRS outside of VCS control (for Oracle 10g)

 TO stop CRS outside of VCS control

• If the CRS is outside of VCS control, enter the following command to take CRS offline:

  # /sbin/init.d/init.crs stop

Unlinking the Oracle binary from Veritas libraries

If you uninstalled Oracle in your environment, proceed to take the Oracle service groups offline.

See Taking the Oracle service groups offline

 To unlink the Oracle binary from Veritas libraries

1. Log in as the oracle user.
2. Using vi or another text editor, edit the Oracle parameter file:

   $ cd $ORACLE_HOME/dbs/

   $ vi init$ORACLE_SID.ora

3. Set the cluster_database parameter to FALSE in the Oracle parameter file.

   cluster_database=FALSE

4. Navigate to the following directory:

   $ cd $ORACLE_HOME/lib

5. Link the original ODM library file to remove the Veritas ODM function.
   • For Oracle9i:

      

     PA systems	$ ln -s $ORACLE_HOME/lib/libodmd9.sl \ $ORACLE_HOME/lib/libodm9.sl
     IA systems	$ ln -s $ORACLE_HOME/lib/libodmd9.so \ $ORACLE_HOME/lib/libodm9.so

   • For Oracle 10g:

      

     PA systems	$ ln -s $ORACLE_HOME/lib/libodmd10.sl \ $ORACLE_HOME/lib/libodm10.sl
     IA systems	$ ln -s $ORACLE_HOME/lib/libodmd10.so \ $ORACLE_HOME/lib/libodm10.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"

9. Review the output of the command that you executed to verify the state:
   • If the command does not generate output, then Oracle single-instance binary is configured successfully.
   • If the command generates the following output, then Oracle RAC is still enabled.

      

     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
     IA systems	/usr/lib/hpux64/libvcsmm.1 => /usr/lib/hpux64/libvcsmm.1 /usr/lib/hpux64/liblltdb.so.1 => /usr/lib/hpux64/liblltdb.so.1

Taking the Oracle service groups offline

 To take the Oracle service groups offline

1. Log in as superuser on one cluster system.
2. Take the Oracle database service groups in the VCS configuration offline. For example:

   # hagrp -offline oradb1_grp -sys galaxy

   # hagrp -offline oradb2_grp -sys galaxy

   # hagrp -offline oradb1_grp -sys nebula

   # hagrp -offline oradb2_grp -sys nebula

   These commands take the Oracle service groups, including all their configured resources, offline.

Removing the packages using the uninstallDBAC script

The uninstallDBAC script removes packages installed by installDBAC on all systems in the cluster. This script stops VCS and takes all service groups in the VCS configuration offline on each node.

 To remove the packages using the uninstallDBAC script

1. As superuser, change to the directory containing the uninstallDBAC program.

   # cd /opt/VRTSvcs/install

2. Start uninstallDBAC:

   # ./uninstallDBAC

3. The script begins by referring you to the appropriate chapters in this document and describing the packages it is to remove:

   Thank You for using the VERITAS Database Edition/Advanced

   Cluster. Please ensure that you have read the uninstallation

   chapter (to uninstall from the entire cluster) or the chapter

   on removing DBE/AC cluster nodes (to uninstall from selected

   nodes) in the DBE/AC Installation and Configuration Guide.

   The following packages will be removed:

VRTScavf VRTSdbac VRTSgab VRTSglm VRTSgms

VRTSllt VRTSodm VRTSperl VRTSvcs VRTSvcsag

VRTSvcsdc VRTSvcsmg VRTSvcsmn VRTSvcsor

The uninstallation procedure is interactive and requires

responses to queries.

Continue? [Y/N] :y

The following packages (and associated patches) used by DBE/AC are not removed by the uninstallDBAC script: VRTSvxvm, VRTSvmpro, VRTSfspro, VRTSob, VRTSobgui, and VRTSvxfs.

4. The script lists the systems in order from which it is to remove the packages, and creates files for the logging of the uninstallation activities:

   The packages will be removed on following nodes in the order

   given below:

   galaxy

   nebula

5. Note that the installation actions are recorded in a log:

   The output of the operations are temporarily being logged to

   /var/tmp/uninstallDBAC_062403_091711/logfile

6. The script verifies communications between the local system and the remote systems:

   Checking communication with nebula

   Pinging nebula

   Checking remsh connectivity............................... OK

   Communication check completed successfully

7. The script stops VCS and unconfigures DBE/AC drivers on each system:

   Stopping VCS on all systems..

   VCS successfully stoppped on system galaxy

   VCS successfully stoppped on system nebula

   Unconfiguring DBE/AC drivers on galaxy

   Unconfiguring CM driver ............................. Done

   Unconfiguring VXFEN driver ...........................Done

   Unconfiguring ODM ...................................Done

   Closing CFS Port .................................... Done

   Closing QLOG Port ................................... Done

   Unconfiguring DBE/AC drivers on nebula

   Unconfiguring CM driver ..............................Done

   Unconfiguring VXFEN driver ...........................Done

   Unconfiguring ODM ...................................Done

   Closing CFS Port .................................... Done

   Closing QLOG Port ................................... Done

8. The script verifies whether the packages to be uninstalled are required or depended upon by other packages. It copies scripts and checks for packages on each node:

   Checking galaxy

   Checking nebula

9. The script removes VRTScavf, VRTSglm, VRTSgms, and VRTSodm packages:

   Removing VRTScavf VRTSglm VRTSgms VRTSodm from galaxy

   Removing VRTScavf ...................................... Done

   Removing VRTSglm ....................................... Done

   Removing VRTSgms ....................................... Done

   Removing VRTSodm ....................................... Done

   Removing VRTScavf VRTSglm VRTSgms VRTSodm from nebula

   Removing VRTScavf ...................................... Done

   Removing VRTSglm ....................................... Done

   Removing VRTSgms ....................................... Done

   Removing VRTSodm ....................................... Done

10. The script displays the cluster information and prompts you to indicate that you want VCS packages uninstalled:

    VCS configuration files exist on this system with the following

    information:

    Cluster Name: rac_cluster101

    Cluster ID Number: 101

    Systems: galaxy nebula

    Service Groups: cvm oradb1_grp oradb2_grp

    Do you want to uninstall VCS from all of the systems in this

    cluster? (Y) y

11. The script checks for the operating system level and for system-to-system communications:

    Checking OS version on galaxy ................... HP-UX B.11.11

    Verifying communication with nebula ........... ping successful

    Attempting remsh with nebula ................. remsh successful

    Checking OS version on nebula ................... HP-UX B.11.11

    Creating /tmp subdirectory on nebula../tmp subdirectory created

    Using /usr/bin/remsh and /usr/bin/rcp to communicate with

    nebula

    Communication check completed successfully

12. The script checks currently installed DBE/AC packages on each system:

    Checking current installation on galaxy:

    Checking product mode ..................... DBE/AC licensed

    Checking VRTSdbac ................... version 3.5 installed

    Checking VRTSdbac dependencies ....................... none

    Checking VRTSvcsor .................. version 3.5 installed

    Checking VRTSvcsor dependencies ...................... none

    Checking VRTSvcsmn .................. version 3.5 installed

    .

    .

    Checking current installation on nebula:

    Checking VRTSdbac ................... version 3.5 installed

    Checking VRTSdbac dependencies ....................... none

    Checking VRTSvcsor .................. version 3.5 installed

    Checking VRTSvcsor dependencies ...................... none

    Checking VRTSvcsmn .................. version 3.5 installed

    Checking VRTSvcsmn dependencies ...................... none

    .

    .

    .

    Uninstallation check completed successfully

13. The DBE/AC processes are stopped on each node:

    Stopping DBE/AC processes on galaxy:

    Checking DBE/AC ............................... not running

    Checking CmdServer ................................ running

    Killing CmdServer .................................... Done

    Checking Web GUI processes .................... not running

    Checking notifier processes ................... not running

    Checking VCSMM ................................ not running

    Checking VXFEN ................................ not running

    Checking LMX .................................. not running

    Checking GAB ............................ GAB module loaded

    Stopping GAB ......................................... Done

    Unloading GAB module on galaxy ........................Done

    Checking LLT ............................ LLT module loaded

    Stopping LLT ......................................... Done

    Unloading LLT module on galaxy ....................... Done

    Stopping DBE/AC processes on nebula:

    Checking DBE/AC ............................... not running

    Checking CmdServer ................................ running

    Killing CmdServer .................................... Done

    Checking Web GUI processes .................... not running

    Checking notifier processes ................... not running

    Checking VCSMM ................................ not running

    Checking VXFEN ................................ not running

    Checking LMX .................................. not running

    Checking GAB ............................ GAB module loaded

    Stopping GAB ......................................... Done

    Unloading GAB module on nebula ....................... Done

    Checking LLT ............................ LLT module loaded

    Stopping LLT ......................................... Done

    Unloading LLT module on nebula ....................... Done

14. VCS and DBE/AC related packages are removed from each system:

    Uninstalling DBE/AC on galaxy:

    Removing VRTSdbac package ............................ Done

    Removing VRTSvcsor package ........................... Done

    Removing VRTSvcsmn package ........................... Done

    Removing VRTSvcsdc package ........................... Done

    Removing VRTSvcsag package ........................... Done

    Removing VRTSvcsmg package ........................... Done

    Removing VRTSvcs package ............................. Done

    Removing VRTSgab package ............................. Done

    Removing VRTSllt package ............................. Done

    Removing VRTSperl package ............................ Done

    Uninstalling DBE/AC on nebula:

    Removing VRTSdbac package ............................ Done

    Removing VRTSvcsor package ........................... Done

    Removing VRTSvcsmn package ............................Done

    Removing VRTSvcsdc package ........................... Done

    Removing VRTSvcsag package ........................... Done

    Removing VRTSvcsmg package ........................... Done

    Removing VRTSvcs package ............................. Done

    Removing VRTSgab package ..............................Done

    Removing VRTSllt package ............................. Done

    Removing VRTSperl package ............................ Done

    DBE/AC configuration files are backed up with a

    .prev.vcs_racluster extension

    A DBE/AC uninstall report has been saved at:

    /var/VRTSvcs/uninstallvcsReport

    DBE/AC uninstallation completed successfully

    End of DBE/AC Uninstallation: Fri May 26 09:32:04 PDT 2006

    IMPORTANT: Check the following log files for any errors/warnings:

    /var/tmp/uninstallDBAC_052606_093204/logfile

    /var/VRTSvcs/uninstallvcsReport*

    /var/adm/sw/swremove.log (on all cluster nodes)