$ orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123' ignorecase=Y entries=5 force=y
Starting from 19c, atleast 8 bytes are required for SYS password.
Starting from 19c, atleast 8 bytes are required for SYS password.
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123' force=y
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
Solution is to add "format=12". See below:
orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password='abc123' force=y format=12
Hello Moid,Thank Q very much for sharing your knowledge to others.I need some real time issues what you faced and how you resolve it.Please make
ReplyDeletea document and upload in your blog.It is more help
full to me.All the interviewers are asking these
questions.