Cognos analytics(CA 11.0.6) unable to create the new ORACLE datasource

[bhupalalerts@gmail.com]

I have installed the CA 11.0.6 and I can upload the Excel files in cognos .But now I am trying to create the

Oracle 11 R2 as a data source in Cognos connection. I have installed the oracle client version and placed the JDBC drivers in below mentioned locations in CA 11 to connect the database.
Details;
32- bit Oracle 11G R2 as client software: installed  Cognos server
Cognos analytics 11.0.6 with Easy install in  single server

I have created the new schema with full permissions and I can able to connect the same in Oracle (toad) directly. However whenever I created the new connection from Cognos its getting failed .its means it's not working the Cognos from Cognos to oracle. I have placed all the Jdbc drivers  from oracle lib  to Cognos drivers  ojdbc5.jar and  ojdbc6 .jar
Cognos location:




Oracle location "
•         C:\app\Administrator\product\11.2.0\client_1\jdbc\lib




Cognos data source connection:

[jfitzgerald]

the jdbc file is also placed .....\ibm\cognos\analytics\drivers   
(assuming you are not changing the defaults). ?

[the6campbells]

Copy the ORACLE JDBC driver (ojdbc8.jar or ojdbc7.jar)  into <cognos>\drivers

See also

https://www-01.ibm.com/support/docview.wss?uid=swg21987705

https://www-01.ibm.com/support/docview.wss?uid=swg22001003