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.
Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner