error in oci stage

[kiran_418]

hi
iam gettin the following error in oci.

ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found.

Can anyone help me out of it
thanks

[davidnemirovsky]

This idea might be a bit like using sledge hammer for a nail but it sounds like something has corrupted on the server.

Re-installing Oracle, then if no luck Re-installing Windows, then Oracle.

Do you have the capacity/security to do this?

[Precious]

Do you have the Oracle client installed on the DataStage Server?

hi
iam gettin the following error in oci.

ds_loadlibrary: Win32 error in LoadLibrary of oraoci9.dll - The specified module could not be found.

Can anyone help me out of it
thanks

[ds_developer]

I suspect that you are logging in to DataStage with a username that is not an Administrator. If so, you will need to give this user rights to the location of this file.

John

[kiran_418]

i got it done. The oracle was corrupted. I re installed it.
Thanks

[Ian]

Had the same error, but with Oracle 8 OCI.

Acutually found it was registry settings that were causing the problem, not a "corruption" of Oracle.

Did you by any chance install other versions of Oracle, or install Oracle to a different directory at some point? My problem was caused by wanting to use an older version of the client software (8.1.7), than what we had (9.2)

Anyway - change the following registry settings and you will be fine.

Under Oracle
- ORACLE_GROUP_NAME from Orahome92 to Orahome81
- ORACLE_HOME from E:|\oracle\ora92 to E:\oracle\ora81
- ORACLE_HOME_NAME from Orahome92 to Orahome81
and under ORACLE-> ALL_HOMES
- DEFAULT_HOME from Orahome92 to OraHome81