Search found 3 matches

by ykhan
Thu Jul 26, 2012 8:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error on Oracle connector stage
Replies: 20
Views: 15731

Issue resolved. We had to delete "NLS_DMU_USAGE" from v$nls_parameteres. Jobs run fine now
by ykhan
Wed Jul 25, 2012 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error on Oracle connector stage
Replies: 20
Views: 15731

We've also tried the same with ODBC stage and it works fine. We suspected the oracle client compatibility issue from Linux to AIX but the SQLPLUS works fine.
by ykhan
Wed Jul 25, 2012 9:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error on Oracle connector stage
Replies: 20
Views: 15731

We have encountered this error and contacted IBM too. We got a patch "patch_JR40722_cc-oracle_linux64_8500-8502" but the issue remained. When we checked with our ORACLE DBA, we were told that they upgraded the oracle server OS from AIX 5.3 to AIX 6.1 and added a DMU patch. We tested our jo...