Re: re: connection timeout and nic outage

There is not a way to feel a connection failure in TCP/IP if client don't
send data. SO you must rely on TAF or Fast Failover, which (any or both)
should be implemented in connection pool.


(But, once client sent any data, and IF it used VIP address for connecton,
it will be notified immediately).

----- Original Message ----- 
From: <[email protected]>
To: <[email protected]>; <[email protected]>
Sent: Monday, July 02, 2007 3:18 AM
Subject: RE: [suse-oracle] re: connection timeout and nic outage


Probably a bit late, but you can combine TAF with FAN (Fast Application
Notification).
http://download.oracle.com/docs/cd/B19306_01/rac.102/b14197/hafeats.htm#
BABECAFD

Kind regards,

Herta

-----Original Message-----
From: Peter Santos [mailto:[email protected]]
Sent: Thursday, May 31, 2007 19:43
To: [email protected]
Subject: [suse-oracle] re: connection timeout and nic outage


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Guys,
  In 10g RAC/Linux how should the query timeout be dealt with when
there is a nic failure. I
understand the concept of NIC bonding, but that is not an option
that we are considering.

Anyway, my question is how you've dealt with connection
timeouts. In my example, I have TAF
connection setup with the "BASIC" option. Here is the simple
test case.

1. sqlplus (using descriptor with TAF configured) into
some instance.
2. run a select sys_context('USERENV','INSTANCE_NAME')
from dual;

     >> go to node from step 2 and do "ifdown eth0"
3. re-execute query from step 2 .. this should hang ...

I see the VIP failover almost immediately, but my connection
will hang on that SELECT for about 15 minutes.
After that it WILL failover to another instance and I can
re-execute the query.

What I've been trying to get out of Oracle Support is an answer
on shortening the "hang" time. I can't seem
to make any progress on this ... Has anyone tested this sort of
thing?

- -peter




-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGXwkkoyy5QBCjoT0RApcZAJ9dIngwD8V0PtSeq9a6WjLoxgUHUgCeOM+F
k0U6vcu5Bs20ZibM2cBRcjc=
=u6hm
-----END PGP SIGNATURE-----

-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected] Please see
http://www.suse.com/oracle/ before posting


-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting



-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting