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
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.