Pl Sql Initialization Error Could Not Load Oci.dll
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 the company Business Learn more about hiring developers or posting ads with us Server Fault Questions Tags Users Badges 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 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: 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 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 a
back to return to the previous page. Enter your Username and Password http://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=49658 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.007 seconds in which 0.001 seconds were spent on a total of 3 queries. Zlib compression disabled.Powered by UBB.threads™ PHP Forum Software 7.4.1p2
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 https://community.oracle.com/thread/2331852 message. Please type your message and try again. More discussions in Instant Client All http://oracle.ittoolbox.com/groups/technical-functional/oracle-db-installs-l/initialization-error-could-not-load-coracleproduct1020db_1binocidll-3287930 PlacesOracle CommunityArchived ForumsOracle Database Archived ForumsInstant Client This discussion is archived 3 Replies Latest reply on Feb 6, 2012 12:11 PM by Nikolay Ivankin Help!my application can not load oci.dll 909324 Jan 6, 2012 7:22 AM i have a server with windows 2003 enterprise sp2, oracle 10g was installed on it.now i want to run pl sql a .net application,but it's not working,cause oci.dll can not be loaded. then i installed PL/SQL and instant client 11g. but still not working. the error is :"initialization is error, can not load oci.dll.....returned 0". also,i wroted a small application to load oci with win32 api(LoadLibrary) and returned 0 too. I'm sure there are no 32bit,64bit things. from os to application,32bit was checked. and i changed server but same os pl sql initialization ,same oracle, after application and instant client installed,same problems got. so i'm think about is there any conflicts when oracle 10g and odac/instant client work together I have the same question Show 0 Likes(0) 3811Views Tags: none (add) 10gContent tagged with 10g, 2003Content tagged with 2003, clientContent tagged with client, instantContent tagged with instant, odacContent tagged with odac, plContent tagged with pl, sqlContent tagged with sql This content has been marked as final. Show 3 replies 1. Re: Help!my application can not load oci.dll Laurenz Albe Feb 2, 2012 10:56 AM (in response to 909324) If you have Oracle 10 installed on a Windows computer, you have oci.dll. If "oci.dll can not be loaded", the problem is not a lack of oci.dll. The first thing you should do is uninstall Instant Client and anything else you installed to fix the problem (I don't know what you mean with "install PL/SQL"). Then check if oci.dll can be loaded, e.g. by starting sqlplus and connecting to a database. If that works, oci.dll is fine. If your program cannot load oci.dll, something in your setup has a problem. Maybe it cannot find oci.dll and you have to tell it where to look. Yours, Laurenz Albe Like Show 0 Likes
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries VoIP_News Inside-ERP MacProTX Inside-CRM I_am_the_dragon maxwellarnold Michael Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Iqbalyk Adrian_Grigoriu bluesguyAZ59 numbersguyPA COMPANIES Wave Direct Avaya Pivotal CRM SendGrid View All Topics View All Members View All Companies Toolbox for IT Topics Oracle Groups Ask a New Question Oracle Database Installations For discussion on Oracle Database Installations , please visit the Oracle Database group. More Oracle Groups Your account is ready. You're now being signed in. Solve problems - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Initialization error - Could not load 'C:\oracle\product\10.2.0\db 1\bin\oci.dll' vanamby asked Feb 5, 2010 | Replies (7) Hi, Toad can not connect to oracle. OS: windows vista 64bit Oracle 10204_vista_w2k8_x64_production_db When trying to coonect to oracle, I got error: Initialization error Could not load "C:\oracle\product\10.2.0\db_1\bin\oci.dll" Anybody can help? Really appreciate! Balu. = Join this group 7Replies Best Answer 0 Mark this reply as the best answer?(Choose carefu