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 :'(
Hi,
The solution quoted was
QuoteThe 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.
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.