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="jdbcracleci:@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("jdbcracleci:@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("jdbcracleci:@ 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
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="jdbcracleci:@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("jdbcracleci:@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("jdbcracleci:@ 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
0
Comments
-
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.com0 -
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....0 -
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.com0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 104 General Questions
- 141 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
TeamSite Developer Resources
If you are interested in gaining full access to the content, you can register for a My Support account here.
- Docker Automation
- LiveSite Content Services (LSCS) REST API
- Single Page Application (SPA) Modules
- TeamSite Add-ons
If you are interested in gaining full access to the content, you can register for a My Support account here.