advertisements
_____________________________________________________________________________________________________________________
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment