R12: Clone fails with error "ORA-28000 The account is locked"

R12: Clone fails with error "ORA-28000 The account is locked" [ID 1114244.1]

Applies to:

Oracle Applications Manager - Version: 12.0.0 to 12.1.3 - Release: 12 to 12.1
Information in this document applies to any platform.
***Checked for relevance on 06-Feb-2012***

Symptoms

The clone of an E-Business Suite Instance of Release 12 is failing with following error :

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

Cause

The issue is caused by the APPS Database account, which is locked.

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

For additional information, please review Note 114930.1 - 'Oracle Password Management Policy'.

Solution

To implement the solution, please execute the following steps:
1. Ensure that you have taken a backup of your Environment.

2. Increase the number of failed login which locks apps user (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.

5. Migrate the solution as appropriate to other Environments