Could Not Locate Oci Dll Error
Contents |
Oracle SQL Server PRODUCTSDiscussion & Resources Backup Reporter Benchmark Factory Code Tester for Oracle SQL Navigator SQL Optimizer for IBM DB2 SQL Optimizer for Oracle SQL Optimizer for SQL Server SQL Optimizer for SAP ASE Spotlight on DB2 LUW Spotlight on Oracle Spotlight on SQL initialization error could not locate oci dll toad Server Spotlight on SAP ASE Toad Intelligence Central Toad Data Modeler Toad Data Point Toad Decision
Oci Dll Is Missing
Point Toad Extension for Eclipse Toad for Apache Hadoop Toad for IBM DB2 Toad for MySQL Toad for Oracle Toad for SQL Server
Oci Dll Is Missing From Your Computer Php
Toad for SAP Solutions Toad Mac Edition Home » Products » Toad for Oracle » Toad for Oracle Wiki » I get the error message, "Could not locate OCI DLL". Now what? I get the error message,
Cannot Load Oci Dll
"Could not locate OCI DLL". Now what? Toad for Oracle Community Join Overview Forum Blog Idea Pond Connections Debug Editor General Grid Import/Export Monitor MyToad Other Schema Browser Team Coding Utilities Wiki Media Toad Apps Toad for Oracle Videos Beta Beta Overview Beta Forum Members Support Contents Toad for Oracle Wiki Toad for Oracle - Wiki How To Key Resources Toad Features and FAQs Command Line Connect Data Grid Database Versions DBMS_Output Editor Explain Plan FastReports oci dll missing sqlplus General Getting Started GUI Installation and Configuration Acronyms used in Toad Avoiding the loss of 8.5 connection settings when upgrading to 9.1 Configuring an Oracle Database to have a 'self-cleaning' PLAN_TABLE Configuring TOAD for Multiple Users on One PC Customizing Toad to Taste Does Toad work with Citrix Terminal Server? How can I limit TOAD's object altering capabilities? How can i transfer all autocorrect substitutions from the old version (8.6.1) to a new one (9.0.1.8)? How do I upgrade to a new version of TOAD? How to Setup & Use Toad in a Secure Environment I get the error message, "Could not locate OCI DLL". Now what? INI File Installing and updating Toad Freeware The Best Way to Save/Import Toad Settings Toolbar Legends, Toad for Oracle 11.6 What is Code Site Client Tools and Raize Development Tools? Where can I get a copy of the TOAD help? Why after a recent upgrade attempt is Toad now giving access violation read errors? Why can't I customize my toolbar? The "Customize" item on the Tools menu is grayed out, and when I right-click over the toolbar, there is no "Customize" menu item like there used to be. Why can't I find my favorite window in my menu or toolbars anymore? Why does Toad not run on Windows Vista unless run as administrator? Why doesn't Toad 9.5 install where I
Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and delete oci dll policies of this site About Us Learn more about Stack Overflow the cannot find nt oracle server dll oci dll company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges unable to delete oci dll Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute: Sign up Here's how it works: Anybody http://www.toadworld.com/products/toad-for-oracle/w/toad_for_oracle_wiki/177.i-get-the-error-message-could-not-locate-oci-dll-now-what can ask a question Anybody can answer The best answers are voted up and rise to the top Initialization error while trying to connect to Oracle using SQLDeveloper up vote 2 down vote favorite I've installed Oracle 11.2.0 and Allround Automations' SQLDeveloper on Windows 7 64-bit. When I run SQLDeveloper and and try to connect to Oracle, I get the below error: http://serverfault.com/questions/249666/initialization-error-while-trying-to-connect-to-oracle-using-sqldeveloper Initialization error Could not load "C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll" OCIDLL forced to C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll LoadLibrary(C:\app\MyComp\product\11.2.0\dbhome_1\bin\oci.dll) returned 0 What can be the problem? windows-7 64-bit oracle-11g plsql sqldeveloper share|improve this question edited Jul 13 '11 at 23:34 Andrew Russell 1135 asked Mar 20 '11 at 19:11 Gali migrated from stackoverflow.com Mar 21 '11 at 1:29 This question came from our site for professional and enthusiast programmers. add a comment| 2 Answers 2 active oldest votes up vote 1 down vote This happens because PL/SQL Developer is incapable of loading 64-bit version of oci.dll file. To fix this, download the 32-bit version of Oracle Instant Client, extract it to a directory such as \instant_client. Next, configure PL/SQL Developer to use this version by clicking on Tool menus -> Preferences. Under Oracle Home, point to the location where you had extracted Instant client (\instant_client, in this case) and under location of OCI Library, point to the oci.dll file present in location where you had extracted Instant client ( \instant_client\oci.dll). Restart PL/SQL Developer and you should be able to connect now. share|improve this answer answered Mar 21 '11 at 8:56 Sathya
you are using 10g client with PL/SQL developer, you may encounter the message "Initialization error: Could not locate OCI dll" when launching PL/SQL Developer. It does not happen with the 8i client so I already suspected that it must be with the 10g client that I recently installed. Luckily, I found this thread https://kwatog.com/blog/oracle/could-not-locate-oci-dll-error/ in Oracle OTN forum and the solution seems to be easy. All I have to do http://sathyabh.at/2011/03/21/fix-initialization-error-loadlibrary-oci-dll-returned-0-while-trying-to-connect-to-oracle-using-plsql-developer/ is copy a whole bunch of files from the ORAHOME folder to ORAHOMEbin. It seems like PL/SQL Developer is hardwired to find the files under the bin folder. It did the trick and my sql editor is now working. I hope it fixes yours too. Here's the screenshot of the files I copied. Take note that I copied them instead of just moving so as not oci dll to break anything. Posted in: Oracle ⋅ Tagged: error, oci dll, pl/sql developer 16 Thoughts on “Could not locate OCI dll Error” Eric on October 7, 2009 at 7:13 am said: can you post the image or list what files you copied. The image is not showing. Thanks! Log in to Reply Charlie on November 4, 2009 at 7:08 am said: I've got the same problem, but I can't see your screen shot. Could you email it to me? Log in to could not locate Reply Marco on November 25, 2009 at 12:52 am said: Same problem here. I have no files in my ORAHOME folder, only subfolders. So I don't know what to copy. Can you please publish the screenshot or mail it to me? Log in to Reply kwatog on December 2, 2009 at 7:04 am said: sorry guys,! I have updated the post to include the screenshot. Log in to Reply Frank Quednau on December 14, 2009 at 8:11 am said: That's indeed the answer. Which is kinda horrible. I have some simple Oracle client for 11g installed which already has a bin directory…alas, it contains stuff related to mts etc. What a mess… Log in to Reply Bhageerath on January 20, 2010 at 10:42 pm said: Thanks man.Its working. Log in to Reply Ravi Bhatt on August 11, 2010 at 5:45 am said: Hi, I encountered the same issue with Oracle 11g when I was trying to login using PL/SQL Developer. I came across some steps which are worth sharing. And its clean means no ddl copying is involved. Steps: 1) Login to PL/SQL Developer 2) Go to Tools 3) Click Preferences 4) Click Connection in preferences pop-up 5) Select "Orahome90" under Oracle Home dropdown 6) Apply the changes 7)Close the PL/SQL shell 8) Login again to PL/SQL Developer And the error is no more. Hope this post is worth to all the people encountering the same problem. Thanks, Ravi Bhatt. Log in to Reply Mut
Developer Quick post: I was trying to connect to a 64-bit Oracle database using PL/SQL Developer. Despite ORACLE_HOME being set the right values and oci.dll available, PL/SQL Developer could not connect to the database. Further probing indicated that the Oracle installation was a 64-bit one, and PL/SQL Developer is incapable of loading 64-bit version of oci.dll file. To fix this, download the 32-bit version of Oracle Instant Client, extract it to a directory such as \instant_client. Next, configure PL/SQL Developer to use this version by clicking on Tool menus -> Preferences. Under Oracle Home, point to the location where you had extracted Instant client (\instant_client, in this case) and under location of OCI Library, point to the oci.dll file present in location where you had extracted Instant client ( \instant_client\oci.dll). Restart PL/SQL Developer and you should be able to connect now. Share this:TwitterFacebookPocketMoreTumblrPrintGoogleEmailRedditLike this:Like Loading... Related posts: Making Oracle Forms Use JRE instead of Jinitiator Download Toad for Oracle for Free Exporting and Importing An Oracle database from one schema/user to Another schema/user easily PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle The Power and Simplicity of Oracle Hierarchical Queries Comments ( 13 )March 21, 2011ReplySathyaBlogged: Fix Initialization Error: LoadLibrary oci.dll returned 0 while trying to connect to… http://goo.gl/fb/N3pGL September 30, 2011ReplyTim GbadeboThis is a great finding and it so helpful. Many thanks. December 6, 2011ReplypremIt was a nice fix and nice thing to learn. April 25, 2012ReplyVivekThis is really cool and quick. Thanks for this. December 21, 2012ReplyvinuWorking!! :D August 21, 2013ReplyVivekThe instructions are good... the its working for me too. January 15, 2015ReplyRenataExcellent! Helped me a lot! Thanks! May 8, 2015ReplyPankaj GuptaGreat it worked. Thanks a lot. Pankaj May 23, 2015ReplyKarthick VRYou are a genius dude. Its working. Thanks a lot. July 3, 2015ReplyNiladrigreat it worked for me thanks a lot January 19, 2016ReplyBharath KHHi, Its not working for me. I made settings as below : 1.Oracle Home :C:\instantclient_11_2 2. OCI library : C:\instantclient_11_2\oci.dll It is giving error as : ORA-12170: TNS:Connect timeout occurred Any environment variable needs to be set ? Regards, Bharath