Tuesday, July 19, 2011

Oracle RAC Frequently Used Commands Syntax



srvctl start instance -d (db_name) -i (inst_name)         Starts an instance
srvctl start database -d (db_name)                  Starts all instances
srvctl stop database -d (db_name)                  Stops all instances, closes database
srvctl stop instance -d (db_name) -i (inst_name)         Stops an instance
srvctl start service -d (db_name) -s (service_name)         Starts a service
srvctl stop service -d (db_name) -s (service_name)         Stops a service
srvctl status service -d (db_name)                  Checks status of a service
srvctl status instance -d (db_name) -i (inst_name)         Checks an individual instance
srvctl status database -d (db_name)                 Checks status of all instances
srvctl start nodeapps -n (node_name)                 Starts gsd, vip, listener, and ons
srvctl stop nodeapps -n (node_name)                 Stops gsd, vip and listener
srvctl relocate service -d (name) -s (service_name) -i (old_inst_name) -t (new_inst_name) Relocate a service

srvctl add database -d (name) -o (oracle_home)            Add database
srvctl add instance -d (name) -i (inst_name) -n (node_name)    Add instance
srvctl add service -d (name) -s (service_name) -r (preferred_list) -a (available_list)      Add service