Cause: The user's account is about to about to expire and the password needs
to be changed.
Action: Change the password or contact the database administrator.
Reference: Oracle Documentation
Solutions:
1) Simply change the password to avoid it temporary
[oracle@lnxsvr ~]$ sqlplus scott/tiger
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> PASSWORD
Changing password for SCOTT
Old password:
New password:
Retype new password:
Password changed
2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED
then change the password to avoid it permanently
[oracle@lnxsvr ~]$ sqlplus scott/tiger
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';
PROFILE
------------------------------
DEFAULT
SQL> SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'
AND RESOURCE_NAME='PASSWORD_LIFE_TIME';
LIMIT
----------------------------------------
60
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.
SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';
ACCOUNT_STATUS
--------------------------------
EXPIRED(GRACE)
SQL> PASSWORD
Changing password for SCOTT
Old password:
New password:
Retype new password:
Password changed
No comments:
Post a Comment