Adjusting The Password Expiration Policy / PASSWORD_LIFE_TIME
Doing a default database installation will install a feature that all passwords will expire after 180 days and being unaware of that can be a serious problems in applications as they are unable to connect to the database post that time period. It will cause unnecessary downtime for the applications.
First we have to verify the password expiration policy in your database and can be done by running a query against DBA_PROFILES:
SQL> select * from dba_profiles where resource_name = ‘PASSWORD_LIFE_TIME’;
PROFILE RESOURCE_NAME RESOURCE LIMIT
—————- ————————– ———————–
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
This confirms that the password expiry policy is set to default.
We can change this value to unlimited as below :
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Keep in mind to adjust the statement if you are using a different profile name as ‘DEFAULT’ or multiple profiles.
The verification of this change is done using the same query as before:
SQL> select * from dba_profiles where resource_name = ‘PASSWORD_LIFE_TIME’;
PROFILE RESOURCE_NAME RESOURCE LIMIT
—————- ————————– ———————–
DEFAULT PASSWORD_LIFE_TIME PASSWORD UNLIMITED