Hi everyone,
One of my RAC for testing is behaving in a very odd manner, as its not showing STATE_DETAIL column for ora.ASM and ora.DB attribute of crsctl status res -t with no status.
Environment Details:
OS: Redhat 6
GI version: 11.2.0.4
DB version: 11.2.0.4
DB name: ABC <replaced name with a dummy>
Please find below 'crsctl status res -t' output
[grid@abc2 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ABCDATA.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.ABCFRA.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.ABCINDX.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.ABCSYS.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.ABCTEMP.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.ABCUNDO.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.CRSDATA.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.LISTENER.lsnr
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.MULPLXREDO.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.REDOTH1.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.REDOTH2.dg
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.asm
ONLINE ONLINE abc1
ONLINE ONLINE abc2 Started
ora.gsd
OFFLINE OFFLINE abc1
OFFLINE OFFLINE abc2
ora.net1.network
ONLINE ONLINE abc1
ONLINE ONLINE abc2
ora.ons
ONLINE OFFLINE abc1
ONLINE OFFLINE abc2
ora.registry.acfs
ONLINE ONLINE abc1
ONLINE ONLINE abc2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE abc2
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE abc1
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE abc1
ora.abc1.vip
1 ONLINE ONLINE abc1
ora.abc2.vip
1 ONLINE ONLINE abc2
ora.ABCprd.db
1 ONLINE ONLINE abc1
2 ONLINE ONLINE abc2 Open
ora.cvu
1 ONLINE ONLINE abc1
ora.oc4j
1 ONLINE ONLINE abc1
ora.orcl.db
1 ONLINE ONLINE abc1
2 ONLINE ONLINE abc2 Open
ora.scan1.vip
1 ONLINE ONLINE abc2
ora.scan2.vip
1 ONLINE ONLINE abc1
ora.scan3.vip
1 ONLINE ONLINE abc1
Any help in this regard is really appreciable.
Regards
Samad Ul Haq
Message was edited by: Samadulhaq
changed version from 11.2.0.3 to 11.2.0.4