Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does the client "hang" or "disconnect" when the server's

Re: Does the client "hang" or "disconnect" when the server's

From: Michael Boligan <michael.boligan.b_at_bayer.com>
Date: Thu, 24 Jul 2003 10:55:17 -0400
Message-Id: <26007.339443@fatcity.com>


Hemant,

      You are right it does get a timeout from the TCP stack, but the default for the connection timeout is 30 minutes. There is a sqlnet parameter where you can modify the timeout to make it shorter (sqlnet.expire_time?) Check metalink note 151972.1 for more info.

HTH
Mike

                                                                                                                                   
                      Hemant K Chitale                                                                                             
                      <hkchital_at_singnet        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>               
                      .com.sg>                 cc:                                                                                 
                      Sent by:                 Subject:  Does the client "hang" or "disconnect" when the server's                  
                      ml-errors_at_fatcity                                                                                            
                      .com                                                                                                         
                                                                                                                                   
                                                                                                                                   
                      07/24/2003 11:24                                                                                             
                      AM                                                                                                           
                      Please respond to                                                                                            
                      ORACLE-L                                                                                                     
                                                                                                                                   
                                                                                                                                   






I'm sorry, but I really can't remember how an Oracle SQLPlus client is supposed to behave when the database server's network interface is "pulled out". We were testing a new Sun Cluster and tests for Storage FC Path Failure, Instance Failure,
Node Failure, HeartBeat failure and single Network Interface failure all went through.

However, when the engineer pulled out *both* network interfaces of the running database server node, the SQLPlus client that had been running INSERT statements
just "hung". It did not exit or error out till we killed the job. At the next restart, of course,
it connected to the database which had already failed-over to the second node.

The question is : Why does the SQLPlus client "hang" ? Telnet sessions also might
"hang" [couldnt' test this out as the Servers are Secured and we didn't have SSH on the
client], till the user hits the ENTER key, but shouldn't SQLPlus get server disconnect
from the TCP stack ?

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services

---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jul 24 2003 - 09:55:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US