Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error "no ocijdbc11 in java.library.path" in SQL Developer 4

nikosJul 23 2013 — edited Nov 22 2013

Hi!

I have just installed the latest version of Oracle 12c and the latest SQL Developer (4.0.0.12). I have also JDK 7u25 installed. I run everything on Windows 7 64bit. When I create a local connection in SQL Developer and test or try to connect I get the error: no ocijdbc11 in java.library.path

If I try the exact same thing in SQL Developer 3.2.2 (the one bundled with the latest Oracle 12c) it works fine. In both versions of SQL Developer I have done no configuration and all the settings are the defaults.

I have read all the posts that relate to this error message, but they are all based on older versions or other platforms.

Is there a problem in the default configuration of SQL Developer 4 or a compatibility problem with Oracle 12c? Any ideas of how to fix this?

When I compare the properties of the two versions of SQL Developer I see that most of them are identical, but the java.library.path points to the sqldeveloper/bin directory in v4 and to the sqldeveloper root folder in v3. I don't know if that is significant.

Also the setting "Use OCI/Thick Driver"  under "Database: Advanced" is unchecked, so it seems strange that it tries to use it anyway.

/nikos

Comments

angelr
Hi
You can create a service to start the application, thus, the java app is always running even if no user is logged

use the Java Service Wrapper (google search)
You can also use the sc.exe to create the service
don't forget to check in window services if autostartup once created
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 20 2013
Added on Jul 23 2013
4 comments
5,180 views