RC-50014: Fatal: Execution of AutoConfig was failed - java.sql.SQLException: Could not get connection to the database

During cloning adcfgclone.pl appsTier, I get below error in the logfile.

ERROR:
AutoConfig is exiting with status 1

RC-50014: Fatal: Execution of AutoConfig was failed
Raised by oracle.apps.ad.clone.ApplyApplTop
ERROR: AutoConfig completed with errors. Check logfile at /u01/dev/inst/apps/DEV_za-ohcsa-dev-01/admin/log/ApplyAppsTier_03241003.log for details.
ApplyApplTop Completed Successfully.

# Checking the status of AutoConfig run of ApplyApplTop

Warning : AutoConfig has completed with  errors .

Please review the AutoConfig section in the logfile. If required, you can re-run AutoConfig from command line  after fixing the problem

getConnectionUsingAppsJDBCConnector() -->

    APPS_JDBC_URL=''

    Trying to get connection using SID based connect descriptor

getConnection() -->

    sDbHost    : za-ohcsd-dev-01

    sDbDomain  : abc.local

    sDbPort    : 1521

    sDbSid     : DEV

    sDbUser    : APPS

    Trying to connect using SID...

getConnectionUsingSID() -->

    JDBC URL: jdbc:oracle:thin:@za-ohcsd-dev-01.host.local:1521:DEV

    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

    Trying to connect using SID as ServiceName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=za-ohcsd-dev-01.hot.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DEV)))

    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

    Trying to connect using SID as ServiceName.DomainName

getConnectionUsingServiceName() -->

    JDBC URL: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=za-ohcsd-host-01.abc.local)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DEV.abc.local)

))

    Exception occurred: java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

    Connection could not be obtained; returning null

-------------------ADX Database Utility Finished---------------

Exception occurred while preseeding variables in the context file: java.sql.SQLException: Could not get connection to the database

StackTrace:

java.sql.SQLException: Could not get connection to the database

        at oracle.apps.ad.tools.configuration.CVMHelper.processNewContextFile(CVMHelper.java:875)

        at oracle.apps.ad.context.CtxValueMgt.preSeed2Ctx(CtxValueMgt.java:1825)

        at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1620)

        at oracle.apps.ad.clone.ApplyApplTop.runCVM(ApplyApplTop.java:510)

        at oracle.apps.ad.clone.ApplyApplTop.runAutoConfig(ApplyApplTop.java:552)

        at oracle.apps.ad.clone.ApplyApplTop.doConf(ApplyApplTop.java:339)

        at oracle.apps.ad.clone.ApplyApplTop.doApply(ApplyApplTop.java:382)

        at oracle.apps.ad.clone.ApplyApplTop.<init>(ApplyApplTop.java:267)

        at oracle.apps.ad.clone.ApplyAppsTier.<init>(ApplyAppsTier.java:105)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)

Solution:

In Apps server check for the tns entry,I look domain name entry was wrong during 

echo $TNS_ADMIN

cd $TNS_ADMIN

check for tns entry for DB in apps node.I looks domain name is entered wrongly so during execute of "adcfgclone.pl appTier" enter proper domain name.

==> Error ==> Target System Database Domain Name [abc.local] :

Change the entry to

Target System Database Domain Name [host1.local] : dev.host1.local

Action Plan:

Step1: Login as apps user and run fnd clean.

SQL>EXEC FND_CONC_CLONE.SETUP_CLEAN;

Step2:Re run "adcfgclone.pl appsTier" from apps node with proper domain name during prompt of the perl script.

As example:

Target System Database Domain Name [host1.local] : dev.host1.local