cogudaor

[gitachand]

Hi friends,

I have installed Framework Manager on my computer. I set up Cognos Configuration correctly. I was able to run FM but when I tried to Test the database (Oracle) connection, I am getting the below error messages. My computer already got loaded with TOAD which is working properly and is able to refer TNSNAMES.ORA(though TNSNAMES.ORA is residing on a network drive instead of on my local computer).

Any help please? Thanks.

UDA-SQL-0432 Unable to locate the gateway 'cogudaor' error generated in Framework Manager when trying to import metadata.


Error Message:

QE-DEF-0285 Logon failure.
QE-DEF-0325 The cause of the logon failure is:
QE-DEF-0068 Unable to connect to at least one database during a

multi-database attach to 1 database(s) in:

UDA-SQL-0432 Unable to locate the gateway 'cogudaor'.


Solution:

In order to import metadata into Framework Manager from an Oracle data source, you need to have the Oracle client installed on the local computer.  Without the client you may still be able to create the data source and test the data source connection, but you will need the Oracle client to import the metadata.

Once the Oracle client has been installed, add the necessary entry to the tnsnames.ora file on the local computer.

[Draoued]

does your CRN server has it also ??

Database connection are created in the crn server, and FM is reading this info and storing new source in the server as well.
Open a connection to Cognos connection with Admin rights , go to Tools/ Directory and then to Data Source tab.
Add a new source and test if it s able to get the connection from there.

[RudiHendrix]

Posting this in a few threads because they are all very old:
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?