Problem
Error occor while creating password file in oracle 19c
by default oracle use 12.2 format for password complexity since DB version is 19c. Two option for overcome this issue
provide password which meet the complexity requirement
Create password file for oracle db version 12.1
Check exisitng password file format
Error occor while creating password file in oracle 19c
[oracle@oradb dbs]$ orapwd file=orapwPROD password=Welcome123 entries=30 OPW-00029: Password complexity failed for SYS user : Password must contain at least 1 special character.Solution
by default oracle use 12.2 format for password complexity since DB version is 19c. Two option for overcome this issue
provide password which meet the complexity requirement
[oracle@oradb dbs]$ orapwd file=orapwPROD password=Welcome#123 entries=30 OPW-00029: Password complexity failed for SYS user : Password must contain at least 1 special character.OR
Create password file for oracle db version 12.1
Check exisitng password file format
[oracle@oradb dbs]$ orapwd describe file=orapwPROD Password file Description : format=12.2Delete exisiting password file and Create with 12.1 format
[oracle@oradb dbs]$ rm -rf orapwPROD
[oracle@oradb dbs]$ orapwd file=orapwPROD password=Welcome123 entries=30 format=12Check password file format again
[oracle@oradb dbs]$ orapwd describe file=orapwPROD Password file Description : format=12
No comments:
Post a Comment