ORA-3135 Fixed by PC Restart
From: Charlotte Hammond <charlottejanehammond_at_yahoo.com>
Date: Wed, 2 Oct 2013 12:07:42 -0700 (PDT)
Message-ID: <1380740862.4037.YahooMailNeo_at_web140006.mail.bf1.yahoo.com>
Hi All,
�
I've got a problem with a Windows 7 PC client (11.2.0.1) which after a period of time (days/hours) starts throwing ORA-03135 (after a hang of about 20 seconds) when I try to connect to a particular database (11.2.0.3).�� Restarting the PC always�fixes the problem for a while but is not a convenient workaround.
�
It only happens on this one PC and against one target database.� (i.e. other PC's can connect to the problem DB, and also�this PC can connect happily�to other databases).� I've traced the client and listener but not seen anything helpful yet- just a 20 second gap in times on the client side before it fails,�and a listener trace that stops dead on the disconnect.� I've tried changing the CONNECT_TIMEOUT to no avail and gone through the Oracle MOS�doc on ORA-03135 troubleshooting.
�
Just wondering if this sounded familiar to anyone?�� Just�seems the fact that rebooting the PC fixes things suggests the problem lies there.� Both PC and Server are very, very�lightly loaded.�(A bit vague, I know, but just looking for guidance on where to look:� the client or the server?� Could it be a firewall issue? - there is a firewall in the path - but don't know why it would be intermittently failing to connect and the network guys aren't very interested so I'd need something more than a vague guess to get traction from them.� It's quite difficult to diagnose/fix when the problem is not readily reproducible).
�
Many thanks,
Charlotte
Date: Wed, 2 Oct 2013 12:07:42 -0700 (PDT)
Message-ID: <1380740862.4037.YahooMailNeo_at_web140006.mail.bf1.yahoo.com>
Hi All,
�
I've got a problem with a Windows 7 PC client (11.2.0.1) which after a period of time (days/hours) starts throwing ORA-03135 (after a hang of about 20 seconds) when I try to connect to a particular database (11.2.0.3).�� Restarting the PC always�fixes the problem for a while but is not a convenient workaround.
�
It only happens on this one PC and against one target database.� (i.e. other PC's can connect to the problem DB, and also�this PC can connect happily�to other databases).� I've traced the client and listener but not seen anything helpful yet- just a 20 second gap in times on the client side before it fails,�and a listener trace that stops dead on the disconnect.� I've tried changing the CONNECT_TIMEOUT to no avail and gone through the Oracle MOS�doc on ORA-03135 troubleshooting.
�
Just wondering if this sounded familiar to anyone?�� Just�seems the fact that rebooting the PC fixes things suggests the problem lies there.� Both PC and Server are very, very�lightly loaded.�(A bit vague, I know, but just looking for guidance on where to look:� the client or the server?� Could it be a firewall issue? - there is a firewall in the path - but don't know why it would be intermittently failing to connect and the network guys aren't very interested so I'd need something more than a vague guess to get traction from them.� It's quite difficult to diagnose/fix when the problem is not readily reproducible).
�
Many thanks,
Charlotte
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 02 2013 - 21:07:42 CEST