DSXchange

Hi All

I have a job which runs fine in normal project .
same job when imported in protected project and executed its throws an error.

Oracle_Enterprise_1: APT_OraInstanceSet::setup() failed to find an Oracle instance on node node1;
the hostname is `gpscgm10'.

Note : I am executing the job with same username "dsadm"
Note : While trying to view data in oracle stage it gives below error

##E TDOR 000288 09:47:54(001) <Oracle_Enterprise_1> APT_OraInstanceSet::setup() failed to find an Oracle instance on node node1;
the hostname is `gpscgm10'. [orainfo.C:762]
##E TFSR 000019 09:47:54(005) <main_program> Could not check all operators because of previous error(s) [api/step_rep.C:1144]
##E TCOS 000029 09:47:54(010) <main_program> Creation of a step finished with status = FAILED. [osh.C:1112]

any idea why this error occurs.

I suspect there is a problem with your environment variables not set properly in the protected project. I did a search on your error and found two results. Take a look at them
POST 1
POST 2
Hopefully you will find your answers in either of these two posts.
Regards,

Is the Oracle client propertly set up and configured on the machine whose fastname is mentioned in the configuration file for node1? In particular is there a tnsnames.ora file there that refers to the correct Oracle instance(s)?

Hi guys

Setting APT_ORACLE_NO_OPS = 1 in Administrator , job ran successfully. thanx a lot for ur inputs


Venky

Hi guys,
I have the same problem on Datastage 7.5 but I can't see any variable APT_ORACLE_NO_OPS to set "= 1"

Does it exists another kind of environment variable to set on Datastage 7.5?

Thanks a lot
Eug

Not all are listed "out of the box". Create it and see what happens.

Eleven years later - is that a DSXchange record?

Sadly, probably not. And you might want to check your date math routine.

LOL, burn.


Huge10: Make sure the Oracle client is properly installed on your hosts, and that they have the correct TNS entries for your setup.

The TNS entries seems to be right.
With SQLPLUS the connection is OK.

I'll try to create the variable APT_ORACLE_NO_OPS and see what happens.