ORA-28011: the account will expire soon; change your password now

If you are getting a error/warning message (ORA-28011) while connecting to oracle user which means that the particular user password life time is over and it is running on the password grace period.

After the grace period time the password will expire and it will ask for new password.


02:04:36 SQL> connect read@prod1
Enter password:
ERROR:
ORA-28002: the password will expire within 0 days


Connected.

02:06:39 SQL> connect read@prod1
Enter password:
ERROR:
ORA-28001: the password has expired

Changing password for read
New password:



You can check the password life time and password grace time by connecting DBA_PROFILES and DBA_USERS views.
SQL> select profile from dba_users where username ='SCOTT';

PROFILE
------------------------------
TEST

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

PROFILE                        RESOURCE_NAME                    RESOURCE LIMIT
------------------------------ -------------------------------- -------- ------------------------
TEST                           COMPOSITE_LIMIT                  KERNEL   DEFAULT
TEST                           SESSIONS_PER_USER                KERNEL   DEFAULT
TEST                           CPU_PER_SESSION                  KERNEL   DEFAULT
TEST                           CPU_PER_CALL                     KERNEL   DEFAULT
TEST                           LOGICAL_READS_PER_SESSION        KERNEL   DEFAULT
TEST                           LOGICAL_READS_PER_CALL           KERNEL   DEFAULT
TEST                           IDLE_TIME                        KERNEL   DEFAULT
TEST                           CONNECT_TIME                     KERNEL   DEFAULT
TEST                           PRIVATE_SGA                      KERNEL   DEFAULT
TEST                           FAILED_LOGIN_ATTEMPTS            PASSWORD DEFAULT
TEST                           PASSWORD_LIFE_TIME               PASSWORD .0013
TEST                           PASSWORD_REUSE_TIME              PASSWORD 30
TEST                           PASSWORD_REUSE_MAX               PASSWORD 10
TEST                           PASSWORD_VERIFY_FUNCTION         PASSWORD DEFAULT
TEST                           PASSWORD_LOCK_TIME               PASSWORD .0034
TEST                           PASSWORD_GRACE_TIME              PASSWORD .0013

16 rows selected.



DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google