Owner's Manual

40 Deployment Guide
6 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, the DBCA prompts you for a user name
and password for a database user with SYSDBA privileges.
7 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.
8 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.
9 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 complete, a dialog asks whether you want to perform another operation.
10 Click No to exit.
11 Ty p e srvctl config database -d <database name> to verify that the node was removed.
Deleting the 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/*