RE: Client failover with 10g DG

DB1 =

(DESCRIPTION=   (FAILOVER=ON)
(ADDRESS_LIST=
       (ADDRESS=(PROTOCOL=TCP)(HOST=10.34.22.2)(PORT=1521))        (ADDRESS=(PROTOCOL=TCP)(HOST=10.34.22.3)(PORT=1521))      )

(CONNECT_DATA=(SERVICE_NAME=SID1)

(SERVER=DEDICATED)

(FAILOVER_MODE=(TYPE=none)(METHOD=basic))

     )

)    

De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Ram Raman
Enviado el: martes, 18 de enero de 2011 0:03 Para: ORACLE-L
Asunto: Client failover with 10g DG  

Listers,    

I am doing some research on setting up v10.2 DG for couple of our databases. They both will be single instance DBs. We are looking into the new client connections automatically going to the standby in case of failover and the configuration of client tns. I am looking into creating services based on this <http://prutser.files.wordpress.com/2008/12/client_connectivity.pdf> paper. It seems to    

What do other listers do to automate client failover in case of primary instance failure. Is using triggers with services a reliable way of failing over to standby (the new primary) ? Any surprises there?     

Thanks.  

--
http://www.freelists.org/webpage/oracle-l