For one of our customer, crsctl stat output was showing
extra cluster resource.
-bash-5.2$ crsctl stat res -t -------------------------------------------------------------------------------- Name
Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr
ONLINE ONLINE db1 STABLE
ONLINE ONLINE db2 STABLE ora.net1.network
ONLINE ONLINE db1 STABLE
ONLINE ONLINE db2 STABLE ora.ons
ONLINE ONLINE db1 STABLE
ONLINE ONLINE db2 STABLE ora.proxy_advm
OFFLINE OFFLINE db1 STABLE
OFFLINE OFFLINE db2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE
db2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE
db1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE
db1 STABLE ora.RECO.dg(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE 3 OFFLINE OFFLINE STABLE ora.REDO.dg(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE
db1 Started,STABLE 2 ONLINE ONLINE
db2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE
db1 STABLE ora.db1.vip 1 ONLINE ONLINE
db1 STABLE ora.db2.vip 1 ONLINE ONLINE
db2 STABLE ora.qosmserver 1 ONLINE ONLINE
db1 STABLE ora.prod.db 1 ONLINE ONLINE
db1 Open,HOME=/u01/app/o
racle/product/19.3.0
/dbhome_1,STABLE 2 ONLINE ONLINE
db2 Open,HOME=/u01/app/o
racle/product/19.3.0
/dbhome_1,STABLE ora.scan1.vip 1 ONLINE ONLINE
db2 STABLE ora.scan2.vip 1 ONLINE ONLINE
db1 STABLE ora.scan3.vip 1 ONLINE ONLINE
db1 STABLE -------------------------------------------------------------------------------- |
However this was 2 node cluster and the output as we can see
was showing 3 resources which was causing confusion. After checking MOS, as per
Doc ID 2341248.1,
It is an
expected behavior in 12.2,with Oracle Flex ASM, you can consolidate all the
storage requirements into a single set of disk groups. All these disk groups
are mounted by and managed by a small set of Oracle ASM instances running in
a single cluster. Irrespective of number of nodes in the cluster, only
three ASM instances will be created |
Solution:-
To disable it run the following.
-bash-5.2$
srvctl config asm ASM home:
<CRS home> Password
file: +DATA/orapwASM Backup of
Password file: +DATA/orapwASM_backup ASM listener:
LISTENER ASM instance
count: 3 Cluster ASM
listener: ASMNET1LSNR_ASM -bash-5.2$
srvctl modify asm -count all |
-bash-5.2$ crsctl stat res -t -------------------------------------------------------------------------------- Name
Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr
ONLINE ONLINE db1 STABLE
ONLINE ONLINE db2 STABLE ora.net1.network
ONLINE ONLINE db1 STABLE
ONLINE ONLINE db2 STABLE ora.ons
ONLINE ONLINE db1 STABLE
ONLINE ONLINE db2 STABLE ora.proxy_advm
OFFLINE OFFLINE db1 STABLE
OFFLINE OFFLINE db2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE
db2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE
db1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE
db1 STABLE ora.RECO.dg(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE ora.REDO.dg(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE
db1 Started,STABLE 2 ONLINE ONLINE
db2 Started,STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE
db1 STABLE 2 ONLINE ONLINE
db2 STABLE ora.cvu 1 ONLINE ONLINE
db1 STABLE ora.db1.vip 1 ONLINE ONLINE
db1 STABLE ora.db2.vip 1 ONLINE ONLINE
db2 STABLE ora.qosmserver 1 ONLINE ONLINE
db1 STABLE ora.prod.db 1 ONLINE ONLINE
db1 Open,HOME=/u01/app/o
racle/product/19.3.0
/dbhome_1,STABLE 2 ONLINE ONLINE
db2 Open,HOME=/u01/app/o
racle/product/19.3.0
/dbhome_1,STABLE ora.scan1.vip 1 ONLINE ONLINE
db2 STABLE ora.scan2.vip 1 ONLINE ONLINE
db1 STABLE ora.scan3.vip 1 ONLINE ONLINE
db1 STABLE -------------------------------------------------------------------------------- |
As we can see, now the number of resources are showing
correct.
No comments:
Post a Comment