Header Ads Widget

apps account locked while patching


The following script allows you to check the number of failed logins, which can lock the apps user :

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


Solution:
alter profile AD_PATCH_MONITOR_PROFILE limit failed_login_attempts unlimited;
alter profile default limit failed_login_attempts unlimited password_lock_time 1/1440;

select * from dba_users where username like 'APPS%'

alter user apps account unlock;

alter user AD_MONITOR account unlock;



R12: Clone fails with error "ORA-28000 The account is locked" (Doc ID 1114244.1).