This discussion is archived
3 Replies Latest reply: Jan 2, 2013 8:20 AM by Jim Smith RSS

SQL developer

ReddyG Pro
Currently Being Moderated
Hi,

can we connect to server instance from locally installed SQL developer(note:I dont have oracle client installed in my sys),I have TNS entry for it..
  • 1. Re: SQL developer
    hitgon Expert
    Currently Being Moderated
    YES

    You can directly connect using jdbc thin method without install the oracle client in your local.

    SQL Developer's default connection to the database is using the thin JDBC driver.
    Defaulting to using the JDBC thin driver means there is no requirement for an Oracle
    client install minimizing the configuration and footprint.

    http://www.oracle.com/technetwork/developer-tools/sql-developer/what-is-sqldev-093866.html

    Edited by: hitgon on Jan 2, 2013 5:36 PM
  • 2. Re: SQL developer
    ReddyG Pro
    Currently Being Moderated
    Thanks for ur replay..

    can you tell me what information i need to provide for JDBC...in SQL developer I can see Custom JDBC URL option in Advanced part..
    is there doc which will provide the step by step..
  • 3. Re: SQL developer
    Jim Smith Expert
    Currently Being Moderated
    Youdon't need to use the Advanced connection, Basic connection is sufficient.

    You just need to provide a host, port number (probably 1521), and a SID or SERVICE. You can get these from the tnsnames file if you have one or from your DBA.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points