I faced this error while cloning R12.2.5 in my environment. Below are the step by step process, I followed to overcome this issue.
The above issue might occur if still there is some reference to the source system, or the cloning script is unable to change it to appropriate environment during the cloning process for some reasons. This is one such case, where this issue might occur. There are many other reasons which will throw the above same issue but the reason might be different. Need to drill down on the log files for exact cause for the issue.
- Take backup of AD_APPL_TOPS table
- Remove the entries for prod reference
- On db tier connect with apps
- Run "exec fnd_conc_clone.setup_clean;"
- Run autoconfig on database tier
- On application tier rerun "perl adcfgclone.pl appsTier"
- Verify Clone complete successfully or not.
****************************நன்றி****************************
thanks
ReplyDeleteSQL> select OWNER,TABLE_NAME,TABLESPACE_NAME from dba_tables WHERE TABLE_NAME='AD_APPL_TOPS';
ReplyDeleteSQL> CREATE TABLE APPLSYS.AD_APPL_TOPS_BKP as select * from APPLSYS.AD_APPL_TOPS;
SQL> select count (*) from APPLSYS.AD_APPL_TOPS;
SQL> select count (*) from APPLSYS.AD_APPL_TOPS_BKP;
SQL> col NAME for a15
SQL> col DESCRIPTION for a40
SQL> col APPLICATIONS_SYSTEM_NAME for a10
SQL> set lines 200 pages 200
SQL> select APPL_TOP_ID,NAME,DESCRIPTION,APPLICATIONS_SYSTEM_NAME from AD_APPL_TOPS;
SQL> update AD_APPL_TOPS set APPLICATIONS_SYSTEM_NAME='ERPDB' where APPLICATIONS_SYSTEM_NAME='ORACLEDB';
SQL> commit;
SQL> select APPL_TOP_ID,NAME,DESCRIPTION,APPLICATIONS_SYSTEM_NAME from AD_APPL_TOPS;
SQL> show user
USER is "APPS"
SQL> exec fnd_conc_clone.setup_clean;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL>
-bash-4.1$ export CONFIG_JVM_ARGS="-Xms1024m -Xmx2048m"
-bash-4.1$ echo $CONFIG_JVM_ARGS
-Xms1024m -Xmx2048m
-bash-4.1$ echo $TIMEDPROCESS_TIMEOUT
-1
-bash-4.1$
just copy and paste :)