oracle stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
bhargava129189
Participant
Posts: 18
Joined: Tue Nov 15, 2005 9:36 am

oracle stage

Post by bhargava129189 »

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.
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Check here for thompsonp's response, see if that helps.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
bhargava129189
Participant
Posts: 18
Joined: Tue Nov 15, 2005 9:36 am

its not helping.

Post by bhargava129189 »

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
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

Hi,
Not remote server ip. You put your SID defined, e.g. ora10g, in your tnsnames.ora file in the Remote Server= of Connection of Properties tab.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”