A How to Stop Processes in an Existing Oracle Real Application Clusters Database

This appendix describes how to stop all processes in an Oracle Real Application Clusters (RAC) database, in preparation for installing Database Vault.

Shut down the following Oracle Database services before modifying the Oracle Database software:

1. Shut down any processes in the Oracle home on each node that can access a database. For example, you need to shut down Oracle Enterprise Manager Database Control.

   C:\> ORACLE_HOME\bin\emctl stop dbconsole
   
   

   Note:

   Before you shut down any processes that are monitored by Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime, rather than an unplanned system outage.

2. Shut down all RAC instances on all nodes. To shut down all RAC instances for a database, enter the following command, where db_name is the name of the database:

   C:\> ORACLE_HOME\bin\srvctl stop database -d db_name -c "SYS/password AS SYSDBA"
   
   

3. Stop all node applications on all nodes. To stop node applications running on a node, enter the following command, where node is the name of the node where the applications are running:

   C:\> ORACLE_HOME\bin\srvctl stop nodeapps -n node 
   

4. Stop the OracleServiceSID service on all nodes. You can access the Services window from the Control Panel.