Srvctl
From Oracle FAQ
⧼orafaq-jumptonavigation⧽⧼orafaq-jumptosearch⧽
Starting and stopping resources
Stops all RAC instances:
$ srvctl stop database –d myracdb
Stops Listener, VIP, GSD, ONS:
$ srvctl stop nodeapps –n racnode1
Starts ASM on racnode1 and all required dependencies:
$ srvctl start asm –n racnode1
Starts one instance and all required dependencies:
$ srvctl start instance –d myracdb –i mydb1
Define a service
Create a new service:
$ srvctl add service -d mydb -s orderentry -r "mydb1,mydb2" -a "mydb1,mydb2" -P BASIC
Check its status:
$ srvctl status service -d mydb -s "orderentry" Service orderentry is not running.
Start the service:
$ srvctl start service -d mydb -s "orderentry"
Test if we can connect:
sqlplus scott/tiger@//node1/orderentry