Labels

Wednesday, October 23, 2013

ORA-28007: the password cannot be reused

SQL> alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxxx';
alter user "BACMONIT" IDENTIFIED BY VALUES 'xxxxxx'
*
ERROR at line 1:
ORA-28007: the password cannot be reused

=========================================================
Solutions:-
1)Change the profile limit and make the same password
SQL>  select USER#,NAME,PASSWORD FROM user$ where name='BACMONIT';

     USER# NAME                           PASSWORD
---------- ------------------------------ ------------------------------
        99 BACMONIT                    XXXXXXX
2)Check the PASSWORD_REUSE_TIME.
SQL>  select * from dba_profiles where profile='DBUSER' and  RESOURCE_NAME in ('PASSWORD_REUSE_TIME') ;

PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DBUSER                         PASSWORD_REUSE_TIME              PASSWORD
360

3)Change the profile limit to unlimited.
SQL>  alter profile DBUSER limit PASSWORD_REUSE_TIME UNLIMITED;

Profile altered.

4)Change the password with used one.
SQL>  alter user BACMONIT IDENTIFIED BY VALUES 'xxxxxxx';

User altered.

5)Revert back the limit.
SQL> alter profile DBUSER limit PASSWORD_REUSE_TIME 360;

Profile altered.

6)Check the password expiry date 

SQL> select username,account_status,EXPIRY_DATE from dba_users where username='BACMONIT';

USERNAME                       ACCOUNT_STATUS                   EXPIRY_DA
------------------------------ -------------------------------- ---------
BACMONIT                       OPEN                             29-DEC-13

No comments:

Post a Comment