My Oracle Support Banner

GI Upgrade to 19C failing with ORA-28017 on first node (Doc ID 2603806.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.