| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Does the client "hang" or "disconnect" when the server's
I agree sqlnet.expire_time does only effect the server, but normally when the
server kills the connection the client side will drop. But in this case it
won't because there is no network for the client to get the dead connection
timeout from the server. It sounds like Hemant is running OPS which AFAIK
(version 7.3) he is getting the expected behavior, to get the client to
seemlessly switch over to the other instance he needs RAC (again AFAIK).
"Tanel Poder"
<tanel.poder.003@ To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
mail.ee> cc:
Sent by: Subject: Re: Does the client "hang" or "disconnect" when the server's
ml-errors_at_fatcity
.com
07/24/2003 12:19
PM
Please respond to
ORACLE-L
Hi!
This sqlnet.expire_time affects server, not sqlplus itself AFAIK. The issue
is likely, that sqlplus has sent a sqlnet request to server, but hasn't got
any response since you pulled the network cable. Thus it'll wait until TCP
connection gets timeout.
Also, sqlplus is different from normal telnet, because it tries to send a
request only when it is on it's prompt, thus issuing a command in sqlplus
session, when it is waiting for response from previous command, doesn't send
any network packets.
Tanel.
>
>
>
>
> 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).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Michael Boligan
> INET: michael.boligan.b_at_bayer.com
>
> 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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: tanel.poder.003_at_mail.ee 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-LReceived on Thu Jul 24 2003 - 12:06:13 CDT
 |
 |