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 sqldeveloper.sh , 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

2 Answers 2


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

New connection dialogue


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: https://forums.oracle.com/forums/thread.jspa?threadID=428671

  • 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. ( stackoverflow.com/questions/219585/… )
    – PAStheLoD
    Oct 16, 2011 at 14:19
  • sqldeveloper is latest version , just grabbed from oracle's site today
    – daisy
    Oct 16, 2011 at 15:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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