Oracle Enterprise Stage it will show some error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
hemanth12
Participant
Posts: 6
Joined: Tue Feb 01, 2011 11:45 pm

Oracle Enterprise Stage it will show some error

Post by hemanth12 »

Hi all,

I have the problem regarding oracle enterprise stage.it will not connected in datastage 8.0.1 is there any patches to install on our system are any configurations are there plz give me the information for how to connect on out windows system..

Thanks & Regards
Hemanth
Last edited by hemanth12 on Mon Feb 07, 2011 2:20 am, edited 1 time in total.
DATASTAGE DEVELOPER
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

Do you have have any more info than that?
An error message of some sort, or does it just shake its head and say "No!"?
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Re: Oracle Enterprise Stage

Post by jwiles »

Can you connect to the Oracle database from SQL*Plus on your windows server machine?
- james wiles


All generalizations are false, including this one - Mark Twain.
hemanth12
Participant
Posts: 6
Joined: Tue Feb 01, 2011 11:45 pm

Re: Oracle Enterprise Stage

Post by hemanth12 »

jwiles wrote:Can you connect to the Oracle database from SQL*Plus on your windows server machine?
Yes..

Is there any configurations to connect the oracle enterprise stage to processs the records...
In this ODBC stage is working fine but not working the oralce and DB2 plz give me how to process for that.is there any configuration or any patch files to install plz give me the step by step clarification...

Thanks in advance...
hemanth
DATASTAGE DEVELOPER
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

Instructions for configuring database access for DataStage are contained in the IBM Information Server Planning, Installation, and Configuration Guide. Additional information on using the Oracle stages is contained in the Connectivity Guide for Oracle Databases and Parallel Job Advanced Developer Guide. All three are included with Information Server.

Work with your Information Server admin and DBA to configure IS for Oracle connectivity. Keep in mind that you must configure IS 8.0.1 to use the 32-bit Oracle client libraries.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
hemanth12
Participant
Posts: 6
Joined: Tue Feb 01, 2011 11:45 pm

Oracle Enterprise Stage it will show some error

Post by hemanth12 »

ray.wurlod wrote:Computer says no ...
Hi ,

Please give me the response..

Error is


Oracle_Enterprise_0: Error when checking operator: Caught unknown exception during wrapDescribeOperator().

Regards
hemanth
DATASTAGE DEVELOPER
Post Reply