Could Not Locate OCI dll

[SAMUCA]

I migrate from Oracle 8.0.2 to 8.1.5 on NT (both client and server) and I received "Could Not Locate OCI dll" when I tried connect.

The OCI.DLL is in C:\ORANT\BIN.

Help !

------------------
Samuel N. Jr.
doa@samuel.eti.br

 

[holger.sachs]

Samuel,
ist the c:\orant\bin drectory in your Path ??

Holger

 

[SAMUCA]

Yes, the C:\ORANT\BIN is on PATH

 

[AndreyB]

Sometimes the path variable is screwed up by unexisting directories or wrong syntax and if such thing was found by system somewhere in the path the rest of path variable just ignored. Check your path carefully for such unexisting directories.

 

[Marco Kalter]

The c:\orant\bin directory does not have to be in the PATH environment variable. If you are using version 3.3 then there should be some additional diagnostic information displayed with the error message that could be helpful. If you are using 3.2 or earlier then you should upgrade to 3.3, because this is the first version that is compatible with Net8 8.1.x.

------------------
Marco Kalter
Allround Automations

 

[SAMUCA]

I migrate the old application to new DOA 3.3 and it works.

Thanks

 

[rgacote]

Sent precisely this question to support last night (guess I should have looked here first).

After upgrading to 8.1.5, I found that my old Home (d:\orant) was still floating around the Registry and PL/SQL Developer was managing to find it.

Bringing up regedit, finding each and every instance of the old Oracle Home reference and changing it to the new reference let everything start working.

 

[rgacote]

Sent precisely this question to support last night (guess I should have looked here first).

After upgrading to 8.1.5, I found that my old Home (d:\orant) was still floating around the Registry and PL/SQL Developer was managing to find it.

Bringing up regedit, finding each and every instance of the old Oracle Home reference and changing it to the new reference let everything start working.

 

[tomaten]

I have the same problem under Linux and Kylix 3 :-(

 

[Marco Kalter]

Have you defined the ORACLE_HOME environment variable? Make sure that is points to the correct Oracle home directory, and that $ORACLE_HOME/bin is included in the PATH environment variable.

------------------
Marco Kalter
Allround Automations

 

[dkeller22]

I have the same problem with Kylix3 and DOA, it can't find OCI dll. Based on the previous post my env. is correct--What file is it looking for? oci.dll is a MS thing the file names are different under Linux. I just reinstalled OCI to make sure I'm not having one of those Oracle installer issues.

 

[Marco Kalter]

It looks for libclntsh.so in the $ORACLE_HOME/lib directory.

------------------
Marco Kalter
Allround Automations

 

[g0053_82]

i try to use DOA 4.0.3 with kylix 3... but it stuck...
it also have the same error which is "initialization error could not locate OCI dll"

can anyone help me...

 

[Marco Kalter]

Can you check if $ORACLE_HOME/lib/libclntsh.so exists and is accessible?

 

[g0053_82]

i know that the file is in /u01/app/oracle/product/10.2.0/db_1/lib but when i use
cd $ORACLE_HOME/lib
it will go to /lib

i guess the matter is $ORACLE_HOME is not set properly...
i've done the installation just like what it said in http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html

can you help telling me how to set $ORACLE_HOME

Thanks...

Adi

 

[Marco Kalter]

In your .profile or .bash_profile, add the following statements:

ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME

Log off and log on again to make this effective.