OPW-00029: Password complexity failed for SYS user

by

When I tried to create password using orapwd command, faced error OPW-00029: Password complexity failed for SYS user.

$orapwd FILE='+DGTEST_DATA/prdtest/orapwprdtest' ENTRIES=4 DBUNIQUENAME='prdtest' FORMAT=12.2

Enter password for SYS:
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.

Solution:- Here we have two solutions to resolve error OPW-00029: Password complexity failed for SYS user. By default, oracle use 12.2 format for password complexity since DB version is 19c. 

1) Use Complex password as per format 12.2

Password must contain at least 8 characters
Password must not contain double quotes
Password must contain at least 1 letter
Password must contain at least 1 digit
Password must contain at least 1 special character
Password must not contain the username
Password must not contain username reversed

2) Create a password file with format 12

$orapwd FILE='+DGTEST_DATA/prdtest/orapwprdtest' ENTRIES=4 DBUNIQUENAME='prdtest' FORMAT=12

Enter password for SYS:

Leave a Comment