< Previous  | TOC | Index | Next  >

Removing the Oracle Instance on the Node

Use the following procedures to remove the Oracle instance from the leaving node.

Disabling the Oracle instance

Use dbca to delete the Oracle instance, or use SQL statements to drop the log groups and disable the public thread.

Uninstalling Oracle (optional) if it is installed locally

Uninstalling Oracle from the node your are removing is optional.

• If you choose not to remove Oracle, and if Oracle is installed on a cluster file system, go to Stopping VCS and modifying the configuration.
• If you choose not to remove Oracle, and if Oracle is installed on your local system, go to Unlinking Veritas libraries from Oracle binary (optional).

If Oracle is installed locally and you choose to uninstall it, use the Oracle runInstaller utility. Run the utility on each system you are removing from a RAC cluster.

1. On one system, log in as oracle.
2. Set the DISPLAY variable.

   If you use the Bourne Shell (sh or ksh):

   $ DISPLAY=host:0.0;export DISPLAY

   If you use the C Shell (csh or tcsh):

   $ setenv DISPLAY host:0.0

3. Run the Oracle utility runInstaller:

   $ cd $ORACLE_BASE/oui/install

   $ ./runInstaller

   As the utility starts up, be sure to select the option to uninstall the Oracle software from the local node you are removing. Refer to the Oracle Installation Guide for additional information about running the utility.

Unlinking Veritas libraries from Oracle binary (optional)

Use this procedure only if you are not uninstalling Oracle from the node you are removing.

  Note   If Oracle is on cluster file system, or if you have uninstalled Oracle, skip to Stopping VCS and modifying the configuration.

Remove the links to the Veritas libraries and convert to Oracle single-instance binary. Use the following procedure on each system you are removing from the RAC cluster:

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

   $ cd $ORACLE_HOME/dbs/init$ORACLE_SID.ora

   $ vi init$ORACLE_SID.ora

   Set the cluster_database parameter to FALSE:

   cluster_database=FALSE

3. Change directories:

   $ cd $ORACLE_HOME/lib

4. Remove the file linked to the Veritas ODM library:

   $ rm libodm9.so

5. Copy file $ORACLE_HOME/lib/libodmd9.so to remove the ODM function:

   $ cp $ORACLE_HOME/lib/libodmd9.so $ORACLE_HOME/lib/libodm9.so

6. To convert from the Oracle RAC binary to the Oracle single-instance binary, enter:

   $ export LDR_CNTRL=MAXDATA=0x9000000

   $ cd $ORACLE_HOME/rdbms/lib

   $ make -f ins_rdbms.mk rac_off

   $ make -f ins_rdbms.mk ioracle

7. Verify that Oracle single-instance is configured. Use the command:

   $ dump -x64 -Hv $ORACLE_HOME/bin/oracle

   If Oracle RAC is configured, the list of libraries in the output contains:

   ..........

   libskgxp9.a

   libskgxn9.a

   .......

   These libraries are not listed for an Oracle single instance configuration. If there is no output, Oracle single-instance binary is configured.