PX unable to find an Oracle Instance

lakshman_gk · Post by **lakshman_gk** » Mon Feb 21, 2005 11:44 am

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,

xlnc · Post by **xlnc** » Mon Feb 21, 2005 5:42 pm

Try to do a view data, then try to import the table definition from the ODBC stage, probabaly we might get some more information by doing this....let me know

lakshman_gk · Post by **lakshman_gk** » Tue Feb 22, 2005 9:11 am

Hi

Thanks for your reply. I don't have any problem in importing table definitions. Since there is no ODBC stage in PX, can you please clarify me what exactly you are expecting me to do.

Thanks,
Lakshman

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Feb 22, 2005 9:26 am

Can you check your config file for any nodes that are specific to Oracle and confirm that all their properties are valid.

chalasaniamith · Post by **chalasaniamith** » Tue Feb 22, 2005 3:10 pm

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

anupam · Post by **anupam** » Tue May 10, 2005 2:20 am

Hello All,

I am also getting the similar kind of error. Please let me know the steps which i need to perform to progress.

Any kind of information is welcome.

Eric · Post by **Eric** » Tue May 10, 2005 5:14 am

Just to be clear - Can you write to an Oracle Table using the PX Stage?

Or are you writing to Oracle using Server and trying to Read the data using PX?

anupam · Post by **anupam** » Tue May 10, 2005 7:00 am

Hi,

When i am reading from one source system which is Oracle using Oracle Enterprise stage then I am getting this error.

The Job is unable to read the source system.

anupam · Post by **anupam** » Tue May 10, 2005 7:29 am

yes, select privilage is given to all the mentioned tables.

anupam · Post by **anupam** » Tue May 10, 2005 7:51 am

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

raviyn · Post by **raviyn** » Tue May 10, 2005 8:06 am

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

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

DSXchange

PX unable to find an Oracle Instance

PX unable to find an Oracle Instance

Re: PX unable to find an Oracle Instance