OCI and TCP keepalive (SO_KEEPALIVE)
413605Apr 19 2004 — edited Apr 27 2004 I have a 9.2.0.4 RAC install.. and a very big problem when my app written in pure C (using OCI) don't realize that the conection to the database is broken for example if I disconnect the UTP cable on one of the RAC Nodes. (the same would happend if i suddendly power off the machine)
One thing I tried.. is to put the parameter BROKEN in DESCRIPTION section in tnsnames.ora on the client side.. but.. this doesn't fix the problem.
I can't get the TAF working..and my app disconects from the database. No failover is done so.
Does anyone knows how to deal with these??.. because.. this makes the failover somekind of useless in this case... even if i touch TCP keepalive settings when TCP timers expires my app disconects from the instance and do not fail over to the other instances in the RAC.
Any clue of how should i do to fix it??
Thanks in advance everyone!. Any help would be very apreciated,.
Christian.