During adpreclone receive: "Exception occurred: java.sql.SQLException: IO Error: The Network Adapter could not establish the connection", but after the connection is OK
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---------------
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