Pages

Wednesday, 12 July 2017

Cluster verification Utility fails with PRVG-10091 while running prerequisite for Oracle RAC upgrade from 12.1.0.2 to 12.2.0.1

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

[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. 

No comments:

Post a Comment