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.
Leave a Reply