Data base connectivity

[svenkat16]

Hi,

cognos 8 is  installed on my local(MS sql server)  on my computer and content store is on the same machine. And I want to connect another database Oracle9i it is the client version installed , i can able to view the data in sql+, but I am not able to connect that DataBase, I had provided connecting string and User id and password. When I test the connection following errors are  getting are

1. QE-DEF-0285 the log on failed
2. QE-DEF-0325 the logon failed for the faloowing reason
3. RQP-DEF-0068 unable to connect  at least one database during a multi database attach to 1           database(s) in test data data source connection.
4. UDA-SQL-0432 unable to locate gate way "cogudaor".

These are some errors identified when I test the connection

Any one can help me on this problem IMMDATELY  PLEASE

with regards

venkat

[MFGF]

Hi,

This looks very similar to the thread below.

http://www.cognoise.com/community/index.php?topic=1035.0

Does this help any?

Regards,

MF.

[CogDT]

1) You can tnsping the SID?
2) You copied the JDBC driver (classes12.jar) file from the Oracle server to your \webapps\p2pd\WEB-INF\lib directory?

[svenkat16]

1. yes I copied the JDBC driver (classes12.jar) file from the Oracle server to your \webapps\p2pd\WEB-INF\lib director
2. I had entered the TNS entry in the tns names of oracle.

I not able to connect to the client   oracle database. Help me fast o this

Thanks
venkatesh

[CogDT]

You mentioned that you had the 9i client installed locally.  What's the client version, and which version of C8 are you on?  I believe for 9i and C8 MR2 the supported client is 9.2.0.1.

It might be worth checking out KB#: 1006149 to help you troubleshoot exacty what's going wrong.

When was the last time you rebooted your local machine?  That seems like a really dumb question because rebooting rarely does anything, but I've seen issues with TNSnames entries not "taking" unless a reboot is done to register them, EVEN if the connection can be made from SQLPlus

[larsonr]

Make sure that where you are hosting the C8 application you have a version of the client (SQL+) that is compatible with the database you wish to connect to.  If your TNS names are created correctly you should only have to reference an Oracle database with its Service Name when creating the datasource in Cognos Connection.    Ex... we are using a 10g client on the application server to connect to a 9i Oracle database. (recommended by support actually).

Also, verify that you have the username/password set up as a sign on (for ease), then test.  If successful, you should be able to connect with the database for reporting with success.

Also, what version of the JRE are you using with your install.  Anything past and including 8.1 MR1 uses Java 1.4.2 as its default JRE.  Technically you are going to run into problems with Oracle connectivity since 1.4.2 and higher requires ojdbc14.jar instead of classes12.jar.   They have fixed this with 8.2 and are finally using the right jdbc drivers.  Your installation will work if still using previous versions to 8.2, but every so often your users will see "No sessions available."  Our team has determined that is the biggest opportunity Cognos missed with us throughout all of our service tickets on the issue. 

[RudiHendrix]

I'm having the same problem.
I can use SQL Developer to connect to the database from my server and from the machine where I have installed framework manager. But I'm not able to create a connection from Cognos administration.

I'm using Cognos 8.4.

What should be a correct SQL*Net connect string for Oracle?