Home > oci dll > could not locate oci dll error

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

 

Related content

cannot find oci dll oci.dll in toad error

Cannot Find Oci Dll Oci dll In Toad Error table id toc tbody tr td div id toctitle Contents div ul li a href Toad Error Cannot Load Oci Dll a li li a href Cannot Load Oci Dll Oci dll Sql Navigator a li li a href Oci dll Download a li li a href Oci dll Could Not Be Loaded Windows a li ul td tr tbody table p NoSQL Oracle SQL Server PRODUCTSToad-family Communities Benchmark Factory Code Tester for Oracle SQL Navigator SQL Optimizer Spotlight Toad Intelligence Central Toad Data Modeler Toad Data Point relatedl Toad Extension

initialization error could not locate oci dll in toad

Initialization Error Could Not Locate Oci Dll In Toad table id toc tbody tr td div id toctitle Contents div ul li a href Load Library Oci dll Returned a li li a href Oci dll Could Not Be Loaded Windows a li li a href Could Not Locate Oci Dll Toad a li ul td tr tbody table p Start here for a quick overview of the site relatedl Help Center Detailed answers to any questions you cannot load oci dll toad might have Meta Discuss the workings and policies of this p h id Load Library Oci dll

initialization error could not locate oci dll

Initialization Error Could Not Locate Oci Dll table id toc tbody tr td div id toctitle Contents div ul li a href Oci dll Download a li li a href Oracle Client Downloads a li ul td tr tbody table p back to return to the previous page Enter your Username and Password p h id Oci dll Download p to log in If you have not yet registered you can register here Username Password Have you forgotten your login information Mark all read Contact Us middot middot Top Generated in seconds in which seconds were spent on a total

initialization error could not locate oci dll plsql

Initialization Error Could Not Locate Oci Dll Plsql table id toc tbody tr td div id toctitle Contents div ul li a href Initialization Error Could Not Locate Oci Dll Toad a li li a href Pl Sql Developer Initialization Error Sql Net Not Properly Installed a li li a href Oci dll Download a li li a href Oci dll Is Missing From Your Computer Windows a li ul td tr tbody table p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will not work correctly

initialization error could not locate oci dll pl sql

Initialization Error Could Not Locate Oci Dll Pl Sql table id toc tbody tr td div id toctitle Contents div ul li a href Oracle Client Downloads a li li a href Oci dll Download a li ul td tr tbody table p Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies relatedl of this site About Us Learn more about Stack Overflow could not locate oci dll toad the company Business Learn more about hiring developers or posting ads with us Server Fault

oci dll error toad

Oci Dll Error Toad table id toc tbody tr td div id toctitle Contents div ul li a href Oci Dll Could Not Be Loaded Powerbuilder a li li a href Oci dll Could Not Be Loaded Windows a li li a href Cannot Find Oci Dll Primavera a li ul td tr tbody table p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will relatedl not work correctly without it enabled Please turn cannot load oci dll toad bit JavaScript back on and reload this page

oci dll initialization error

Oci Dll Initialization Error table id toc tbody tr td div id toctitle Contents div ul li a href Pl Sql Developer Initialization Error Sql Net Not Properly Installed a li li a href Initialization Error Could Not Locate Oci Dll Toad a li li a href Oracle Library Oci dll Could Not Be Loaded a li ul td tr tbody table p Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of relatedl this site About Us Learn more about Stack Overflow the

oci dll error in toad

Oci Dll Error In Toad table id toc tbody tr td div id toctitle Contents div ul li a href Cannot Load Oci Dll Oci dll Sql Navigator a li li a href Could Not Load Oci dll Pl Sql Developer a li li a href Oci dll Is Missing From Your Computer a li ul td tr tbody table p p p CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError You don't have JavaScript enabled This tool uses JavaScript and much of it will not work correctly without it enabled Please turn relatedl JavaScript back on and reload this

oracle oci.dll error

Oracle Oci dll Error table id toc tbody tr td div id toctitle Contents div ul li a href Oci Dll Could Not Be Loaded Powerbuilder a li li a href Oci dll Download a li li a href Could Not Load Oci dll Pl Sql Developer a li ul td tr tbody table p here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and relatedl policies of this site About Us Learn more about Stack cannot find oci dll oci dll toad for oracle Overflow the

pl sql developer initialization error could not load oci dll

Pl Sql Developer Initialization Error Could Not Load Oci Dll table id toc tbody tr td div id toctitle Contents div ul li a href Load Library Oci dll Returned a li li a href Pl Sql Developer Initialization Error Sql Net Not Properly Installed a li li a href Could Not Locate Oci Dll Oracle g a li ul td tr tbody table p Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies relatedl of this site About Us Learn more about Stack