Page 1 of 1
oracle stage
Posted: Wed Jul 12, 2006 10:04 am
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.
Posted: Wed Jul 12, 2006 10:15 am
by chulett
Check
here for thompsonp's response, see if that helps.
its not helping.
Posted: Wed Jul 12, 2006 10:41 am
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
Posted: Wed Jul 12, 2006 11:26 am
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.
Posted: Wed Jul 12, 2006 2:24 pm
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.