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.
Thanks a lot that was very useful for me, it helped me complete the autocofing successfully after clone..
ReplyDeleteI got the same on my new 12.2 instance - worked a treat there too.
ReplyDelete