Wednesday, 8 February 2017

EBS APPS user locked

Error:

ORA-28000: the account is locked --adcfgclone.pl appsTier  else some other cases
++++++++++++++++++++++++++++++++++

Solution:

Check the APPSUSR account status.
Login as SYSDBA
SQL> conn /as sysdba
Check the APPSUSR account status
SQL> alter profile AD_PATCH_MONITOR_PROFILE limit failed_login_attempts unlimited;
SQL >alter profile default limit failed_login_attempts 3 password_lock_time 1/1440; -->Limited
SQL> alter profile default limit failed_login_attempts unlimited password_lock_time 1/1440; --> unLimited

SQL> alter user apps account unlock;

No comments:

Post a Comment