Blog Post

Autoconfig fails with IO Error: The Network Adapter could not establish the connection

May 5, 2017 APPS DBA, Errors/Workarounds-Applications by Syed Saad Ali

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.

Write a comment