Announcement

Collapse
No announcement yet.

JDBC Problems after applying OTM 5.5 CU5

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • JDBC Problems after applying OTM 5.5 CU5

    Hello All,

    We installed the OTM 5.5 CU5 patch and rollups 1-3 to our PROD system over the weekend. We started a couple months back by applying these updates to our DEV
    system. The DEV system has the App and Web servers on the same physical machine. Our TEST and PROD environments have dedicated servers for App and Web.
    The DB server is a separate machine in all 3 environments. Our DEV CU5/RU 1-3 install went smoothly. In both TEST and PROD, we saw the following error in
    the OAS console.log on startup after applying CU5.5 to web & app, running dbpatch55.sql, running insert_security_roles.sql, and attempting to start the
    application:

    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:26 -- OTM Startup: preDeploy
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:26 -- OTM Startup: initializing realm
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC
    INFO | jvm 1 | 2009/03/29 15:20:27 |
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at oracle.jdbc.driver.PhysicalConnection.<init>(Physi calConnection.java:363)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at oracle.jdbc.driver.T4CConnection.<init>(T4CConnect ion.java:165)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at oracle.jdbc.driver.T4CDriverExtension.getConnectio n(T4CDriverExtension.java:35)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at oracle.jdbc.driver.OracleDriver.connect(OracleDriv er.java:854)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.util.datasource.GC3ConnectionEstablisher.conn ect(GC3ConnectionEstablisher.java:34)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.util.datasource.DataSource.reserve(DataSource .java:14
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.util.datasource.DataSource.reserve(DataSource .java:137)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at
    glog.util.jdbc.noserver.T2SharedConnection$Referen cedConnection.addRef(T2SharedConnection.java:294)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.util.jdbc.noserver.T2SharedConnection.open(T2 SharedConnection.java:53)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.RdbmsRealm.queryAll (RdbmsRealm.java:19
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.RdbmsRealm.getKnown Groups(RdbmsRealm.java:1041)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.RdbmsRealm.getKnown Groups(RdbmsRealm.java:1053)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.CachingRealm.readKn ownGroups(CachingRealm.java:30
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.CachingRealm.initCa ches(CachingRealm.java:186)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.CachingRealm.<init> (CachingRealm.java:134)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.database.security.dbrealm.CachingRealm.initia lize(CachingRealm.java:122)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.util.j2ee.startup.OASStartup.startupRealm(OAS Startup.java:43)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at glog.util.j2ee.startup.OASStartup.onEvent(OASStart up.java:2
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at
    glog.util.j2ee.startup.OASStartupShutdownManager.p reDeploy(OASStartupShutdownManager.java:19)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at com.evermind.util.ClassDescriptor.executeStartupCl ass(ClassDescriptor.java:73)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at
    com.evermind.server.ApplicationServer.execStartupC lassesPreDeploy(ApplicationServer.java:1286)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at com.evermind.server.ApplicationServer.setConfig(Ap plicationServer.java:919)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at com.evermind.server.ApplicationServerLauncher.run( ApplicationServerLauncher.java:113)
    INFO | jvm 1 | 2009/03/29 15:20:27 | 09/03/29 15:20:27 at java.lang.Thread.run(Thread.java:534)

    After doing some research, the following solution worked for us:
    copied the following files from the database server path $ORACLE_HOME/jdbc/lib to the path $GLOG_HOME/jdk/jre/lib/ext on both the web and app servers:

    classes12dms_g.jar
    classes12dms.jar
    classes12_g.jar
    classes12.jar
    nls_charset12.jar
    ojdbc14dms_g.jar
    ojdbc14dms.jar
    ojdbc14_g.jar
    ojdbc14.jar

    I was just looking for feedback from anyone else who is on OTM 5.5 CU5 and using Oracle Application Server, or has any suggestions as to why we ran into this
    error on our environments with separate application and web servers.

    Thanks,
    Joe Patton

    Technical Specialist, DB2-Oracle DBA
    Database Management and Support
    Parker Hannifin Corporation
Working...
X