Initialization Error Oci Dll
Contents |
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
Initialization Error Could Not Load Oci.dll In Pl Sql Developer
connect to the database. Further probing indicated that the Oracle installation was load library oci.dll returned 0 a 64-bit one, and PL/SQL Developer is incapable of loading 64-bit version of oci.dll file. To fix this,
Initialization Error Could Not Locate Oci Dll Toad
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 pl sql developer initialization error sql net not properly installed -> 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 oracle client downloads 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
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.008 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
FAQ Contact Us Frequently Asked Questions: Which version should I use, 32bit or 64bit? 32bit programs need to use the 32bit Oracle Client. 64bit programs need to use the 64bit Oracle Client. Use the version that matches the Oracle Client that you have installed. The 64bit version can access more memory http://www.benthicsoftware.com/faq.html than the 32bit version, but beyond that there are no differences. What Oracle Client versions are supported? It's important to use the version that works with your Oracle Server. In general this means that you should use an Oracle Client version that is equal to or higher than the highest Oracle Server version that you use. Newer versions of our products use the Oracle Unicode Client calls by default and so require clients that support these calls. If you need initialization error to use an older Oracle Client you can uncheck the "Use Uncode Oracle Client Calls" option on the login options window. In general we recommend the 11.2 Oracle Client or higher as Oracle fixed a problem described in the next question. Why am I getting error ORA-12154 when I try to login to Oracle on my 64bit Windows Operating System? On 64bit Operating Systems the installer will install 32bit software into a directly containing "(x86)". Some versions of the Oracle Client initialization error could won't work if an application using the client is installed in a directory path containing "()" characters. To fix this just install the program to a directory that doesn't have "()" characters in it or install a newer version of the Oracle Client that doesn't have this problem. This is Oracle Bug #3807408 and should be fixed in newer client versions (note: seems to be fixed in the 11.2 client.) Why am I getting an error "Can not initialize OCI" or "Cannot load OCI DLL" when I try to login? This means that the program couldn't load the Oracle Client. This can happen in the following cases: a. The Oracle Client is missing or installed incorrectly. b. You are trying to use the 64bit version of the Oracle Client with either Golden 5.x or the 32bit version of Golden 6.x. Golden 5.x needs the 32bit Oracle Client. c. You are trying to use the 32bit version of the Oracle Client with the 64bit version of Golden 6.x. Golden 6.x 64bit needs the 64bit Oracle Client. d. The user does not have read or execute rights to the Oracle Client files. To quickly check if it's a rights problem, right click the startup icon and choose "Run as administrator". If that fixes the problem then the issue is that the user account is missing read or execute rights to an Oracle Client file. Why am I seeing #data_error# messages in the data