could not load driver "oracle.jdbc.OracleDriver".

[Peewee71]

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?

[AussiePete2011]

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

[sashafay]

Yep, you need ojdbc5.jar, not ojdbc6.jar. Remove wrong file first, then copy required one and start Cognos Configuration again.

[Peewee71]

just to confirm that using ojdbc5.jar worked.

thx

[Karteek78]

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

[AussiePete2011]

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

[Karteek78]

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

[AussiePete2011]

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