BRBACKUP/BRARCHIVE failed, warning ORA-28011: the account will expire soon; change your password now.

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;

ZOHO…………………..

well if i am not late to tell u people about Virtual office Concept, Groupware Chat, CRM and anyother usefull productivity tools.

so let me introduce the Ultimate website which i have found on net after some searching when i relly need that.

I was finding any website to read my office documents or any searched file without download it to my PC. so i get this ultimate website, where i will done all things. MOST OF THE THINGS ARE FREE OR TRIAL.

USE IT OR BUY IT, BUT DEFINATELY IT’S WORTH TO PURCHASE..

THE ULTIMATE NAME. ZOHO.COM

Posted in IT