In a RAC (11gR2) environment, when I run crsctl, I get back that two of my instances are in "Immediate shutdown" mode. However the instances seem to be ok.This report is unchanged for the last day or so.
Can someone explain the meaning of the STATE_DETAILS column, especially since it does not seem to match that of the database.
When I am connecting to the orcl2 instance I get the following
Code:
plsql> select instance_name, status, database_status from gv$instance;
INSTANCE_NAME STATUS DATABASE_STATUS
orcl1 OPEN ACTIVE
orcl2 OPEN ACTIVE
orcl2 OPEN ACTIVE
When I run crsctl I get this
Code:
%crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCHIVE.dg
ONLINE ONLINE db01
ONLINE ONLINE db02
ONLINE ONLINE db03
ora.DATA.dg
ONLINE ONLINE db01
ONLINE ONLINE db02
ONLINE ONLINE db03
ora.LISTENER.lsnr
ONLINE ONLINE db01
ONLINE ONLINE db02
ONLINE ONLINE db03
ora.VOTE.dg
ONLINE ONLINE db01
ONLINE ONLINE db02
ONLINE ONLINE db03
ora.asm
ONLINE ONLINE db01 Started
ONLINE ONLINE db02
ONLINE ONLINE db03
....
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE db01
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE db02
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE db02
ora.db01.vip
1 ONLINE ONLINE db01
ora.db02.vip
1 ONLINE ONLINE db02
ora.db03.vip
1 ONLINE ONLINE db03
ora.oc4j
1 OFFLINE OFFLINE
ora.orcl.dbcluster1.svc
1 ONLINE ONLINE db01
ora.orcl.dbcluster2.svc
1 ONLINE ONLINE db02
ora.orcl.dbcluster3.svc
1 ONLINE ONLINE db03
ora.orcl.db
1 ONLINE ONLINE db01 Open
2 ONLINE ONLINE db02 Instance Shutdown
3 ONLINE ONLINE db03 Instance Shutdown
ora.scan1.vip
1 ONLINE ONLINE db01
ora.scan2.vip
1 ONLINE ONLINE db02
ora.scan3.vip
1 ONLINE ONLINE db02
ora.scan4.vip
1 ONLINE ONLINE db03