ORA-28000: the account is locked:Exception occurred: java.sql.SQLException:

 Error :

..
Exception occurred: java.sql.SQLException: ORA-28000: the account is locked
ORA-28000: the account is locked
...

The following ORACLE error:
ORA-28000: the account is locked
occurred while executing the SQL statement:

Cause :
​
The issue is caused by a locked APPS Database account.

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';

Example output :

DEFAULT FAILED_LOGIN_ATTEMPTS : 10
AD_PATCH_MONITOR_PROFILE FAILED_LOGIN_ATTEMPTS : 3

Solution :

​To implement the solution test the following steps in a Development instance and then migrate accordingly:

1. Ensure that you have taken a backup of your Environment.

2. Increase the number of failed logins allowed before the apps user is locked(optional):

alter profile AD_PATCH_MONITOR_PROFILE limit failed_login_attempts unlimited;

alter profile default limit failed_login_attempts unlimited password_lock_time 1/1440;

3.Unlock the locked APPS User account :

alter user apps account unlock;

4. Rerun the failed cloning commands and confirm the error is resolved.