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.
Unable to view data ,target database on windows.DS on unix.
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Unable to view data ,target database on windows.DS on un
Did you contact your support teams to make sure that all the TNS entries are defined on the server ?