DSXchange

Posted: **Mon Nov 20, 2006 2:09 pm**

Hi , Im working on Datastage Server jobs ver 5 which is on unix server ,i have a database which is on windows. when i put data from file to the target DB on windows which is oracle im getting "TNS: could not reolve the service name.
I can however login onto the Database using PL/SQL developer tools from my desktop.

Any entries which needs to be made in server side or local PC to resolve this issue.

Thanks In Advance.

Posted: **Mon Nov 20, 2006 2:14 pm**

DataStage server is not on your desktop. You must correctly configure tnsnames.ora on the DataStage server machine (and have Oracle client software installed there).

Posted: **Mon Nov 20, 2006 3:32 pm**

Did you contact your support teams to make sure that all the TNS entries are defined on the server ?

DSXchange

Unable to view data ,target database on windows.DS on unix.

Unable to view data ,target database on windows.DS on unix.

Re: Unable to view data ,target database on windows.DS on un