Page 1 of 1
PX unable to find an Oracle Instance
Posted: Mon Feb 21, 2005 11:44 am
by lakshman_gk
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,
Posted: Mon Feb 21, 2005 5:42 pm
by xlnc
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
Posted: Tue Feb 22, 2005 9:11 am
by lakshman_gk
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
Posted: Tue Feb 22, 2005 9:26 am
by Sainath.Srinivasan
Can you check your config file for any nodes that are specific to Oracle and confirm that all their properties are valid.
Re: PX unable to find an Oracle Instance
Posted: Tue Feb 22, 2005 3:10 pm
by chalasaniamith
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
Posted: Tue May 10, 2005 2:20 am
by anupam
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.
Posted: Tue May 10, 2005 5:14 am
by Eric
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?
Posted: Tue May 10, 2005 7:00 am
by anupam
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.
Posted: Tue May 10, 2005 7:29 am
by anupam
yes, select privilage is given to all the mentioned tables.
Posted: Tue May 10, 2005 7:51 am
by anupam
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
Posted: Tue May 10, 2005 8:06 am
by raviyn
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