If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

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

Started by Peewee71, 10 May 2011 10:31:07 AM

Previous topic - Next topic

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