My World A Blog On All The Things That Happen In My Life

Fix Initialization Error: LoadLibrary oci.dll returned 0 while trying to connect to Oracle using PL/SQL Developer
about Oracle & PL/SQL Stuff on 21/03/2011 - like it?

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.

Related posts:

1. Making Oracle Forms Use JRE instead of Jinitiator
2. Download Toad for Oracle for Free
3. Exporting and Importing An Oracle database from one schema/user to Another schema/user easily
4. PL/SQL Procedure To Reset A Sequence To A Predefined Number in Oracle
5. The Power and Simplicity of Oracle Hierarchical Queries

Tags: database, instant client, oracle, PL/SQL, PL/SQL Developer

Blogged: Fix Initialization Error: LoadLibrary oci.dll returned 0 while trying to connect to… http://goo.gl/fb/N3pGL

Lovingly written by Sathya on 21/03/2011

This is a great finding and it so helpful. Many thanks.

Lovingly written by Tim Gbadebo on 30/09/2011

It was a nice fix and nice thing to learn.

Lovingly written by prem on 06/12/2011