Initialization Error Could Not Locate Oci Dll Pl Sql
Contents |
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 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 initialization error could not locate oci dll toad Questions Tags Users Badges Unanswered Ask Question _ Server Fault is a question and answer site for system and network administrators. Join load library oci.dll returned 0 them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Initialization error while trying to pl sql developer initialization error sql net not properly installed 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: 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
Oracle Client Downloads
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 2471522 add a comment| up vote 0 down vote I had a similar problem and Ihad to specify the complete file path of oci.dll alongwith the actual oci.dll filename. share|improve this answer answered Jun 4 '14 at 23:01 user223857 1 could you write instructions - how and where did you do it. I have /instantclient folder in the PATH variable.. the oci.dll is in it –Boppity Bo
back to return to the previous page. Enter your Username and Password http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=37992 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 · · Top Generated in 0.010 seconds in which 0.002 seconds were spent on a total of 3 queries. Zlib compression disabled.Powered by UBB.threads™ PHP Forum Software 7.4.1p2
Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers https://coderanch.com/t/604247/Oracle-OAS/Oracle-windows Other all forums Forum: Oracle/OAS Oracle 11g in windows https://kwatog.com/blog/oracle/could-not-locate-oci-dll-error/ 7 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 - oci dll returned 0". I am using Windows 7. Thanks 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 Could not locate OCI dll", though 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
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 in Oracle OTN forum and the solution seems to be easy. All I have to do 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 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! 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? 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? kwatog on December 2, 2009 at 7:04 am said: sorry guys,! I have updated the post to include the screenshot. 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… Bhageerath on January 20, 2010 at 10:42 pm said: Thanks man.Its working. Ravi Bhatt on August 11, 2010 at 5:45 am said: Hi, I encounte