Can Transparent Application Failover (TAF ) handle a Network disconnect ?

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 Thu Oct 03 2002 - 18:43:16 CDT