PX unable to find an Oracle Instance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Thu Oct 14, 2004 12:48 pm
PX unable to find an Oracle Instance
Hi,
We are facing a problem with PX. We are able to write into the Oracle Enterprise Stage but we are unable to read from the table. But we can read successfully from a file and write into a table. We were unable to View the data from Oracle Enterprise Stage while reading. We were getting an error like
OraInstanceSet::setup() failed to find an oracle instance on node node1( the hostname is 'XXXXX.com').
Datastage is on XXXXX.com server. But oracle was set up on a different server. We do not have any problem with the Server jobs. We are facing it only in PX. Can any one help us with this issue.
Thanks,
We are facing a problem with PX. We are able to write into the Oracle Enterprise Stage but we are unable to read from the table. But we can read successfully from a file and write into a table. We were unable to View the data from Oracle Enterprise Stage while reading. We were getting an error like
OraInstanceSet::setup() failed to find an oracle instance on node node1( the hostname is 'XXXXX.com').
Datastage is on XXXXX.com server. But oracle was set up on a different server. We do not have any problem with the Server jobs. We are facing it only in PX. Can any one help us with this issue.
Thanks,
-
- Participant
- Posts: 7
- Joined: Thu Oct 14, 2004 12:48 pm
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
Re: PX unable to find an Oracle Instance
OraInstanceSet::setup() failed to find an oracle instance on node node1( the hostname is 'XXXXX.com').
First check the properties like target and connection in the designer and then check the config file.If still face the problem post it
First check the properties like target and connection in the designer and then check the config file.If still face the problem post it
Try Putting this variable in User-Defined Environment Variables in Datastage Administrator to true
APT_ORACLE_NO_OPS Default Value - True..
See if it works...
HTH
APT_ORACLE_NO_OPS Default Value - True..
See if it works...
HTH
anupam wrote:when i am using ORACI9 stage in server job then i am able to read the source system, but when i am using PX then i am getting error.
Please suggest