Database - RAC/Scalability (MOSC)

MOSC Banner

ora.asmgroup misaligned

Since upgrade of our RAC cluster from 12.2 to 19c we have noticed that the diskgroups are misaligned (we would expect instance 1 to be on node 1, rac0, 2 on rac1 and 3 on rac2):  


ora.DATA.dg(ora.asmgroup)

   1    ONLINE ONLINE    rac1      STABLE        

   2    ONLINE ONLINE    rac0      STABLE

   3    ONLINE ONLINE    rac2      STABLE

ora.RECO.dg(ora.asmgroup)

   1    ONLINE ONLINE    rac1      STABLE

   2    ONLINE ONLINE    rac0    STABLE

   3    ONLINE ONLINE    rac2      STABLE


The databases are correctly aligned:


ora.orcldb.db

   1    ONLINE ONLINE    rac0      

                               

                               

   2    ONLINE ONLINE    rac1      

                               

                               

   3    ONLINE ONLINE    rac2      

                               

I think that the cause might have been that as part of the upgrade the gridSetup.sh -executeConfigTools was run on rac1 rather than node 1 rac0.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center