3 Replies Latest reply: Jan 2, 2013 10:20 AM by Jim Smith RSS

    SQL developer

    Reddy G

      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

          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.


          Edited by: hitgon on Jan 2, 2013 5:36 PM
          • 2. Re: SQL developer
            Reddy G
            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
              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.