Application clone 12.2.6 :: ERROR: txkWfClone.sh execution failed, exit code 1

dualfs_clone_log.rar

perl adcfgclone.pl appsTier dualfs , failed.

END: Finished running CVM.....

START: Instantiate the txkWfClone.sh...
Creation of Directory - /u01/oracle/uat/fs2/inst/apps/UAT1_sun3app1/admin/install Succeeded.
instantiate file:
   source : /u01/oracle/uat/fs2/EBSapps/appl/fnd/12.0.0/admin/template/txkWfClone.sh
   dest   : /u01/oracle/uat/fs2/inst/apps/UAT1_sun3app1/admin/install/txkWfClone.sh
Adding execute permission to : /u01/oracle/uat/fs2/inst/apps/UAT1_sun3app1/admin/install/txkWfClone.sh

END: Instantiated txkWfClone.sh...

START: Instantiate the txkWfClone.sql...
instantiate file:
   source : /u01/oracle/uat/fs2/EBSapps/appl/fnd/12.0.0/admin/template/txkWfClone.sql
   dest   : /u01/oracle/uat/fs2/inst/apps/UAT1_sun3app1/admin/install/txkWfClone.sql
Adding execute permission to : /u01/oracle/uat/fs2/inst/apps/UAT1_sun3app1/admin/install/txkWfClone.sql

END: Instantiated txkWfClone.sql...

START: Executing /u01/oracle/uat/fs2/inst/apps/UAT1_sun3app1/admin/install/txkWfClone.sh -nopromptmsg
txkWfClone.sh exited with status 1
ERROR: txkWfClone.sh execution failed, exit code 1

Architecture as below,

Database - 12C RAC 2 node
Application - 12.2.6
Os - Solaris 11.3

Need help on top priority, if anyone has any clue please post.


Thanks,
Prafull

[ErmanArslansOracleBlog]

You have connection problem..

WARNING:     Exception occurred: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Check your DB connection.. I guess you configured your apps tier wrong or you are passing wrong parameters to the cloning process.

Probably it goes to wrong listener.
I don't wanna copy paste your logs here.
Check your logs you will the error and the hostname and the port that cloning process is trying to reach..
Check and correct your configuration accordingly.

Thanks Erman for your reply.

I managed to fix this issue.  Followed below steps

>> 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 dulafs"
>> Clone completed successfully

Issues fixed.


Thanks,
Prafull

[ErmanArslansOracleBlog]

Good.

[Ravi Ganesh TR]

Thank you !!! Real its very helpful.. We fixed.

[Sreeni]

really help full , thanq...