Not able to connect Oracle 11g through 7.5 PX Jobs

saraswati · Post by **saraswati** » Thu Mar 19, 2009 5:34 am

Hi ALL,

I am not able to connect Oracle 11g through Datastage 7.5 PX Jobs, though I am able to do so using Server Jobs.

Please let me know if any settings need to be changed due to this.

I am not able to view data through the Oracle Enterprise Stage when I am doing so.

regards,
Saraswati

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 19, 2009 5:38 am

Can you provide more information on what you are trying to view and what message you get.

saraswati · Post by **saraswati** » Thu Mar 19, 2009 6:00 am

I am using simple select like, SELECT 'SARASWATI' A FROM DUAL.
Through server Job I am getting 'SARASWATI' after doing a View Data.

Through Parallel Job, I am getting this error:
"No rows were returned from the View Data server command.
Would you like to view the command's output?"

Even if you do an OK, there is nothing in the Command Output.

As mentioned previously the database here is on Oracle 11g.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 19, 2009 7:14 am

Was it working fine before (maybe with different version of oracle)?

Have you checked the PX installation steps for Oracle?

saraswati · Post by **saraswati** » Thu Mar 19, 2009 7:24 am

Yes... it is working fine with Oracle 10g... but only with Oracle 11g it is giving this error.

Any help??

Mike · Post by **Mike** » Thu Mar 19, 2009 7:30 am

Is Oracle 11g supported in version 7.5? Check with your official support provider. Since Oracle 11g came out after DS 7.5, I wouldn't be too surprised if it wasn't completely supported.

Mike

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Mar 19, 2009 11:03 am

You must be able to use old (10) client to access 11.

itroom305 · Post by **itroom305** » Wed Apr 01, 2009 9:48 am

IBM said only version 8.1 support 11g. not even 8.0...

chulett · Post by **chulett** » Wed Apr 01, 2009 10:21 am

Sure, "officially", but I would still think that you could be successful using an older client to connect to it. Worked well with 9i to 10g, for example.

Aquilis · Post by **Aquilis** » Wed Apr 01, 2009 11:21 am

Which version of 7.5 series you're using, to connect to 11g.
What I know is Only after 7.5.3 V series supports 11g because we are using 7.5.3 to connect to 11g.

binta.d.patel@accenture.c · Tue Apr 07, 2009 3:26 pm

We are on DataStage 7.5.1a and we were told that we had to upgrade to 7.5.3 in order to access Oracle 11g. Even though 7.5.3 is able to connect to 11g database, officially, DataStage says they only support version 8.1 and higher when running against 11g.