Deployment Guide

48 Deployment Guide
5 In the List of Cluster Databases window, select a RAC database from which to delete an instance.
If your user name is not operating-system authenticated, DBCA prompts you for a user name and
password for a database user with SYSDBA privileges.
6 Enter the user name sys and the password, and click Next .
The
List of Cluster Database Instances window appears, showing the instances associated with
the RAC database that you selected and the status of each instance.
7 Select the instance to delete and click Finish .
This instance cannot be the local instance from where you are running DBCA. If you select the local
instance, the DBCA displays an
Error dialog. If this occurs, click OK , select another instance, and
click
Finish .
If services are assigned to this instance, the
DBCA Services Management window appears. Use this
window to reassign services to other instances in the cluster database.
8 Verify the information about the instance deletion operation and click OK .
A progress bar appears while DBCA removes the instance and its Oracle Net configuration. When
the operation is completed, a dialog asks whether you want to perform another operation.
9 Click No to exit.
10 Verify that the node was removed by typing:
srvctl config database -d <database name>
Deleting a Node From the Database Layer
1 On the node being deleted, log in as oracle .
2 Type the following command, using the public name of the node you are deleting
(
node3-pub for example):
srvctl stop nodeapps -n node3-pub
3
On the node being deleted, log in as root .
4 Type the following command, using the public name of the node you are deleting
(
node3-pub for example):
/opt/oracle/product/10.1.0/db_1/install/rootdeletenode.sh node3-pub
The CRS node applications are deleted. Ignore any warnings observed.
5 If you wish to remove the Oracle database software, type the following command:
rm -rf /opt/oracle/product/10.1.0/db_1/*