I have given below some of the important health-checks that can be done using SRVCTL(Server Control) in Oracle 11gR2 RAC:
oracle@dcpdb1 [/home/oracle]$ srvctl status database -d DCPDB
Instance dcpdb1 is running on node dcpdb1
Instance dcpdb2 is running on node dcpdb2
oracle@dcpdb1 [/home/oracle]$ srvctl status LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): dcpdb1,dcpdb2
Listener LISTENERDB is enabled
Listener LISTENERDB is running on node(s): dcpdb1,dcpdb2
oracle@dcpdb1 [/home/oracle]$ srvctl status vip -i DCPDB1
VIP dcpdb1-vip is enabled
VIP dcpdb1-vip is running on node: dcpdb1
oracle@dcpdb1 [/home/oracle]$ srvctl status database -d DCPDB
Instance dcpdb1 is running on node dcpdb1
Instance dcpdb2 is running on node dcpdb2
Listener LISTENER is enabled
Listener LISTENER is running on node(s): dcpdb1,dcpdb2
Listener LISTENERDB is enabled
Listener LISTENERDB is running on node(s): dcpdb1,dcpdb2
oracle@dcpdb1 [/home/oracle]$ srvctl status vip -i DCPDB1
VIP dcpdb1-vip is enabled
VIP dcpdb1-vip is running on node: dcpdb1
oracle@dcpdb1 [/home/oracle]$ srvctl status vip -i DCPDB2
VIP dcpdb2-vip is enabled
VIP dcpdb2-vip is running on node: dcpdb2
oracle@dcpdb1 [/home/oracle]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node dcpdb1
Scan status output should be the following:
[oracle@rac2 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac2
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac1
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac1
oracle@dcpdb1 [/home/oracle]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node dcpdb1
Scan listener output should be the following:
[oracle@rac2 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
oracle@dcpdb1 [/home/oracle]$ srvctl status nodeapps
VIP dcpdb1-vip is enabled
VIP dcpdb1-vip is running on node: dcpdb1
VIP dcpdb2-vip is enabled
VIP dcpdb2-vip is running on node: dcpdb2
Network is enabled
Network is running on node: dcpdb1
Network is running on node: dcpdb2
GSD is enabled
GSD is not running on node: dcpdb1
GSD is not running on node: dcpdb2
ONS is enabled
ONS daemon is running on node: dcpdb1
ONS daemon is running on node: dcpdb2
eONS is enabled
eONS daemon is running on node: dcpdb1
eONS daemon is running on node: dcpdb2
oracle@dcpdb1 [/home/oracle]$ srvctl status server -n DCPDB1,DCPDB2
Server name: dcpdb1
Server state: ONLINE
Server name: dcpdb2
Server state: ONLINE
oracle@dcpdb1 [/home/oracle]$ srvctl config database -d DCPDB
Database unique name: dcpdb
Database name: dcpdb
Oracle home: /u02/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/dcpdb/spfiledcpdb.ora
Domain: nblitd.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: dcpdb
Database instances: dcpdb1,dcpdb2
Disk Groups: DATA,FRA
Services:
Database is administrator managed
oracle@dcpdb1 [/home/oracle]$ srvctl status diskgroup -g DATA
Disk Group DATA is running on dcpdb1,dcpdb2
oracle@dcpdb1 [/home/oracle]$ srvctl status diskgroup -g FRA
Disk Group FRA is running on dcpdb1,dcpdb2
Smile!!!!!!!!!!!
Very nice article! Thanks for sharing!
ReplyDeleteDesong Liu
thanks Rashid
ReplyDelete