Oracle Hata Kodları

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 
Etiketler

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

bparlayan

Blog sitemi boş zamanlarımda hem biraz karalamak hemde mesleki tecrübeleri paylaşmak için kullanmaktayım. Burası benim deşarj noktam. Bu paylaşımları istediğiniz gibi çoğaltabilir ve kullanabilirsiniz : ). Ufak bir teşekkür yeterli. bugra[@]bugraparlayan.com.tr adresinden iletişim kurabilirsiniz.

İlgili Makaleler

Bir yanıt yazın


Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/classes/class-tielabs-filters.php on line 340

Notice: Trying to access array offset on value of type bool in /home/wwwbugra/public_html/wp-content/themes/jannah/framework/functions/media-functions.php on line 114
Başa dön tuşu
Kapalı