Monday, October 3, 2016

BRBACKUP/BRARCHIVE failed with warning ORA-28011: the account will expire soon.



For any user in Oracle  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 Note1519872

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’);

To change unlimit
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

No comments:

Post a Comment