Oracle RAC SRVCTL operations

Below, a few commands to manage databases with srvctl utility.

Show registered databases in OCR repository.

[grid@racnode1 ~]$ srvctl config database
RACDB
RCAT
RMANCAT

Show configuration details of a database.

[grid@racnode1 ~]$ srvctl config database -d racdb
Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/spfileRACDB.ora
Domain: test
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RACDB
Database instances: RACDB1,RACDB2
Disk Groups: DATA,FRA
Services: 
Database is administrator managed

Change management policy mode.

[grid@racnode1 ~]$ srvctl modify database -d racdb -y MANUAL
[grid@racnode1 ~]$ srvctl config database -d racdb
Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/spfileRACDB.ora
Domain: test
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: MANUAL
Server pools: RACDB
Database instances: RACDB1,RACDB2
Disk Groups: DATA,FRA
Services: 
Database is administrator managed

Change start option mode.

[grid@racnode1 ~]$ srvctl modify database -d racdb -s mount
[grid@racnode1 ~]$ srvctl config database -d racdb
Database unique name: RACDB
Database name: RACDB
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/RACDB/spfileRACDB.ora
Domain: test
Start options: mount
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: RACDB
Database instances: RACDB1,RACDB2
Disk Groups: DATA,FRA
Services: 
Database is administrator managed

Show database status.


[grid@racnode1 ~]$ srvctl status database -d racdb
Instance RACDB1 is running on node racnode1
Instance RACDB2 is not running on node racnode2

Show nodeapps status.


[grid@racnode1 ~]$ srvctl status nodeapps
VIP racnode1-vip is enabled
VIP racnode1-vip is running on node: racnode1
VIP racnode2-vip is enabled
VIP racnode2-vip is running on node: racnode1
Network is enabled
Network is running on node: racnode1
Network is not running on node: racnode2
GSD is disabled
GSD is not running on node: racnode1
GSD is not running on node: racnode2
ONS is enabled
ONS daemon is running on node: racnode1
ONS daemon is not running on node: racnode2
eONS is enabled
eONS daemon is running on node: racnode1
eONS daemon is not running on node: racnode2

Start / Stop database.

[oracle@racnode1 ~]$ srvctl start database -d racdb

[oracle@racnode1 ~]$ srvctl stop database -d racdb

Stop database with options.

[oracle@racnode1 ~]$ srvctl stop database -d racdb -o immediate

Start / Stop database on a node.

[oracle@racnode1 ~]$ srvctl start instance -d RACDB -i RACDB1

[oracle@racnode1 ~]$ srvctl stop instance -d RACDB -i RACDB1

Stop database with abort option on a node.

[oracle@racnode1  ~]$ srvctl stop instance -d RACDB -i RACDB1 -o abort