Upgrades using Oracle RAC from Applications Manager v8 to v9 Fail

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Upgrades using Oracle RAC from Applications Manager v8 to v9 Fail

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.

---