Monday, August 13, 2012

oracle user password expired locked

In 11 r2 , were facing this user lock and expire issue frequently to override it


select profile from dba_users where username ='xxxx';

alter profile default limit passsword_life_time unlimited;
alter profile default limit failed_login_attempts unlimited;


select resource_name,limit from dba_profiles where profile='';

No comments:

Post a Comment

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...