JDBC connection for Dynamic cubes

[madhancog]

HI Gurus,
   I have installed cognos 10.2 in my windows 2008 server along with this i have installed oracle 10g client in the same machine.
   oracle 11g server is installed some other windows 2008 server,now i am able to connect and work with ODBC connection,I tried to create JDBC connection the connection is failing,i searched in interner i need to take ojdbc6 jar file from oracle client location but i am not able to find in that place ,so i took from internet the same file and put i the cognos location it is not working.please guide me.

Thanks in advance
K.M

[sunosoft]

Hi Madhan,

Try to find ojdbc5.jar.

Its working in my env with ojdbc5

It should be in the oracle installtion....path can be like D:\ora\oracle\product\11201_64\jdbc\lib

[madhancog]

HI,
  Thanks for the suggestion,Let me know which version of oracle is used by you and is it oracle server or oracle client?

REgards,
K.M

[sunosoft]

Its oracle 11g client.

[madhancog]

HI ,
  I have installed oracle 11g client and found the ojdbc5.jar and then i have placed the file in the cognos p2p /lib folder.
  then also it is not responding ,can u pls help with complete steps.

Thanks in advance,
K.M

[MFGF]

Hi,

The steps are really simple - look at Chapter 5 in the Installation and Configuration guide at the section entitled "Set up database connectivity for an Oracle content store"

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1.1/inst_cr_winux.pdf

MF.

[sunosoft]

Let us know the error that you are facing. Any screenshot ?

[madhancog]

HI ,
  Attaching the error screen shot.

Thanks,
K.M

[sunosoft]

Hi,

Please check what you are entering at the below field while doing the settings for JDBC.

Oracle Service ID:ORCL

ORCL  is the default value. If you keep that value to default you will receive the error which you sent in screenshot.

You need to change this value to your DB SID. Then it should work.

You can modify the existing data source also. Just go to the properties of data source connection then go to the connection tab, click on edit connection string. Then go to JDBC and check what is the value there for Oracle Service ID. If its ORCL then change it to your DB SID. If its already set to DB SID then we might need to check something else.

Let me know the result.

[sunosoft]

Hi,

did you reoslve the issue?

Let us know if there was something else which was causing the issue, it will be a good information to have with us.