search cancel

java.sql.SQLRecoverableException: IO Error: Unknown host specified

book

Article ID: 220972

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Applications Manager's master fails to start with the below error, seen in the RmiServer.log

ErrorMsg: AwE-5001 Database Query Error
Details: getConnection
        null
java.sql.SQLRecoverableException: IO Error: Unknown host specified
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:774)
        at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:688)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:39)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:691)
        at java.sql.DriverManager.getConnection(DriverManager.java:664)
        at java.sql.DriverManager.getConnection(DriverManager.java:208)
        at com.appworx.server.sql.AxConnectionPool.getConnection(AxConnectionPool.java:378)
        at com.appworx.server.sql.DBAccess.getConnection(DBAccess.java:1541)
        at com.appworx.server.sql.CommonDB.A(CommonDB.java:565)
        at com.appworx.server.sql.CommonDB.A(CommonDB.java:541)
        at com.appworx.server.sql.CommonDB.getSqlData(CommonDB.java:183)
        at com.appworx.server.data.MasterDB.<init>(MasterDB.java:211)
        at com.appworx.server.data.MasterDB.<init>(MasterDB.java:186)
        at com.appworx.server.data.Master.<init>(Master.java:201)
        at com.appworx.server.data.AxRmiServer.į(AxRmiServer.java:2920)
        at com.appworx.server.data.AxRmiServer.setupMasters(AxRmiServer.java:2773)
        at com.appworx.server.data.AxRmiServer.main(AxRmiServer.java:896)
Caused by: oracle.net.ns.NetException: Unknown host specified
        at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:209)
        at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:131)
        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:489)
        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:660)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1438)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:518)

Notice the bolded "null" value. If the error message does not contain a null value, this article may not apply to the issue.

Cause

Can generally be seen if incorrect manual updates have been made to core Applications Manager files such as the awenv.ini or Masters.properties 

Environment

Release : All

Component : Applications Manager

Resolution

Review any recent changes to host/IP values in the following files and make sure the correct values are set:

  • Options.properties
  • awenv.ini
  • Masters.properties