Introduction

Stopping all RAC databases running on an ORACLE_HOME at once and saving the state before shutting them down is really helpfull when you are doing patching on a server.

In my case I have databases running on some nodes and not the others, it’s getting complicated to keep track of which database is running where. With this method you will shutdown all databases at once and keep track of the databases running on that node before shutting them down.

Stopping all RAC databases of an ORACLE_HOME

This command will stop all databases running on the ORACLE_HOME specified and save the state before the shutdown in a state file.

srvctl stop home -oraclehome /opt/oracle/base/product/12.1.0/dbhome_1 -node node1 -statefile /tmp/node1_stop.dmp

Starting all RAC databases of an ORACLE_HOME

This command uses a state file to restart all databases previously running on a node.

srvctl start home -oraclehome /opt/oracle/base/product/12.1.0/dbhome_1 -node node1 -statefile /tmp/node1_stop.dmp