During adpreclone receive: "Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection", but after the connection is OK (Doc ID 1489879.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Applications Technology Stack - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications Manager - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Oracle Applications DBA - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.

Symptoms



When attempting to run adpreclone,
the following error occurs in the log:

getConnectionUsingAppsJDBCConnector() -->
    APPS_JDBC_URL='null'
    Trying to get connection using SID based connect descriptor
getConnection() -->
    sDbHost    : host.domain.com
    sDbDomain  : domain
    sDbPort    : port
    sDbSid     : SID
    sDbUser    : apps
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@host.domain.com.domain.com:port:SID
    Exception occurred: java.sql.SQLException: IO Error: 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=host.domain.com.domain.com)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=SID)))
    Exception occurred: java.sql.SQLException: IO Error: 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=host.domain.com.domain.com)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=SID.domain.com)))
    Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection
    Connection could not be obtained; returning null

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

    Connection could not be obtained using s_dbhost
    Trying to connect using s_hostname
getConnection() -->
    sDbHost    : host
    sDbDomain  : domain.com
    sDbPort    : port
    sDbSid     : SID
    sDbUser    : apps
    Trying to connect using SID...
getConnectionUsingSID() -->
    JDBC URL: jdbc:oracle:thin:@host.domain.com:port:SID
    Connection obtained

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

 Finally adpreclone manage to do the correct connection.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms