ORA-28017: The Password File Is In The Legacy Format

PROBLEM:
While granting sysdba privilege to an user, got below error.

SQL> grant sysdba to ABUZER;

*
ERROR at line 1:
ORA-28017: The password file is in the legacy format

SOLUTION:
İf you upgrade 11G database It is an expected behaviour from 12.1.0.2 database release onwards.

Check the format of the pwd file.

$ orapwd describe file=orapwPROD
 
Password file Description : format=LEGACY ignorecase=N

either create a new password file or convert the legacy file to new 12c format.

For Create a new password file


$ orapwd file=orapwPROD password=oracle#123  force=y format=12

For convert the legacy file to new format.

$ orapwd file=orapwPROD  password=oracle#123 force=y  format=12 input_file=orapwPROD 

Bir cevap yazın

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir