Upgrades using Oracle RAC from Applications Manager v8 to v9 Fail

Products

CA Automic Applications Manager (AM)

Issue/Introduction

Environment

Release: AAMORS99000-9.0-Automic Applications Manager-Oracle - RMS
Component:

Resolution

Error Message Details:

ErrorMsg: AwE-5001 Database Query Error (3/26/15 1:24 PM)
Details: null
java.sql.SQLRecoverableException: IO Error: NL Exception was generated
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:553)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:254)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:528)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.appworx.server.sql.AxConnectionPool.getConnection(AxConnectionPool.java:375)
        at com.appworx.server.sql.DBAccess.getConnection(DBAccess.java:1500)
        at com.appworx.server.sql.CommonDB.A(CommonDB.java:564)
        at com.appworx.server.sql.CommonDB.A(CommonDB.java:540)
        at com.appworx.server.sql.CommonDB.getSqlData(CommonDB.java:182)
        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:202)
        at com.appworx.server.data.AxRmiServer.Ä¶(AxRmiServer.java:2939)
        at com.appworx.server.data.AxRmiServer.setupMasters(AxRmiServer.java:2792)
        at com.appworx.server.data.AxRmiServer.main(AxRmiServer.java:901)
Caused by: oracle.net.ns.NetException: NL Exception was generated
        at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:648)
        at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:443)
        at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:693)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:251)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
        ... 17 more

Symptoms

If you have Applications Manager v8.0x installed using Oracle RAC and attempt to upgrade to Applications Manager v9.x, the installation will fail with the above errors.

Cause

In AM v8.x the DriverUrl value specified was:

DriverUrl=jdbc:oracle:thin:@//{host}:{port}/{sid}

However, in AM v9.x the DriverURL must be modified in the Options.properties file to exclude the '//'.

Resolution

Add a line in the $AW_HOME/web/classes/Options.properties file. The JDBC Driver name section would look similar to this:

#
# JDBC driver name
#
DriverName=jdbc:oracle:thin
DriverUrl=jdbc:oracle:thin:@{host}:{port}/{sid}
#

*Note: If there is already an entry in your Options.properties file for the DriverURl, then you will need to modify the entry and remove the '//' so that the entry looks like the one above.