Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TAF and TCP Timeouts - TNS Config - VIP

jstem1177Aug 7 2012 — edited Aug 8 2012
Hello all,

I'm reviewing a Dataguard 11gR2 setup (1 primary --> 1 physical standby). I was just curious to know, given the below tns, wouldn't the client receive/wait a TCP timeout after 3 minutes if the primary server was actually complete down.

Here si the scenario, I do a switchover from primary to standby --> all the connections already connected get passed to the new primary using TAF.
Now all those already connected before the swtichover are ok, but now the new standby(original primary) goes completely down, would I need to change the TNS entry to use VIP instead for the new connections not to TCP timeout?
POMS=
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = orap01.intm.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = orap02.intm.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = POMSDG.mf.galderma.com)
    )
  )
Below is a reference Tom Kyte, but was wondering if someone else had already put this into place.
Here it solution:
-----------------
1) tnsnames.ora entry will have connect time failover configured for primary and standby.

2) If primary database is down but primary node is up. The above will work fine. 

3) But if primary database is down and primary node is also down. The each attempt to connect using 
tnsnames.ora will go through a TCP timeout. 

solution for 3:

b) On another node in primary subnet - bind/start the Failed database node IP. This can be done via 
a script.
Make sure to shut this down, when bringing up the failed primary node. (This is kind of a manual 
VIP failover)
Thanks in advance for your advice or assistance in thsi matter.

Jan S.
This post has been answered by Sebastian Solbach -Database Community-Oracle on Aug 7 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 5 2012
Added on Aug 7 2012
5 comments
1,125 views