Environment
Situation
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:
B. The parameter called "DBName" should be set to"jdbc:oracle:oci:@QA920A", replacing "QA920A" with the name of your database instance.
Like this:
5. Restart the Apache tomcat service.