ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Upgrades using Oracle RAC from Applications Manager v8 to v9 Fail

book

Article ID: 88836

calendar_today

Updated On:

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.