Error while executing job in Protected Project

venky · Post by **venky** » Mon May 29, 2006 7:48 am

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.

DSguru2B · Post by **DSguru2B** » Mon May 29, 2006 2:24 pm

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,

ray.wurlod · Post by **ray.wurlod** » Mon May 29, 2006 2:46 pm

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)?

venky · Post by **venky** » Tue May 30, 2006 6:25 am

Hi guys

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

Venky

huge10 · Post by **huge10** » Fri Oct 02, 2015 7:25 am

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

chulett · Post by **chulett** » Fri Oct 02, 2015 7:49 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Oct 02, 2015 4:46 pm

Eleven years later - is that a DSXchange record?

chulett · Post by **chulett** » Fri Oct 02, 2015 6:07 pm

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

PaulVL · Post by **PaulVL** » Mon Oct 05, 2015 8:53 am

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.

huge10 · Post by **huge10** » Wed Oct 21, 2015 10:48 am

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.