RAC
Submitted by dave on Wed, 12/04/2013 - 16:45
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