UDA-SQL-0432 Unable to locate the gateway “cogudaor”.

Product:
Cognos BI 10.1.1
Framework Manager
Oracle 11g

Symptom:
Data source connection in Cognos Connection is working.
Framework Manager is installed on a workstation.
But when you connect to a Oracle data source you get a error message.

Error Message:
QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
FM1
UDA-SQL-0031 Unable to access the “FM1” database.
UDA-SQL-0532 Data Source is not accessible: “DRPDB”.
ORA-12154: TNS:could not resolve the connect identifier specified

Above is when tnsnames.ora is missing.

Other error message:
QE-DEF-0285 The logon failed.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
FM1
UDA-SQL-0432 Unable to locate the gateway “cogudaor”.

Above is when oracle client folder is not in windows path.

Solution:
Ensure you have installed the full 32 bit Oracle 11g administrator client on the computer where Cognos FrameWork Manager is installed. Framework Manager only works with the 32 bit Oracle client.

Ensure that you have the added the path to the bin folder of the Oracle client to windows system path e.g. \oracle\product\11.2.0\client_1\bin.
The path can be pointing to a old Oracle client installation, ensure the BIN folder exist in the path.

Ensure that the tnsnames.ora file is updated and contain the reference to the oracle database that is used in cognos connection. Best is to copy the tnsnames.ora file from the Cognos BI server to workstation where you have Cognos Framework manager installed. Place the tnsnames.ora file in folder \oracle\product\11.2.0\client_1\network\admin\. Ensure that tnsnames.ora file is in the oracle client folder that is in use, and that are referenced from the path variable.

Exit Framework manager program before you test again, to ensure the changes have taken affect.

More information:
http://www-01.ibm.com/support/docview.wss?uid=swg21341734