oracle10g的时候查看resource用 crs_stat -t比较多.
到了oracle11g后查看resource 用 crsctl stat res -t
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.LISTENER.lsnr
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.OCR_VOT.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ORADATA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.asm
ONLINE ONLINE xxxxxdb1 Started
ONLINE ONLINE xxxxxdb2
ora.eons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.gsd
OFFLINE OFFLINE xxxxxdb1
OFFLINE OFFLINE xxxxxdb2
ora.net1.network
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xxxxxdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE xxxxxdb2
ora.xxxxxdb.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE Instance Shutdown
ora.xxxxxdb1.vip
1 ONLINE ONLINE xxxxxdb1
ora.xxxxxdb2.vip
1 ONLINE ONLINE xxxxxdb2
其中 ora.xxxxxdb.db显示为offline状态,其实用sqlplus 登录两个节点查看instance的状态都为open
这个应该和srvctl config配置有关系。
[root@xxxxxdb2 ~]# srvctl start instance -d xxxxxdb -n xxxxxdb2 -o open
执行这个命令后xxxxxdb2 的状态为online,并且为open.
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.LISTENER.lsnr
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.OCR_VOT.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ORADATA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.asm
ONLINE ONLINE xxxxxdb1 Started
ONLINE ONLINE xxxxxdb2
ora.eons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.gsd
OFFLINE OFFLINE xxxxxdb1
OFFLINE OFFLINE xxxxxdb2
ora.net1.network
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xxxxxdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE xxxxxdb2
ora.xxxxxdb.db
1 OFFLINE OFFLINE
2 ONLINE ONLINE xxxxxdb2 Open
ora.xxxxxdb1.vip
1 ONLINE ONLINE xxxxxdb1
ora.xxxxxdb2.vip
1 ONLINE ONLINE xxxxxdb2
[root@xxxxxdb2 ~]# srvctl start instance -d xxxxxdb -i xxxxxdb1 -o open
执行这个命令后xxxxxdb1 的状态为online,并且为open. 但是查看 xxxxxdb1 的alert log,instance会突然abort,让后重新启动。
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.LISTENER.lsnr
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.OCR_VOT.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ORADATA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.asm
ONLINE ONLINE xxxxxdb1 Started
ONLINE ONLINE xxxxxdb2
ora.eons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.gsd
OFFLINE OFFLINE xxxxxdb1
OFFLINE OFFLINE xxxxxdb2
ora.net1.network
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xxxxxdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE xxxxxdb2
ora.xxxxxdb.db
1 ONLINE ONLINE xxxxxdb1 Open
2 ONLINE ONLINE xxxxxdb2 Open
ora.xxxxxdb1.vip
1 ONLINE ONLINE xxxxxdb1
ora.xxxxxdb2.vip
1 ONLINE ONLINE xxxxxdb2
到了oracle11g后查看resource 用 crsctl stat res -t
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.LISTENER.lsnr
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.OCR_VOT.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ORADATA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.asm
ONLINE ONLINE xxxxxdb1 Started
ONLINE ONLINE xxxxxdb2
ora.eons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.gsd
OFFLINE OFFLINE xxxxxdb1
OFFLINE OFFLINE xxxxxdb2
ora.net1.network
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xxxxxdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE xxxxxdb2
ora.xxxxxdb.db
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE Instance Shutdown
ora.xxxxxdb1.vip
1 ONLINE ONLINE xxxxxdb1
ora.xxxxxdb2.vip
1 ONLINE ONLINE xxxxxdb2
其中 ora.xxxxxdb.db显示为offline状态,其实用sqlplus 登录两个节点查看instance的状态都为open
这个应该和srvctl config配置有关系。
[root@xxxxxdb2 ~]# srvctl start instance -d xxxxxdb -n xxxxxdb2 -o open
执行这个命令后xxxxxdb2 的状态为online,并且为open.
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.LISTENER.lsnr
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.OCR_VOT.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ORADATA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.asm
ONLINE ONLINE xxxxxdb1 Started
ONLINE ONLINE xxxxxdb2
ora.eons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.gsd
OFFLINE OFFLINE xxxxxdb1
OFFLINE OFFLINE xxxxxdb2
ora.net1.network
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xxxxxdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE xxxxxdb2
ora.xxxxxdb.db
1 OFFLINE OFFLINE
2 ONLINE ONLINE xxxxxdb2 Open
ora.xxxxxdb1.vip
1 ONLINE ONLINE xxxxxdb1
ora.xxxxxdb2.vip
1 ONLINE ONLINE xxxxxdb2
[root@xxxxxdb2 ~]# srvctl start instance -d xxxxxdb -i xxxxxdb1 -o open
执行这个命令后xxxxxdb1 的状态为online,并且为open. 但是查看 xxxxxdb1 的alert log,instance会突然abort,让后重新启动。
[root@xxxxxdb2 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.LISTENER.lsnr
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.OCR_VOT.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ORADATA.dg
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.asm
ONLINE ONLINE xxxxxdb1 Started
ONLINE ONLINE xxxxxdb2
ora.eons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.gsd
OFFLINE OFFLINE xxxxxdb1
OFFLINE OFFLINE xxxxxdb2
ora.net1.network
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
ora.ons
ONLINE ONLINE xxxxxdb1
ONLINE ONLINE xxxxxdb2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xxxxxdb2
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 ONLINE ONLINE xxxxxdb2
ora.xxxxxdb.db
1 ONLINE ONLINE xxxxxdb1 Open
2 ONLINE ONLINE xxxxxdb2 Open
ora.xxxxxdb1.vip
1 ONLINE ONLINE xxxxxdb1
ora.xxxxxdb2.vip
1 ONLINE ONLINE xxxxxdb2
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24237320/viewspace-2106995/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24237320/viewspace-2106995/