Re: Orphan database connections

From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Wed, 4 Sep 2019 14:21:36 -0500
Message-ID: <CAP79kiRmUD6o=CBcT3gf54X1g1vVdad9TLL+qOjZRD=YuQxzeg_at_mail.gmail.com>

Try this:

1. Use sqlplus as your test subject
2. Open sqlplus and connect to the db on the windows 10 client
3. Open the db server do a netstat -anop | grep -i <your clients

ip_address> (you should find a port open that maps to your workstation ip) 4. Open a command prompt on your windows client and do a netstat -anob | findstr -i port# (from step 3)

5. Close the sqlplus window (not exit the program)
6. Do another netstat -anob | findstr for the port# and check the status
... if its in TCP_TIMEDWAIT then its a time_wait indefinite issue
... if the socket is actually dead/gone on the client, then I am at a loss
... if the socket is showing CLOSE_WAIT then you might have a tcp close

wait time issue (not sure the param that controls that on windows off top of my head however)

Chris

On Wed, Sep 4, 2019 at 2:01 PM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> wrote:

> As a test, I installed Quest Toad (trial) and performed test. Upon closing
> the Window the database connections were terminated. Could be that Toad
> captured the close Window command and cleaned up after itself before
> terminating.
>
> A packet trace shows Toad sending a "FIN" to the database while Oracle's
> programs send a "RST" as the final transmission.
> >>> Chris Taylor <christopherdtaylor1994_at_gmail.com> 9/4/19 12:18 PM >>>
>
> Tcp_timedwaitdelay indefinite perhaps?
>
> Something in the TCP stack keeping the socket open on the clients PC
>
> Chris
>
> On Wed, Sep 4, 2019, 10:57 AM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org>
> wrote:
>
>> We are in the very early stages of a desktop migration to Windows 10. To
>> date, only 3 IT personnel that use Oracle have a Windows 10 PC. Of those,
>> two are experiencing a problem. If you are in SQL Plus or SQL Developer and
>> do not exit/close the connection prior to closing the application's window,
>> the database connection remains after the program is terminated. This does
>> not occur on any of our Windows 7 desktops. We have not been able to
>> identify a difference between the PC that does terminate the database
>> connection upon the window being closed and the two that do not. All of our
>> PCs start from a standard image.
>>
>> Oracle is suggesting looking at the network, however, all of the PCs are
>> inside the firewall and if in SQL PLus you state "exit" or in SQL Developer
>> you right click the connection and choose disconnect, the connections are
>> terminated. The issue only arises on 2 out 3 PCs if just close the Window
>> without taking any other actions first.
>>
>> Any suggestions on what may be the cause? Does Windows 10 not send a
>> termination message and thus you now have ensure you break the connection
>> manually?
>>
>> Jeffrey Beckstrom
>> Lead Database Administrator
>> Information Technology Department
>> Greater Cleveland Regional Transit Authority
>> 1240 W. 6th Street
>> Cleveland, Ohio 44113
>>
>>
>
> ------------------------------
> This email has been scanned for spam and viruses. Click here
> <https://attseg.cloud-protect.net/index01.php?mod_id=11&mod_option=logitem&mail_id=1567613908-JTJaO40Mavju&r_address=jbeckstrom%40gcrta.org&report=1>
> to report this email as spam.
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 04 2019 - 21:21:36 CEST