DSXchange

Hi,

sequencer is not running fine and the showing below message.

sorry small correction, with the same credentials we ran two more sequencers, those worked fine but we ran 3rd sequencer showing below message

ExecStoredProc,0: Error: ORA-12545: Connect failed because target host or object does not exist.

Server connection is parameterized.


Pls help some one in this case.

Meaning, it runs fine when you start it but when you use a Job Activity stage in a Sequence job to launch it, it fails? And the connection information your stored procedure uses are parameterized? The obvious first thing to check is to verify that your parameters and values are A) correct in the Sequence job and B) being passed to the job correctly.

Check both logs to verify.

sorry craig...

with the same credentials we ran 1,2 sequencers but 3rd one failing and showing the above warning....

Doesn't change my answer. Did you carefully check both logs?

You may have a typo in your tnsname.ora file on the DataStage server or a typo in the stage properties. Double check your job logs that all parameters resolved correctly and double check your stage properties for typos.

Yes it problem with the host, DS is not connecting or Oracle host is not connecting with the DS, we are checking that.

what is meant "typo " eric

typo = typing mistake

If one character is wrong or missing, it will cause an error.

Eric,

tnsfile is copied one, which one we are using with datastage 8.5, same one copied and using for 9.1.2..

there is no changes in tnsfile even.

i checked more than double with hard code the server name in DS.

but still showing same message.

Clarify something for us... this third job that fails, does it run ok if you run it outside of the sequence?

Hi Eric,
Some one has changed the tns entries, still it's a mistry who has changed, after u r suggestion once ag we ain we checked everything and replace the correct one