1 Reply Latest reply on Jun 27, 2019 5:51 PM by Glen Conway

    SQL Developer Auto-Connect

    3994762

      Has anyone noticed when SQL Developer starts on a user PC, it generates a connection (or at least talks to the listener) automatically to certain databases?

       

      I am using SQL Developer 19.1.0.094 build 094.2042. I don't have anything set up to open new SQL Worksheets on startup, and I have not customized any options. I did a basic install (unzip), created some new connections. It doesn't do this on all of my defined connections, just on certain ones.

       

      When I open SQL Developer I see this in my listener.log on the server (changed the names and IPs to protect the innocent):

       

      27-JUN-2019 11:23:13 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=instance1.domain.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=my.ip.add.ress)(PORT=11907)) * establish * instance1.domain.com * 0

      27-JUN-2019 11:23:13 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=instance2.domain.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=my.ip.add.ress)(PORT=11910)) * establish * instance2.domain.com * 0

      27-JUN-2019 11:23:20 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=instance3.domain.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=my.ip.add.ress)(PORT=11924)) * establish * instance3.domain.com * 0

      27-JUN-2019 11:23:20 * (CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=instance4.domain.com)) * (ADDRESS=(PROTOCOL=tcp)(HOST=my.ip.add.ress)(PORT=11926)) * establish * instance4.domain.com * 0

       

       

       

       

       

       

        • 1. Re: SQL Developer Auto-Connect
          Glen Conway

          If I startup SQL Developer (without opening any connections), then hover the mouse cursor over nodes in the connections tree one-by-one, some of them (not all!) display a "Last Ping" time in milliseconds in the tool tip.  I suppose SQL Developer is doing the JDBC equivalent of TNSPING on these connections in order to get the ping time.

           

          Just a guess, so any corrections are welcome.

          1 person found this helpful