Autoconfig Error after clone in 12.1.3 Instance

May 12, 2017 APPS DBA, Errors/Workarounds-Applications by Syed Saad Ali

ERROR

Running autoconfig on a cloned instance , the below mentioned error occurred:

PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00001: unique constraint (APPLSYS.AD_APPL_TOPS_U2) violated
ORA-06512: at line 32

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
adadmprf.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
.end err out.

AutoConfig could not successfully execute the following scripts:
Directory: /u01/ebs/oracle/inst/apps/test_mine/admin/install
adadmprf.sh INSTE8_PRF 1

SOLUTION

1.RUN the Following given Query with APPS user and notedown the SID from Output:

select applications_system_name from applsys.fnd_product_groups;

2.Update the entry with target instance name:

update applsys.fnd_product_groups set applications_system_name = ‘<target instance>’;

3.Run autoconfig again.

Write a comment