Taf issue in 9i rac on redhat linux 3
- From: arun chakrapani rao <arunrao_oradba@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 3 Jun 2005 04:48:36 +0100 (BST)
Hi Rac gurus
I am facing a peculiar issue here in 9i rac running on
2 Red hat linux nodes
If one of the nodes freezes(like powering down the
node)the TAF clients are taking a very long time to
failover to the working node almost i can say around
10 to 15 mins
I have set the following tcp parameters on the linux
client side and as well on the server side
echo 30 > /proc/sys/net/ipv4/tcp_keepalive_time
echo 60 > /proc/sys/net/ipv4/tcp_keepalive_intvl
echo 3 > /proc/sys/net/ipv4/tcp_retries2
echo 2 > /proc/sys/net/ipv4/tcp_syn_retries
and also in the tnsnames i have used the enable =
broken parameter for the TAF
Am I missing any other parameter which is not allowing
the clients to failover pretty fast.
the following is the tnsname
CMSPRD_BT6 =
(DESCRIPTION =
(LOAD_BALANCE = on)
(FAILOVER = on)
(enable = broken)
(ADDRESS = (PROTOCOL = TCP)(HOST =
10.30.0.37)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST =
10.30.0.38)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CMSPRD)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 10)
(DELAY = 2)
)
)
)
the local clients ie the clients connected on the
working node using BEQ connections are working fine
they are not getting affected. this is happening only
to the the TAF connections.
If anybody has faced the same issues and have solved
this out please let me know
thanks in advance
Arun
_______________________________________________________
Too much spam in your inbox? Yahoo! Mail gives you the best spam protection for
FREE! http://in.mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
