OD6.0 Reports with Oracle 9.2 database

I am trying to configure Oracle9.2 database for OD 6.0 reports. I have TeamSite 6.1 SP1 on Solaris 8. I have Oracle 9.2 client on TeamSite server. I did all the changes according to the OD 6.0 Admin Guide (Page# 261).

I have changed <iwodhome>/bin/iwodstart, added the following lines

# set classpath - adding the JDBC driver for Oracle
ORACLE_HOME=/oracle/product/9.2
LD_LIBRARY_PATH=/oracle/product/9.2/lib
TNS_ADMIN=/oracle/product/9.2/network/admin
ORACLE_CLASS=$ORACLE_HOME/jdbc/lib/ojdbc14.jar
JAVA_CLASSPATH=$OD_JARS:$JAVA_CLASSES:$ORACLE_CLASS

I have copied classes12.jar and ojdbc14.jar from 9.2 client into <odAdmin>/httpd/iwwebapps/opendeploy/WEB-INF/lib folder.

in the <odAdmin>/odadmin/config/adminEventReportingConfig.xml, I have
<database name="ReportingDB"
className="oracle.jdbc.driver.OracleDriver"
connectionString="jdbc Smiley Surprised

racle

ci:@TNSNAMEENTRY">
<property name="user" value="USERNAME" />
<property name="password" value="PASSWORD" />
</database>

In the <odAdmin>/odadmin/log/server_database.log. i am getting following messages

2004-09-22 11:38:28 EDT - === Log Opened ===
2004-09-22 11:43:07 EDT - DriverManager.initialize: jdbc.drivers = null
2004-09-22 11:43:07 EDT - JDBC DriverManager initialized
2004-09-22 11:43:07 EDT - registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@35ae7e]
2004-09-22 11:43:07 EDT - DriverManager.getConnection("jdbc Smiley Surprised

racle

ci:@TNSNAMEENTRY ")
2004-09-22 11:43:07 EDT - trying driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@35ae7e]
2004-09-22 11:43:15 EDT - DriverManager.getConnection("jdbc Smiley Surprised

racle

ci:@ TNSNAMEENTRY ")

in the <odAdmin>/odadmin/log/server_odadmin_servletd.log. I am getting following error.

java.lang.UnsatisfiedLinkError: no ocijdbc9 in java.library.path
at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1344)
at java.lang.Runtime.loadLibrary0(Runtime.java:744)
at java.lang.System.loadLibrary(System.java:815)

Any idea what I can do to resolve this? Thanks a lot for your help

Find more posts tagged with

Comments

Migrateduser

Looks like you're using an OCI driver. Do you have the corresponding OCI software installed?

Otherwise, consider using a pure Java Oracle driver.

Also, you shouldn't be changing iwodstart. That's a legacy command line tool that has nothing to do with the reporting feature.

Todd Scallan
Director of Product Management
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com

SriniYA

Hi Todd.....

We have Oracle 9.2 client on TeamSite server. We have Oracle parallel servers. So I have to use OCI drivers to connect to the database.

I was told to modify iwodstart command to specify ORACLE_HOME, JAVA_CLASSPATH by Interwoven Tech support. So my Question is , how do I specify ORACLE_HOME, JAVA_CLASSPATH for OD Reports.

Thanks in Advance....

Migrateduser

I believe any of the files required by the driver need to be located in <admin-home>/httpd/iwwebapps/opendeploy/WEB-INF/lib.

If you intend to change the class path or introduce other environment variables for use by the reporting server or driver, that would have to be somewhere in the OD Admin Server startup, since the reporting server is part of the admin server process. (I.e., the admin server is the Oracle client who updates the database.)

I'm not sure exactly where you would make such changes. So, you might want to focus your query with Tech Support on how to configure reporting for the OCI driver. If they can't provide an answer, then they should request "techspert" and/or engineering assistance.

Hope that helps.

Todd Scallan
Director of Product Management
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com