| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Can Transparent Application Failover (TAF ) handle a Network disconnect ?
you need to reduce the TCP/IP timeout which is outside Oracle control.
The exact method is OS dependent. This will fix delayed failover
between hosts for:
Most OS set default value way too high than needed for most corporate LAN/WAN. Howto change for Windows + Solaris
Windows Reg
Location: \HLM\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Name Data TcpMaxConnectRetransmissions 1
Solaris (as root)
default (ndd -get /dev/tcp tcp_ip_abort_cinterval) equates to > 3 mins
To test outside Oracle. Run telnet a.b.c.d to valid address on your network for a non-existent host. Change timeout and watch telnet return faster
Geoff Ingram
http://www.dbcool.com The all-free no-timeout Oracle tuning tool
Author "High Performance Oracle"
http://www.amazon.com/exec/obidos/tg/stores/detail/-/books/0471224367/customer-reviews/ref=cm_rev_all_1/104-1222748-5117565
ryan_at_dsilva.org (Ryan D'Silva) wrote in message news:<6f64a09f.0210031543.7b6c7a0e_at_posting.google.com>...
> Hello,
> does anyone know if Oracle 8 and 9's TAF still works if it's the
> network connection which goes down as opposed to just the database
> connection? Everything I've read indicates that the database server
> going down can be handled, but what about a cable going down?
>
> This is the second time (see message below) that I've heard about the
> network connection issue. What seems to happen is that the connection
> is stuck there until a TCP timeout is recieved from the issuing client
> machine - and that could take between 4-10 minutes (too long).
>
> Does Oracle 9i handle that problem any better? I know they did some
> work on the TAF handling, but the documentation doesn't mention a
> network connection drop specifically.
> If it matters, I'm planning on using TAF with the OCI drivers under
> Weblogic.
>
> Thanks,
> - Ryan
>
> >>>>>>>>>>>>>> OLD POST >>>>>>>>>>>>>>>>>>>>>>
> Hi, all
>
> I'm using oracle OCI to access database. The database connection can
> be
> transfered to backup database from primary database when primary
> database
> shutdown gracefully. The primary and backup database are just seperate
> database, not parallel servers. The problem is when I tried to get the
> same
> result when the network cable of the primary database machine was
> disconnected, it seems that the OCI statement was stuck there. I even
> couldn't get the OCI error. I also tested the socket communication by
> running two simple code on two Unix machines. When one of machines'
> cable
> is pull out, the socket will report error after 9 minutes. Maybe this
> is why
> OCI couldn't give us error response when cable disconnect. I guess OCI
> should have seeeion timeout, but I didn't find how to configure.
> If you guys give me some idea, thank you in advance.
>
> Sam He
Received on Tue Oct 08 2002 - 15:16:34 CDT
 |
 |