Saturday 1 March 2014

Password should contain minimum two embedded numbers


When trying to change the system password as part of the postclone activity getting below error.

SQL> show user
USER is "SYS"
SQL> alter user system identified by sys#2pswd;
alter user system identified by sys#2pswd
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20005: Password should contain minimum two embedded numbers
SQL>


Check user profile
============
SQL> select USERNAME, PROFILE, ACCOUNT_STATUS from dba_users where username = 'SYSTEM';
USERNAME   PROFILE         ACCOUNT_STATUS
------------------    ------------------ --------------------------------
SYSTEM    USER_PROFILE  OPEN

SQL> select * from dba_profiles where profile='USER_PROFILE';

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
USER_PROFILE SESSIONS_PER_USER KERNEL DEFAULT
USER_PROFILE CPU_PER_SESSION KERNEL DEFAULT
USER_PROFILE CPU_PER_CALL KERNEL DEFAULT
USER_PROFILE LOGICAL_READS_PER_SESSION KERNEL DEFAULT
USER_PROFILE LOGICAL_READS_PER_CALL KERNEL DEFAULT
USER_PROFILE IDLE_TIME KERNEL DEFAULT
USER_PROFILE CONNECT_TIME KERNEL DEFAULT
USER_PROFILE PRIVATE_SGA KERNEL DEFAULT
USER_PROFILE FAILED_LOGIN_ATTEMPTS PASSWORD DEFAULT
USER_PROFILE PASSWORD_LIFE_TIME PASSWORD DEFAULT

PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
USER_PROFILE PASSWORD_REUSE_TIME PASSWORD DEFAULT
USER_PROFILE PASSWORD_REUSE_MAX PASSWORD DEFAULT
USER_PROFILE PASSWORD_VERIFY_FUNCTION PASSWORD DEFAULT
USER_PROFILE PASSWORD_LOCK_TIME PASSWORD DEFAULT
USER_PROFILE PASSWORD_GRACE_TIME PASSWORD DEFAULT

Solution :
----------
Make the verification function to NULL and then try it.
SQL> alter profile USER_PROFILE limit password_verify_function NULL;
Profile altered.
SQL> alter user system identified by sys#2pswd;
User altered.

Once the password is changed make it to default...
SQL>alter profile USER_PROFILE limit password_verify_function DEFAULT;

No comments:

Post a Comment