EBS APPS user locked

Error:

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

++++++++++++++++++++++++++++++++++

Check the APPSUSR account status.

Login as SYSDBA

SQL> conn /as sysdba

Check the APPSUSR account status

SQL>select * from user_astatus_map;

SQL>select profile,username, account_status, to_char(lock_date,'dd-mm-YY HH:MI'),  expiry_date  from dba_users  where username = '&user';

SQL> select account_status,to_char(lock_date,'DD-MON-YYYY HH24:MI:SS'),profile from dba_users where username='&user';

SQL> SELECT username, account_status FROM dba_users WHERE username= ‘APPS’;

SQL>set pagesize 300

col profile format a25

col limit format a10

select PROFILE, RESOURCE_NAME, RESOURCE_TYPE, LIMIT from dba_profiles  where profile='AD_PATCH_MONITOR_PROFILE';

SQL> select profile , resource_name, limit from dba_profiles where resource_name like '%FAIL%';

SQL> select username, profile from dba_users where username='APPS';

SQL> select username, profile from dba_users where username='APPLSYS'; 

++++++++++++++ Solution A :++++++++++++++++++++++++++++++

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;

SQL> alter user apps account unlock;

++++++++++++++ Solution B :++++++++++++++++++++++++++++++

Create a profile.

SQL> CREATE PROFILE APPS_DEFAULT LIMIT

 COMPOSITE_LIMIT UNLIMITED

 SESSIONS_PER_USER UNLIMITED

 CPU_PER_SESSION UNLIMITED

 CPU_PER_CALL UNLIMITED

 LOGICAL_READS_PER_SESSION UNLIMITED

 LOGICAL_READS_PER_CALL UNLIMITED

 IDLE_TIME UNLIMITED

 CONNECT_TIME UNLIMITED

 PRIVATE_SGA UNLIMITED

 FAILED_LOGIN_ATTEMPTS UNLIMITED

 PASSWORD_LIFE_TIME UNLIMITED

 PASSWORD_REUSE_TIME UNLIMITED

 PASSWORD_REUSE_MAX UNLIMITED

 PASSWORD_VERIFY_FUNCTION NULL

 PASSWORD_LOCK_TIME UNLIMITED

 PASSWORD_GRACE_TIME UNLIMITED;

Profile created.

Assign the newly created profile to the user as default profile.

SQL> ALTER USER appusr PROFILE appusr_default;

Unlock the user account:

SQL> ALTER USER apps ACCOUNT UNLOCK;

+++++++++++++++++++ Metalink id  ID 1114244.1 For Reference +++++++++++++++++++