Oracle OCI8 Error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
catera0907
Premium Member
Premium Member
Posts: 9
Joined: Sun Jul 24, 2005 10:26 am

Oracle OCI8 Error

Post by catera0907 »

Hello

We just had DataStage Installed on Unix,
Oracle OCI9 stage is working, but when i try to Import metadata using ORAOCI8, it says "unable to intialize plug-in". can anyone tell me if i miss something.

Thanks
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

DS can only point to one version of Oracle sqlnet. Your OCI9 stage works because it's probably point to Oracle 9 client (look at the ORACLE_HOME variable in the dsenv file). Oracle 9 client works with 8, 9, and 10, so you have no worries unless you also need to point to 7, which is no longer supported by Oracle.

Just use your OCI9 stages to pointing to Oracle 8 databases, it works just fine. DO NOT WORRY about using the OCI8 plugin, not because it's unnecessary but because you can't. :wink:
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply