New LIMIT for ‘PASSWORD_LIFE_TIME’ in Oracle 11g.
One of my colleague go through this solution. Hope this helps you.
Some thing new in 11g, If you are using please rectify.
Any user in Oracle 11g using DEFAULT profile, has a default limit for PASSWORD_LIFE_TIME is 180 days, then that will be in GRACE period (Will never expire.)
So after 180 days it will throw the Warning ORA-28011: the account will expire soon; change your password now.
As a part of this if backups or jobs are scheduled from those user IDs, will start failing after 180 days.
Note: Prior to Oracle Database 11g Release 2 (11.2), the default was UNLIMITED. Ref SAP Note 1519872
Script to find out the same is,
select LIMIT, RESOURCE_NAME from dba_profiles where PROFILE = ‘DEFAULT’ and RESOURCE_NAME in (‘PASSWORD_GRACE_TIME’,’PASSWORD_LIFE_TIME’);
Remedy is,
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;