Error with update_content for dbpatch, new install

[fcapps Junior Member Find all posts View Profile Close fcapps]

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.

[nick.polites Senior Member and Blogger Find all posts View Profile Close nick.polites]

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.

[fcapps Junior Member Find all posts View Profile Close fcapps]

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

[josephliang Senior Member and Blogger Find all posts View Profile Close josephliang]

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

[fcapps Junior Member Find all posts View Profile Close fcapps]

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.

[josephliang Senior Member and Blogger Find all posts View Profile Close josephliang]

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:

set CLASSPATH=%CLASSPATH%;%GLOG_HOME%/oas/j2ee/home/lib/ejb.jar;%GLOG_HOME%/oas/j2ee/home/lib/jta.jar

[fcapps Junior Member Find all posts View Profile Close fcapps]

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!

[fcapps Junior Member Find all posts View Profile Close fcapps]

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.

[nick.polites Senior Member and Blogger Find all posts View Profile Close nick.polites]

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.

[fcapps Junior Member Find all posts View Profile Close fcapps]

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.