Page 1 of 1
error in oci stage
Posted: Thu May 12, 2005 4:53 pm
by 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
Posted: Thu May 12, 2005 7:31 pm
by 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?
Re: error in oci stage
Posted: Fri May 13, 2005 3:04 am
by Precious
Do you have the Oracle client installed on the DataStage Server?
kiran_418 wrote: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
Posted: Fri May 13, 2005 7:20 am
by 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
Posted: Fri May 13, 2005 12:09 pm
by kiran_418
i got it done. The oracle was corrupted. I re installed it.
Thanks
Posted: Wed Jun 08, 2005 5:49 pm
by 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