Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Mar 21 '11 at 1:29

This question came from our site for professional and enthusiast programmers.

add comment

2 Answers 2

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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.