oci.dll load error

[loukoum82]

Initialization error
Could not load "C:\oracle\ora10g\bin\oci.dll"

OracleHomeKey : SOFTWARE\ORACLE\KEY_OraDb10g_home1
OracleHomeDir: C:\oracle\ora10g
Found : oci.dll
Using: C:\oracle\ora10g\bin\oci.dll
LoadLibrary(C:\oracle\ora10g\bin\oci.dll) returned 0

That's what I have when i try to connect to Oracle 10g 64 bit on windows server 2003 with the DOA component.
What's the problem ? Any Idea ?

 

[HotSpot]

You must use the Oracle client in 32 bits version.
I have the same error if i use the 64bits version.
The Client (32 bits)work well with the server (64 bits)

 

[loukoum82]

Thanks, but how can install it ?

 

[HotSpot]

One way is to download the 32bits client from Oracle.
You install this version on another home or you desinstall the 64bits clients from the server and install the 32 bits client on the server.

 

[loukoum82]

gracias. I try this

 

[loukoum82]

I tried, and now i have this :
ORA-12557: TNSrotocol adapter not loadable
???

 

[loukoum82]

Help!

 

[Marco Kalter]

This is what the error messages guide says:

ORA-12557: TNSrotocol adapter not loadable

Cause: On some platforms (such as OS/2) protocol adapters are loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.

Action: For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.

It seems to me that either the client is not installed correctly, or there is an issue with the PATH, or perhaps the tnsnames.ora file contains a wrong protocol.

 

[loukoum82]

problem is I have installed the Client Win32 version in an other folder than the Server X64 version to resolve the compatibility problem of DOA and I have put the client path into the PATH var before the server path, I found protocol list but apparently it's a problem in the PATH var because client path is first.
( sorry for my english )