Cluster verification Utility fails with below error while running prerequisite for Oracle RAC upgrade from 12.1.0.2 to 12.2.0.1
Verifying OLR Integrity ...PASSED
Verifying Verify that the ASM instance was configured using an existing ASM parameter file. ...FAILED (PRVG-10091)
Verifying User Equivalence ...PASSED
Verifying /dev/shm mounted as temporary file system ...PASSED
Reason:
Oracle RAC upgrade from 12.1.0.2 to 12.2.0.1 requires ASM file to be present in ASM disk group else you will get error as above.
Solution:
Follow the below steps to resolve the same
1.Change the OCR ASM diskgroup compatibility to 12.1 else you will get error as below
Verifying OLR Integrity ...PASSED
Verifying Verify that the ASM instance was configured using an existing ASM parameter file. ...FAILED (PRVG-10091)
Verifying User Equivalence ...PASSED
Verifying /dev/shm mounted as temporary file system ...PASSED
Reason:
Oracle RAC upgrade from 12.1.0.2 to 12.2.0.1 requires ASM file to be present in ASM disk group else you will get error as above.
Solution:
Follow the below steps to resolve the same
1.Change the OCR ASM diskgroup compatibility to 12.1 else you will get error as below
[grid@test ~]$ orapwd asm=y file='+DATA' password=******
OPW-00010: Could not create the password file.
ORA-15056: additional error message
ORA-15221: ASM operation requires compatible.asm of 12.1.0.0.0
or higher
ORA-06512: at line 4
Or
ASMCMD> pwcreate --asm +DATA/testll21/orapwASM ********
OPW-00010: Could not create the password file.
ORA-15056: additional error message
ORA-15221: ASM operation requires compatible.asm of 12.1.0.0.0
or higher
ORA-06512: at line 4
ASMCMD-9454: could not create new password file
ASMCMD> exit
SQL> select group_number, name,compatibility,
database_compatibility from v$asm_diskgroup;
GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ---------------
------------------------------
1 DATA 11.2.0.4.0 10.1.0.0.0
SQL> alter diskgroup DATA SET ATTRIBUTE 'compatible.asm' =
'12.1';
Diskgroup altered.
GROUP_NUMBER NAME COMPATIBILITY DATABASE_COMPATIBILITY
------------ ------------------------------ ---------------
------------------------------
1 DATA 12.1.0.0.0 10.1.0.0.0
2. Create
ASM password file as below with grid user.
[grid@test ~]$ orapwd asm=y file='+DATA' password=******
Where password is ASM sys and asmsnmp user password
3. Verify
the password location
[grid@test ~]$ srvctl config asm -a
ASM home:
Password file: +DATA/ASM/PASSWORD/pwdasm.276.949060973
ASM listener: LISTENER
ASM is enabled.
ASM is individually enabled on nodes:
ASM is individually disabled on nodes:
[grid@test~]$
Now rerun the cluster verification utility and check.