A technical troubleshooting blog about Oracle with other Databases & Cloud Technologies.

Oracle

OPW-00029: Password complexity failed for SYS !!

1 min read

asrblogger

PROBLEM : The attempt to create a password file for a 12.2 database failed :

[oracle@localhost dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle

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

SOLUTION: To address this issue, there are two options available: either provide a password that meets the complexity requirements, such as:

[oracle@localhost dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=Passw0$rd@1

Alternatively, you can create the password file in the 12.1 format, which differs from the default 12.2 format.

[oracle@localhost dbs]$ orapwd describe file=orapwprod101
Password file Description : format=12.2 

[oracle@localhost dbs]$ orapwd file=$ORACLE_HOME/dbs/orapwprod101 password=oracle format=12

[oracle@localhost dbs]$ orapwd describe file=orapwprod101
Password file Description : format=12

Reference: