Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] re: connection timeout and nic outage

Peter Santos

2007-05-31

Replies:

-----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: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.