Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

@update1:


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

@update2:


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

2 Answers 2

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

New connection dialogue

share|improve this answer
add comment

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

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. ( stackoverflow.com/questions/219585/… ) –  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
add comment

Your Answer

 
discard

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.