Oracle_Enterprise_Stage

[srekant]

I am getting the following eroor when trying to run the job which have Oracle_Enterprise stage

Code: Select all

Oracle_Enterprise_1: Can't find version in v$version
 [orautils.C:587]

Oracle_Enterprise_1: GenericQuery:esqlErrorHandler
Fetch failed for: GenericStmt_3
query is: SELECT banner FROM V$VERSION
sqlcode is: -3106
esql complaint: ORA-03106: fatal two-task communication protocol error
[genericquery.C:92[/b]

[roy]

Hi,
What steps did you go thru regarding the Oracle configuration on the DS machine?

[T42]

Ensure that your Datastage paths are defined before your Oracle paths. This is true for all database setups within "dsenv" file.