Upgrades using Oracle RAC from Applications Manager v8 to v9 Fail

Document ID : KB000088836
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Upgrades using Oracle RAC from Applications Manager v8 to v9 Fail
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.