Initialization error Could not find OCI.dll

[Hugh.Jones]

I wrote and tested some Dataloader stuff using the Oracle 10g client. Now I come to deploy, I find that the target machine is Instant Client 11.1.

I know this is not exactly an AA issue, but could you advise ? Oci.dll is clearly not present in its usual bin folder.

It is not an option to uninstall 11 instant.

Cheers
Hugh

 

[Hugh.Jones]

Sorry - I should have said - this is a windoze client

 

[Marco Kalter]

Have you set the ORACLE_HOME variable? It needs to point to the instant client directory.

 

[Hugh.Jones]

IF I set the ORACLE_HOME to point to the 10g client, or the 11 instant I get the same message from InitOCI

---------------------------
Debugger Exception Notification
---------------------------
Project OraIBLoader.exe raised exception class Exception with message 'Initialization error
Could not locate OCI dll

OracleHomeKey: SOFTWARE\ORACLE\KEY_OraOdac11g_home1
OracleHomeDir: D:\app\hugh.jones\product\11.1.0\client_1'

 

[Hugh.Jones]

I am happy - I passed OCIDLL="\oci.dll" on the commandline and that has worked.