SOLUTION OF ((ERROR while connecting ORACLE through COGNOS EXPRSS MANAGER !))

[mohsin2010]

hi!
I am getting error while connecting to ORACLE through COGNOS EXPRESS MANAGER (under LAUNCH menu IBM cognos administration>configuration>datasource) during connrction to oracle i m getting error

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:
    testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" database.
UDA-SQL-0532 Data Source is not accessible: "XE".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(744): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(475): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(718): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(716): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1535): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2064): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(807): QFException: CCL_THROW: QE


on the same express manager i m able to connect through ODBC connection so why i m getting the above error while connecting through ORACLE please help me to get rid of this error ??? 

SOLUTION:
http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14251287

Solution of this problem is in the link above but i am not understanding his solution does any one make me understand his answer please HELP i am new BIE  :'(

[MFGF]

Hi,

The solution quoted was

The error was due the fact the tnsnames.ora on one of the dispatchers did nto have the entery for the DB in question

As I suspected (guessed) in your previous thread, this looks like an ORACLE config problem - you need to add the name of your connection into the Oracle TNSNAMES.ORA file to allow Oracle to resolve how to connect to it.

It's not a Cognos problem - it's down to how you have configured your Oracle instance.

MF.

[arif_baykan@hotmail.com]

Yes this is a tnsnames.ora problem. Please dont try connection string  like a jdbc:thin.... Enter connection string as ORCL(). I had the same problem. but I solved it.