Download the ojdbc14_g.jar from oracle and make a modification to a Cognos file to leverage it.
Steps:
1. Download the ojdbc14_g.jar file from oracle
2. Remove the c8/webapps/p2pd/WEB-INF/lib/ojdbc14.jar and store in safe place after stopping IBM Cognos 8 service.
3. Insert the ojdbc14_g.jar in c8/webapps/p2pd/WEB-INF/lib/ojdbc14_g.jar
4. Backup the c8/bin/bootstrap_win32.xml and open it in a text editor
5. Search these 2 lines:
<param>"-cp"</param>
<param>"${install_path}/tomcat4.1.27/bin/bootstrap.jar;${java_home}/lib/tools.jar"</param>
6. Add the following line editing the path to save the log file if required, AFTER the 2lines mentioned above
<param>"-Doracle.jdbc.LogFile=D:\temp\orajdbc.log"</param>
7. The file bootstrap_win32.xml should look like this:
<param>"-cp"</param><br>
<param>"${install_path}/tomcat4.1.27/bin/bootstrap.jar;${java_home}/lib/tools.jar"</param>
<param>"-Doracle.jdbc.LogFile=D:\temp\orajdbc.log"</param>
8. Start the Cognos 8 service again and the logfile created and written to.
www.cogknowhow.com