Print Thread
Oracle 11g - Could not locate OCI dll
#37992 05/05/10 08:13 PM
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
D
dgsmith Offline OP
Member
OP Offline
Member
D
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
I have just installed the 11g client on a server with the 8.1 and 9.2 clients already installed. This server is used to run scheduled console apps, many of which have not been recompiled for years. They now give:

Initialization error
Could not locate OCI dll

OracleHomeKey: SOFTWARE\ORACLE\KEY_OraOdac11g_home1
OracleHomeDir: C:\app\david.g.smith\product\11.1.0\client_1

I know I can recompile them, or pass OCIDLL="d:\oracle\ora92\bin\oci.dll" on the command line. Is there another option, something that doesn't require modifying each of these jobs?

Thanks.


David Smith
Re: Oracle 11g - Could not locate OCI dll
dgsmith #37996 05/06/10 09:53 AM
Joined: Aug 1999
Posts: 22,172
Member
Offline
Member
Joined: Aug 1999
Posts: 22,172
Direct Oracle Access will use the Primary Oracle Home by default. This is the home that is listed first in the PATH environment variable. You can modify the PATH to change the Primary Oracle Home.


Marco Kalter
Allround Automations
Re: Oracle 11g - Could not locate OCI dll
Marco Kalter #38003 05/06/10 12:13 PM
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
D
dgsmith Offline OP
Member
OP Offline
Member
D
Joined: Oct 2000
Posts: 15
Wilmington, DE, USA
Thanks so much. That worked.


David Smith
Re: Oracle 11g - Could not locate OCI dll
dgsmith #47366 06/26/13 03:42 PM
Joined: Jun 2013
Posts: 1
K
Member
Offline
Member
K
Joined: Jun 2013
Posts: 1
Hello !! I had the same trouble.
Here is the solution:

1) Copy the OCI.DLL file from: C:\app\david.g.smith\product\11.1.0\client_1 to C:\app\david.g.smith\product\11.1.0\client_1\bin
2) Open PL/SQL Developer.
3) Close the connection window
4) Go to Tools -> Preferences
5) Click on Oracle -> Connections
6) Put your OracleHomePath into OracleHome
7) Put your OCI.DLL path on OCI library:
C:\app\david.g.smith\product\11.1.0\client_1\bin\oci.dll
8) Click on Force OCI7 mode on OCI8
9) Click Apply, Click Ok. Restart the PL/SQL Developer and try to connect.

It worked for me.

Good luck!!
grin


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.203s Queries: 15 (0.055s) Memory: 2.5062 MB (Peak: 3.0392 MB) Data Comp: Off Server Time: 2024-03-28 09:18:27 UTC
Valid HTML 5 and Valid CSS