RE: Client failover with 10g DG
- From: Juan Miranda <jcmiranda@xxxxxxxxx>
- To: <veeeraman@xxxxxxxxx>, "'ORACLE-L'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Jan 2011 12:36:20 +0100
I use this entry in tnsnames.ora
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
Other related posts:
