Tuesday, July 7, 2020

OPW-00029: Password complexity failed in oracle 19c

Problem

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.2
Delete 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=12
Check password file format again
[oracle@oradb dbs]$ orapwd describe file=orapwPROD
Password file Description : format=12

No comments:

Post a Comment