Today, i have encountered below issue while running autoconfing on database after cloning from PROD to Development instance.
Error:
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : pmvtest
sDbDomain : evosysglobal.com
sDbPort : 1522
sDbSid : PMVTEST
sDbUser : APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@pmvtest.evosysglobal.com:1522:PMVTEST
Exception occurred: java.sql.SQLRecoverableException: 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=pmvtest.evosysglobal.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=PMVTEST)))
Exception occurred: java.sql.SQLRecoverableException: 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=pmvtest.evosysglobal.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=PMVTEST.evosysglobal.com)))
Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Connection could not be obtained; returning null
Solutions:
Make sure your database listener is up and running.
if not, please start listenerer and run autoconfig again.
Hope, your issue will resolve it.
Error:
---------------------------------------------------------------
ADX Database Utility
---------------------------------------------------------------
getConnectionUsingAppsJDBCConnector() -->
APPS_JDBC_URL='null'
Trying to get connection using SID based connect descriptor
getConnection() -->
sDbHost : pmvtest
sDbDomain : evosysglobal.com
sDbPort : 1522
sDbSid : PMVTEST
sDbUser : APPS
Trying to connect using SID...
getConnectionUsingSID() -->
JDBC URL: jdbc:oracle:thin:@pmvtest.evosysglobal.com:1522:PMVTEST
Exception occurred: java.sql.SQLRecoverableException: 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=pmvtest.evosysglobal.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=PMVTEST)))
Exception occurred: java.sql.SQLRecoverableException: 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=pmvtest.evosysglobal.com)(PORT=1522))(CONNECT_DATA=(SERVICE_NAME=PMVTEST.evosysglobal.com)))
Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Connection could not be obtained; returning null
Solutions:
Make sure your database listener is up and running.
if not, please start listenerer and run autoconfig again.
Hope, your issue will resolve it.