ERROR
—————————————————————
ADX Database Utility
—————————————————————
getConnectionUsingAppsJDBCConnector() –>
APPS_JDBC_URL=’null’
Trying to get connection using SID based connect descriptor
getConnection() –>
sDbHost : db
sDbDomain : www.erp.com
sDbPort : 1521
sDbSid : VIS
sDbUser : APPS
Trying to connect using SID…
getConnectionUsingSID() –>
JDBC URL: jdbc:oracle:thin:@pmvtest.evosysglobal.com:1521: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=www.erp.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=VIS)))
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=www.erp.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=www.erp.com)))
Exception occurred: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
Connection could not be obtained; returning null
SOLUTION
This error comes if the Database Listener is not running.
Please start Database listener and run autoconfig again.