not able to use oracle stage in parallel job. job log says
TNS no listener.
Not able to find out where to give the data source name like we give in server job.
oracle stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 18
- Joined: Tue Nov 15, 2005 9:36 am
its not helping.
chulett wrote:Check here for thompsonp's response, see if that helps. ...
I have given remote server ip still its not running.
Connect failed.
:TNS no listener and also i am able to access the table metadata for the same database
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It may really mean that there is no listener available. Imagine that your Oracle DBA has configured 14 listeners, and 14 are already in use servicing other clients/queries. In this case you will get this message if you attempt to initiate a new query.
It is not a DataStage-generated problem.
It is not a DataStage-generated problem.
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.