Friday, 21 June 2013

Autoconfig Error after clone in 12.1.3 Instance



While 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/apps/mine/inst/apps/test_mine/admin/install
      adadmprf.sh             INSTE8_PRF         1 

Solution:


1. select applications_system_name from applsys.fnd_product_groups; 

This will return the source instance sid.

2. Update the entry with target instance name:

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

3. Run autoconfig again. 


2 comments:

  1. Thanks a lot that was very useful for me, it helped me complete the autocofing successfully after clone..

    ReplyDelete
  2. I got the same on my new 12.2 instance - worked a treat there too.

    ReplyDelete