|
1 2 3 4 |
ORA-28055: the password will expire within * days Cause: The enterprise user's password is about to expire. Action: Change the password in the directory or contact the directory administrator. |
hit this issue, under scott/tiger schema, fix, to change passwd
|
1 2 3 |
SQL> alter user scott identified by tiger; User altered. |
The more…
|
1 2 3 4 5 6 7 |
SQL> SELECT profile 2 FROM dba_users 3 WHERE username = 'SCOTT'; PROFILE ------------------------------ DEFAULT |
Double check the table dba_profiles, and to change password_life_time parameter if necessary
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
SQL> SELECT RESOURCE_NAME, LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' and RESOURCE_NAME LIKE '%PASSWORD%' ; RESOURCE_NAME LIMIT ----------------------- ------------------------ PASSWORD_LIFE_TIME 180 PASSWORD_REUSE_TIME UNLIMITED PASSWORD_REUSE_MAX UNLIMITED PASSWORD_VERIFY_FUNCTION NULL PASSWORD_LOCK_TIME 1 PASSWORD_GRACE_TIME 7 6 rows selected. |