Home / APPS DBA / Autoconfig fails with IO Error: The Network Adapter could not establish the connection

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

 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.

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleEBSerror

AC-50480: Internal error occurred

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora

Leave a Reply