GI Upgrade to 19C failing with ORA-28017 on first node
(Doc ID 2603806.1)
Last updated on MAY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
While upgrading cluster from 12.1 to 19C,it was failing as asm password file was wrong.
Failing with ,
ORA-28017: The password file is in the legacy format.
ASM password file was set to asm spfile .
After creating proper asm password file it was still failing with proper format .
root@xxxxxxxxx bin]# orapwd describe file=/u01/app/12.1.0.2/grid/dbs/orapw+ASM
Password file Description : format=12
[root@xxxxxxxxx bin]# orapwd describe file=+DATA/orapwASM
Password file Description : format=12.2
[root@xxxxxxxxx bin]#
2019/10/22 19:06:33 CLSRSC-363: User ignored prerequisites during installation
copying +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091 -> +DATA/orapwASM_backup
ASMCMD-8016: copy source '+DATA/nnnn-ccc/asmparameterfile/registry.253.798915091' and target '+DATA/orapwASM_backup' failed
ORA-19505: failed to identify file "+DATA/nnnn-ccc/asmparameterfile/registry.253.798915091"
ORA-17503: ksfdopn:2 Failed to open file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091
ORA-15308: could not access ASM SPFILE in RDBMS instance
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)
/u01/app/19.0.0.0/grid/bin/kfod op=credremote wrap=/tmp/credentials_19.xml
KFOD-00336: failed to enable Oracle Flex ASM
ORA-15327: remote ASM is not enabled
ORA-06512: at line 4
ORA-00604: error occurred at recursive SQL level 1
ORA-28017: The password file is in the legacy format.
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 719
ORA-06512: at line 2
*** 2019-10-22T23:39:00.440882+00:00
8866 Error 4 opening ocr key SYSTEM.ASM.CREDENTIALS.USERS.CRSUSER__ASM_009
KGFCHECK kgfnStmtExecute01c: ret == OCI_SUCCESS: FAILED at kgfn.c:3658
ORA-17503: ksfdopn:2 Failed to open file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091
ORA-15325: file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091 is not a valid password file
ORA-06512: at line 4
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 679
ORA-06512: at line 2
8866 Error 4 opening ocr key SYSTEM.ASM.CREDENTIALS.USERS.crsuser__asm_009
KGFCHECK kgfnStmtExecute01c: ret == OCI_SUCCESS: FAILED at kgfn.c:3658
ORA-17503: ksfdopn:2 Failed to open file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091
ORA-15325: file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091 is not a valid password file
ORA-06512: at line 4
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 679
ORA-06512: at line 2
KGFCHECK kgfnStmtExecute01c: ret == OCI_SUCCESS: FAILED at kgfn.c:3658
ORA-17503: ksfdopn:2 Failed to open file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091
ORA-15325: file +DATA/nnnn-ccc/asmparameterfile/registry.253.798915091 is not a valid password file
ORA-06512: at line 4
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 679
ORA-06512: at line 2
Error creating new automated user
<error barrier> at 0x7ffe485581a0 placed kfz.c@5996
ORA-00604: error occurred at recursive SQL level 1
ORA-28017: The password file is in the legacy format.
7554 Failed to create new credentials in the password file
3110 Error creating credentials while enabling remote asm
ORA-15327: remote ASM is not enabled
ORA-00604: error occurred at recursive SQL level 1
ORA-28017: The password file is in the legacy format.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |