ERROR: ORA-28002: the password will expire within 7 days
In Oracle 11G, the default password expiration time is 180 days. If your database does not have such high security requirements
You can change it to unlimited.
SQL> set wrap off;
SQL> set linesize 200;
SQL> select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';
PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
The default value is 180 days.
SQL> alter profile default limit password_life_time unlimited;
Profile altered.
The password change will never expire. You do not need to restart the password after modification. The change takes effect immediately.
SQL> select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';
PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
The following are other password-related parameters:
SQL> select * from dba_profiles where profile = 'default' and RESOURCE_NAME like 'password % ';
PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7
6 rows selected.