|
Could Not Locate OCI dll
|
Joined: Oct 1999
Posts: 3
Member
|
OP
Member
Joined: Oct 1999
Posts: 3 |
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
Samuel N. Jr. doa@samuel.eti.br
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Sep 1999
Posts: 11
Member
|
Member
Joined: Sep 1999
Posts: 11 |
Samuel, ist the c:\orant\bin drectory in your Path ??
Holger
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Oct 1999
Posts: 3
Member
|
OP
Member
Joined: Oct 1999
Posts: 3 |
Yes, the C:\ORANT\BIN is on PATH
Samuel N. Jr. doa@samuel.eti.br
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Oct 1999
Posts: 32 Sacramento, CA, USA
Member
|
Member
Joined: Oct 1999
Posts: 32 Sacramento, CA, USA |
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.
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
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
Marco Kalter Allround Automations
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Oct 1999
Posts: 3
Member
|
OP
Member
Joined: Oct 1999
Posts: 3 |
I migrate the old application to new DOA 3.3 and it works.
Thanks
Samuel N. Jr. doa@samuel.eti.br
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Nov 1999
Posts: 2 Peterborough, NH USA
Member
|
Member
Joined: Nov 1999
Posts: 2 Peterborough, NH USA |
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.
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Nov 1999
Posts: 2 Peterborough, NH USA
Member
|
Member
Joined: Nov 1999
Posts: 2 Peterborough, NH USA |
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.
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Sep 2002
Posts: 13
Member
|
Member
Joined: Sep 2002
Posts: 13 |
I have the same problem under Linux and Kylix 3 :-(
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
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
Marco Kalter Allround Automations
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Oct 2002
Posts: 1 Fairfax, VA, USA
Member
|
Member
Joined: Oct 2002
Posts: 1 Fairfax, VA, USA |
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.
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
It looks for libclntsh.so in the $ORACLE_HOME/lib directory.
------------------ Marco Kalter Allround Automations
Marco Kalter Allround Automations
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 2007
Posts: 4 Indonesia
Member
|
Member
Joined: Aug 2007
Posts: 4 Indonesia |
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...
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
Can you check if $ORACLE_HOME/lib/libclntsh.so exists and is accessible?
Marco Kalter Allround Automations
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 2007
Posts: 4 Indonesia
Member
|
Member
Joined: Aug 2007
Posts: 4 Indonesia |
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
|
|
|
Re: Could Not Locate OCI dll
|
Joined: Aug 1999
Posts: 22,221
Member
|
Member
Joined: Aug 1999
Posts: 22,221 |
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.
Marco Kalter Allround Automations
|
|
|
|
|
|