Thursday, September 29, 2011

Starting/Stopping a RAC Instance

2-node RAC cluster setup with instances RAC1 on node rac01 and RAC2 on node rac02 and ORACLE_UNQNAME=RAC.  Need to shutdown RAC2 on node rac02 so the server can brought down for system maintenance.

Stop the instance on rac02 first as oracle
$ cd $ORACLE_HOME/bin

$ srvctl stop instance -d RAC -i RAC2

Check the status of the instance
$ srvctl status database -d RAC
Instance RAC1 is running on node rac01
Instance RAC2 is running on node rac02

Now stop the cluster services on rac02 as root

# cd /opt/app/11.2.0/grid/bin

# ./crsctl stop cluster -n rac02

After maintenance cycle is complete, start the cluster on node rac02
# ./crsctl start cluster -n rac02

Start the database instance RAC2 on node rac02
$ cd $ORACLE_HOME/bin
srvctl start instance -d rac -i RAC2

Start the EM console is necessary
$ emctl start dbconsole

Log location for OEM are located here:
$ORACLE_HOME/rac01_RAC/sysman/log
and
$ORACLE_HOME/rac02_RAC/sysman/log

No comments:

Post a Comment