Pl Sql Developer Error Oci.dll
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. T
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 JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Database Installation All PlacesDatabaseGeneral Database DiscussionsDatabase Installation This discussion is archived 7 Replies Latest reply on Jun 26, 2013 4:24 PM by VijayanandSettin Could not locate OCI dll 569278 https://sathyabh.at/2011/03/21/fix-initialization-error-loadlibrary-oci-dll-returned-0-while-trying-to-connect-to-oracle-using-plsql-developer/ Feb 21, 2008 10:19 AM Hi, I have OracleEx 10g and Odp.NET 11g (ODTwithODAC1110620.exe) installed on my machine, now when I try to install OUnit11 I got the error as title. I have in my enviroment variables "PATH" the following: C:\app\ahmad\product\11.1.0\client_1; (this the path for odp.net 11g) C:\app\ahmad\product\11.1.0\client_1\bin; (this the path for odp.net11g) C:\oraclexe\app\oracle\product\10.2.0\server\bin; https://community.oracle.com/thread/622900 (this for OracleEx 10g) is it correct that the existence of two Oracle Home the envrioment variables causes this problem? if not, then how to fix the error I am getting? Thanx, 91446Views Tags: none (add) This content has been marked as final. Show 7 replies 1. Re: Could not locate OCI dll 569278 Feb 21, 2008 10:27 AM (in response to 569278) Okay, I found this in the forums: oci.dll not found when installing 11g client and using PL/SQL I don't know if it is apply in my case because I right click on "C:\app" but there is nothing called "authenticated users" in the users names! so should I add it? Like Show 0 Likes(0) Actions 2. Re: Could not locate OCI dll 569278 Feb 21, 2008 5:03 PM (in response to 569278) Any idea? Like Show 0 Likes(0) Actions 3. Re: Could not locate OCI dll 629590 Mar 20, 2008 2:08 PM (in response to 569278) Guys, I installed Oracl
This Site Careers Other all forums Forum: Oracle/OAS Oracle 11g in windows 7 https://coderanch.com/t/604247/Oracle-OAS/Oracle-windows rahul deo Greenhorn Posts: 10 posted 3 years ago Hi I have installed Oracle 11g in my system. While connecting through Pl/Sql developer , I am getting error message as " Initialization error - oci.dll - returned 0". I am using Windows 7. Thanks pl sql Md Haidar Ali Khan Greenhorn Posts: 12 posted 3 years ago Guys, I installed Oracle 11g client because of the reported fix of System.Transactions issue known in 10g. I use PL/SQL developer, and it told me "Initialization error: Could not locate OCI dll", though pl sql developer the registry entry and ORAHOME folder it showed were Ok. It seems like PL/SQL developer was looking for OCI.dll not in the reported ORAHOME folder but in ORAHOME\bin folder. After copying all files (luckily, they are quite few) from ORAHOME root to bin PL/SQL developer began to work correctly. Post Reply Bookmark Topic Watch Topic New Topic Similar Threads Forms + VB macro communication problem with Java application deployed in Oralce Weblogic 11g server window 7 64bit using database problem ORacle 11gXE 32 bit installation issue with Windows 7 x64? Free Oracle development tool java.lang.UnsatisfiedLinkError: \bin\ocijdbc11.dll: %1 is not a valid Win32 application All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter Contact Us | advertise | mobile view | Powered by JForum | Copyright © 1998-2016 Paul Wheaton