Hi,
I'm setting up a new cognos BI instance 8.4.1 on a windows 2008 R2 Standard 64 bit server. Oracle client version 11.2.0 is installed. I can connect to my content manager database ok via sqlplus. I have copied ojdbc6.jar to the appropriate cognos directory.. C:\Program Files (x86)\cognos\c841\webapps\p2pd\WEB-INF\lib
Within Cognos Configuration I have created a new oracle advanced type and have completed the appropriate user ID & password and database specifier. If i test this connection within cognos configuration i am getting the following error.
[ ERROR ] The database connection failed.
[ ERROR ] Content Manager failed to start because it could not load driver "oracle.jdbc.OracleDriver".
Any idea on how to fix this one?
Hi there
Try dropping back to the ojdbc5.jar file. Remember to remove the ojdbc6.jar file before testing
I've seen this before and using ojdbc5 usually solves the issue.
Its known as an issue in IBM Cognos Support
Cheers
Peter B
Yep, you need ojdbc5.jar, not ojdbc6.jar. Remove wrong file first, then copy required one and start Cognos Configuration again.
just to confirm that using ojdbc5.jar worked.
thx
Hi All,
Even after following the above process i face the same issue. Please help me out in this issue and i am using the same database
hi there,
Do you have under the lib folder
classes12.jar as well as ojdbc5.jar?
If you do please remove the classes12.jar file.
Also just so we understand you r environment
What is the Oracle database you are attempting to connect to
Cheers
Peter
Hi Peter,
The oracle database which i am trying to connect is 11.2.0.1.0 32 bit and i don't have classes12.jar in my lib folder
Thank You,
Karteek
Hi there
Ok, Oracle 11.2 which I believe is Oracle 11g Release 2 which is only supported for Cognos 8.4.1 FP2 - https://www-304.ibm.com/support/docview.wss?uid=swg27017522#contentstore
Can you confirm that the Oracle database is using either AL32UTF8 or AL32UTF16?
https://www-304.ibm.com/support/docview.wss?uid=swg21513190
What is the exact error you are seeing when starting the Cognos Services?
Cheers
Peter