RAC

Server Status/Startup/Shutdown

# Status
srvctl status database -d <dbname>
srvctl config database -d <dbname>


# Shutdown
srvctl stop database -d <dbname>
srvctl stop database -d <dbname> -i <instance> -o immediate

# Startup
srvctl start database -d <dbname>
srvctl start database -d <dbname> -i <instance> -o immediate

CRS Commands

crsctl status resource

crsctl status type

crsctl status serverpool

crsctl status server


Recreate Srvctl Entry

# Verify config
srvctl config database -d MYDBNAME

# Remove current entry
srvctl remove database -d MYDBNAME

srvctl add database -d MYDBNAME -n MYDBNAME -o /u01/app/oracle/product/11.2.0/db_1 -p +ASMDATA/MYDBNAME/spfileMYDBNAME.ora -r PRIMARY -y automatic

# Add instances
srvctl add instance -d MYDBNAME -i MYDBNAME1 -n HOST1
srvctl add instance -d MYDBNAME -i MYDBNAME2 -n HOST2

# Add Diskgroups
srvctl modify database -d MYDBNAME -a "ASMDATA,ASMFLASH"

Scan Listener Status

$srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:1521
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:1521
$srvctl config scan
SCAN name: prod-scan.example.com, Network: 1/10.2.130.0/255.255.255.0/lan900
SCAN VIP name: scan1, IP: /prod-scan.example.com/10.2.130.90
SCAN VIP name: scan2, IP: /prod-scan.example.com/10.2.130.92
SCAN VIP name: scan3, IP: /prod-scan.example.com/10.2.130.91

References

Add DB to Oracle Restart