Print Page - JDBC connection for Dynamic cubes

Title: JDBC connection for Dynamic cubes
Post by: madhancog on 13 Dec 2013 08:50:02 PM

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

Title: Re: JDBC connection for Dynamic cubes
Post by: sunosoft on 14 Dec 2013 04:43:35 AM

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

Title: Re: JDBC connection for Dynamic cubes
Post by: madhancog on 16 Dec 2013 12:23:06 AM

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

Title: Re: JDBC connection for Dynamic cubes
Post by: sunosoft on 16 Dec 2013 01:11:14 AM

Its oracle 11g client.

Title: Re: JDBC connection for Dynamic cubes
Post by: madhancog on 18 Dec 2013 07:10:59 AM

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

Title: Re: JDBC connection for Dynamic cubes
Post by: MFGF on 18 Dec 2013 10:48:07 AM

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.

Title: Re: JDBC connection for Dynamic cubes
Post by: sunosoft on 18 Dec 2013 05:05:36 PM

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

Title: Re: JDBC connection for Dynamic cubes
Post by: madhancog on 18 Dec 2013 10:43:17 PM

HI ,
Attaching the error screen shot.

Thanks,
K.M

Title: Re: JDBC connection for Dynamic cubes
Post by: sunosoft on 19 Dec 2013 12:40:26 AM

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.

Title: Re: JDBC connection for Dynamic cubes
Post by: sunosoft on 20 Dec 2013 12:15:18 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Administration => Topic started by: madhancog on 13 Dec 2013 08:50:02 PM