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 JULY 25, 2021
Applies to:
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]
Oracle E-Business Suite Technology Stack - 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_NAME>.<DOMAIN_NAME>
sDbDomain : domain
sDbPort : port
sDbSid : SID
sDbUser : <apps_user>
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@<HOST_NAME>.<DOMAIN_NAME>: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_NAME>.<DOMAIN_NAME>)(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_NAME>.<DOMAIN_NAME>)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=SID.<DOMAIN_NAME>)))
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_NAME>
sDbDomain : <DOMAIN_NAME>
sDbPort : port
sDbSid : SID
sDbUser : <apps_user>
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@<HOST_NAME>.<DOMAIN_NAME>:port:SID
Connection obtained
-------------------ADX Database Utility Finished---------------
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : <HOST_NAME>.<DOMAIN_NAME>
sDbDomain : domain
sDbPort : port
sDbSid : SID
sDbUser : <apps_user>
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@<HOST_NAME>.<DOMAIN_NAME>: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_NAME>.<DOMAIN_NAME>)(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_NAME>.<DOMAIN_NAME>)(PORT=port))(CONNECT_DATA=(SERVICE_NAME=SID.<DOMAIN_NAME>)))
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_NAME>
sDbDomain : <DOMAIN_NAME>
sDbPort : port
sDbSid : SID
sDbUser : <apps_user>
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@<HOST_NAME>.<DOMAIN_NAME>:port:SID
Connection obtained
-------------------ADX Database Utility Finished---------------
Finally adpreclone manage to do the correct connection.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |