RE: Unwanted SQL Developer inverse connection storming
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "usn@xxxxxxxxx" <usn@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Apr 2013 11:43:33 -0400
Hi Martin,
I wasn't aware of this behavior, and I agree that it doesn't make a whole lot
of sense.
I recommend the SQL Developer forum at the OTN forums, here:
https://forums.oracle.com/forums/forum.jspa?forumID=260
It's a pretty good resource, and often you can get an answer directly from a
developer or product manager type.
Hope that helps,
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Martin Klier
Sent: Wednesday, April 03, 2013 11:31 AM
To: oracle-l
Subject: Unwanted SQL Developer inverse connection storming
Dear listers,
recently we noticed that the Oracle SQL Developer causes a kind of unwanted
"inverse" connection storm to all configured databases, when we start the SQL
Developer. It's not restoring aborted connections or stuff like that, all was
quit before stopping the SQL dev., and nevertheless each and every configured
connection is "tested" at startup.
In my example, it's doing the following for all configured connections (tested
with version 3.2.20.09):
TNS connect:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ww.xx.yy.zz)(PORT=1521))(CONNECT_DATA=(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))(SERVICE_NAME=xyz)(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))))
and gets back:
(DESCRIPTION=(TMP=)(VSNNUM=186647296)(ERR=12514)(ERROR_STACK=(ERROR=(CODE=12514)(EMFI=4))))
I'm having multiple problems with this behavior:
1.) it's useless, since the SQL dev does not display any information about
reachable/non-reachable databases. I simply can't see any benefit.
2.) it's waste of network resources
2.) it's most unwanted since your network can see what you have configured (for
example in a public WLAN, and in worst case a IDS might feel like you are doing
something nasty in the (for example, customer's)
network)
Does somebody know why they are doing this, and why are they doing it THIS very
way?
Thanks a lot in advance and best regards Martin Klier
--
Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
