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

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.

Environment

Release : All

Component : Applications Manager

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 

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