DSXchange

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

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.