Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I use SQL Developer to connect to a local Oracle 11g server? I didn't enable TNS Listener, but SQL*Plus works well.


I copied all *.jars from $ORACLE_HOME/app/product/11.2.0/dbhome_2/jdbc/lib/ to jdbc directory in SQLDeveloper

And I get error: no ocijdbc11 in java.library.path

So I traced down , and add some parameters to it:

modified script to add library path

However , another error discovered:

error dialog B

Certain wired string kept changing each time i connect


If only I add

export CLASSPATH=$CLASSPATH:/Application/Binaries/oracle_11g/app/product/11.2.0/dbhome_2/jdbc/lib

I'll get the following error:

error when all jdbc libraries added

share|improve this question

In SQL Developer, use the Local/Bequeath connection type:

New connection dialogue

share|improve this answer

SQLplus uses IPC to directly communicate with the instance, and I don't think SQLdeveloper has that option. Try the method described in this thread:

share|improve this answer
Mixing Oracle 11g's into SQLdeveloper's classpath doesn't seem like the best idea (it's probably what cauese the random error messages). Just add the odbc*.jars to the classpath you've copied. (… ) – PAStheLoD Oct 16 '11 at 14:19
sqldeveloper is latest version , just grabbed from oracle's site today – warl0ck Oct 16 '11 at 15:10

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.