CMN_1038 Oracle Error When Working With Sessions

[buzzi321]

With Oracle9i database as target, I create mapping and validate it. Then I run the session in server manager, It
always give me an error message like:

"CMN_1038 ORACLE ErrorCMN_1038[Function :Connect Error:
ORA-12154LTNS:Could Not resolve service name"


Please Help

 

[walkerci]

Try logging on as an OS user on the server running the Informatica server.

Then invoke SQLPLUS and try to connect to the Orace database using the same host name, user id, and password.

If you can't connect, then the problem is likely to be a missing or bad tnsnames entry.

Alternatively, you can test the connection using Oracle Net Configuration Assistent.

Let me know whether this helps.

Charles

 

[buzzi321]

Thanks for ur reply, I Got it. The Problem Is With Connection String. I Gave The A Wrong COnnection String In Both SOurce & Target Connections