Announcement

Collapse
No announcement yet.

Error with update_content for dbpatch, new install

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

  • Error with update_content for dbpatch, new install

    Hello,

    I’m hoping someone can help to point me in the right direction so that I can overcome an error I’m having as part of my first OTM install, which is purely as a test / look and see mission.

    Basically I cannot fix a Java error when the update_content command is run as part of
    the dbupdate_55.sql job for the initial install of OTM 555.

    Reported error from within the command prompt when update_content.cmd is ran.
    //
    Build Number is 5.5 (Patch) (200806052207)
    ECHO is off.
    Inserting new glogowner data...
    V55P_PARTITION_KEY_FORMULA
    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    at java.net.URLClassLoader$1.run(URLClassLoader.java: 199)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.j ava:187)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:2 89)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:274)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:2 35)
    at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:302)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:141)
    at glog.database.admin.CSVUtil.initializeConnection(C SVUtil.java:2797)
    at glog.database.admin.CSVUtil.run(CSVUtil.java:2689)
    at glog.database.admin.CSVUtil.main(CSVUtil.java:3017 )
    //

    Environment and install steps
    Server1: Windows 2003 server for OTM/OAS/Web/oracle client
    Server2 :Windows 2003 server for Oracle 11g Db


    I believe that the main install went fine with no reported errors.

    1. …installlog.xml actions summary section were all successes.
    1b. I followed the steps listed in the readme.txt to replace the key files (I didn’t do the steps with regards to improving performance)
    2. The db import only had compile issues (ora-00041)
    3. Each db step/script listed in the administration guide ran fine
    4. DB object counts where correct
    5. DB recompile left all objects valid
    6.dbupdate_55.sql ran correctly (from what I can tell) up until the update_content where I got the above error.


    I have left all configuration files as they where installed and as yet haven’t started any services.

    Thanks in advance for any help anyone is able to give.

  • #2
    Re: Error with update_content for dbpatch, new install

    Make sure to set your otm\install\gc3env.cmd before re-running the patch. That should take care of your error. Be sure in that file you have the correct path to your Oracle Home.
    If my post was helpful please click on the Thanks! button

    MavenWire Hosting Admin
    15 years of OTM experience

    Comment


    • #3
      Re: Error with update_content for dbpatch, new install

      Hi,
      Thanks for the reply.

      Sorry I should have confirmed in my first post that I ran gc3env.cmd before running the dbupdate script.

      I believe I have the oracle home correct for the client
      (C:\app\Administrator\product\11.1.0\client_1)

      sqlplus will not run if I set oracle_home to anything other than the above.

      Any other things that I can check or try?

      Many Thanks

      Comment


      • #4
        Re: Error with update_content for dbpatch, new install

        Can you check that your gc3env.cmd contains the following classpath
        set CLASSPATH=%CLASSPATH%;%GLOG_HOME%/oas/jdbc/lib/ojdbc14dms.jar;%GLOG_HOME%/oas/lib/dms.jar
        --
        Joseph Liang
        MavenWire APAC
        http://www.mavenwire.com/

        Comment


        • #5
          Re: Error with update_content for dbpatch, new install

          Hello,

          Yes my classpath was missing that line, adding it in is now allowing it to run through.

          It is currently running, I'll be checking all the logs etc that I can find with interest, but I can see that the first couple of tables have had an extra row inserted.

          Do you know/think/suspect that I may have missed out a step of the install for that detail to be missing from gc3enc.cmd ?

          Many thanks for your help.

          Comment


          • #6
            Re: Error with update_content for dbpatch, new install

            It is an installer bug since CU4. And this problem only affects OTM running OAS.
            It appears that Oracle has trouble getting this right. Because in CU2 and CU3 another two classpath were missing:
            Code:
            set CLASSPATH=%CLASSPATH%;%GLOG_HOME%/oas/j2ee/home/lib/ejb.jar;%GLOG_HOME%/oas/j2ee/home/lib/jta.jar
            --
            Joseph Liang
            MavenWire APAC
            http://www.mavenwire.com/

            Comment


            • #7
              Re: Error with update_content for dbpatch, new install

              Yeah there seems to be a few niggles on the install process, or at least there is for setting up an environment such as this one!

              Comment


              • #8
                Re: Error with update_content for dbpatch, new install

                Hi,

                Thank-you for the help today and the previous information that has been posted on this forum.

                I've managed to complete the install, I have OTM up and running plus the sample domestic_truckload model is in a test domain - so the first step has been taken.

                Thanks again.

                Comment


                • #9
                  Re: Error with update_content for dbpatch, new install

                  Not sure how big your organization is but I highly recommend you look at Weblogic instead of OAS. Trust me the performance issues down the road won't be worth keeping OAS. Shell out the extra money and get Weblogic, you won't be disappointed.
                  If my post was helpful please click on the Thanks! button

                  MavenWire Hosting Admin
                  15 years of OTM experience

                  Comment


                  • #10
                    Re: Error with update_content for dbpatch, new install

                    Actually I've read that comment a few times on here. At the moment it is purely for us to try and take a hands on look at (and therefore gain a better understand of), so I tried to go for the easiest and cheapest way for me to get something running.

                    Once we get to the stage of taking things more seriously then I will be looking at hardware, o/s and all different configuration options available - but thanks for the heads up.

                    Comment

                    Working...
                    X