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"

 

[Dagon]

The session runs on the server, not on your PC. Your server needs to have this target correctly configured.

 

[smajay]

This error accurs because there is no TNS entry for the database on the server where Informatica server is running.
Configure the TNSNAMES file on the server and connect using SQLPLUS,if it works then try using informatica server Manager. If it works thro' sqlplus and not thro' server manager than the problem is with database connection configuration in server manager.


- Ajay

 

[buzzi321]

Thanks For Ur Reply & Sugession
I Didnt Gave Connect String Properly In BY DataBase Connection

ThanQ