Web Console install XML scripts not running and how to use the Oracle JDBC drivers as a workaround

  • 3528900
  • 01-May-2007
  • 27-Apr-2012

Environment

Novell ZENworks Asset Management 7 - ZAM7
Oracle 9i
Solaris

Situation

When Tomcat extracts the rtrlet.war file, a series of XML scripts should run to prepare the Oracle 9i database (on Solaris).For example, this would happen when a Web Console patch is applied.

However, XML processing sticks on patch3_1.xml file & does not create expected "finished" or "failed" subdirectories under the Tomcat applet directory.
In addition, the debug version of rtrlet.log shows no apparent error.

The custom report description line is showing as gibberish within this Oracle environment

Web Console install XML scripts not running

An additional symptom noticed is that the Apache Tomcat service also stops.

Resolution

The cause appears to be problems with the ODBC drivers communicating with certain Oracle versions/patchsets.

The suggested resolution is to have the WebConsole use JDBC drivers rather than ODBC drivers. To do this, the drivers need to be installed and settings need to be changed in the DBName and DBDriver settings in the rtrsetup.xml file under Tomcat. The instructions to change the drivers are listed at the bottom of this note.

Before changing to JDBC drivers, please verify you are using the 1.4.2 JDK (not 1.3). If they are on 1.3, please have them upgrade before doing any further steps. If you do not want to move to JDBC drivers, you could make sure to apply the latest Oracle patchset and the latest ODBC patch available for your installation. If this does not solve the problem, then we would suggest moving to JDBC drivers.


1.You can find the Oracle file on the Oracle client, usually in the folder"jdbc\lib". It will be named ojdbc14.jar.

2. Stop Apache tomcat service.

3. Place the .jar or .zip file in the Tomcat\common\lib directory.

4. Modify the RTRSETUP.xml file in the tomcat\webapps directory. There are two sections that need to be modified:

A. The DBDriver parameter should look like this:

DBDriver

oracle.jdbc.driver.OracleDriver

B. The parameter called "DBName" should be set to"jdbc:oracle:oci:@QA920A", replacing "QA920A" with the name of your database instance.

Like this:

DBName

jdbc:oracle:oci:@QA920A

5. Restart the Apache tomcat service.

Additional Information

Formerly known as TID# 10100113
This behavior has been seen before when using Oracle 9.2.0.6 on Win32.

Feedback service temporarily unavailable. For content questions or problems, please contact Support.