3 Replies Latest reply on Nov 13, 2018 4:37 PM by rp0428

    Basic SQL info

    808tech

      What is the default TCP port used by SQL Developer?

      Thanks in advance

        • 1. Re: Basic SQL info
          Glen Conway

          If you are referring to the port present in the JDBC URL that SQL Developer uses to connect, then that depends on how the database listener is configured.  Using SQL Developer to connect to a default install of Oracle 11g XE, then running

          show connection
          

           

          from the worksheet, you should see

          CONNECTION:
          SCOTT@jdbc:oracle:thin:@localhost:1521:xe UNKNOWN
          CONNECTION_IDENTIFIER:
          XE
          CONNECTION_DB_VERSION:
          Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
          NOLOG:
          false
          PRELIMAUTH:
          false
          

           

          which is similar to what appears in tnsnames.ora used by sqlplus or sqlcl:

          XE =
            (DESCRIPTION =
              (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
              (CONNECT_DATA =
                (SERVER = DEDICATED)
                (SERVICE_NAME = XE)
              )
            )         
          

           

          Cheers                     

          1 person found this helpful
          • 2. Re: Basic SQL info
            B.Delmée

            So, as shown in Glen's answer, the default port is 1521 which is also the value initially displayed by sqldeveloper when creating a new connection. If that dos not work for you, you need to ask your dba which port your listener is configured for.

            • 3. Re: Basic SQL info

              What is the default TCP port used by SQL Developer?

              Sql Dev does NOT have a 'default TCP port.

               

              If you want to connect Sql Dev to a database you have to TELL IT what type of connection to make and, if you want to use TCP you need to specify the port used by that databases configuration spec in the listener.

               

              You can use almost any port you want if the listener and database are configured properly.

               

              Start over and tell us:

               

              1. WHAT you are trying to do

              2. WHAT version of sql developer you are trying to do it with

              3. WHAT version and type of database you are trying to connect to

              4. WHAT platform you are doing it on