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)

Cause

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

Environment

Release :

Component :

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