crsctl stats output showing extra cluster resource

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