AW: TAF

*woo-hooo* it works!
Although I had already tried the parameters LOAD_BALANCE, FAILOVER and ENABLE a few times in a different order (after the ADDRESS definition), only the order given below seems to work for me *wonders* So thanks to all you, guys, you helped me a lot! :)

Cheers,

Nora

> -----Ursprüngliche Nachricht-----
> Von: arun chakrapani rao [mailto:arunrao_oradba_at_yahoo.co.in]
> Gesendet: Donnerstag, 14. Juli 2005 16:18
> An: BERNHARD Nora; oracle-l_at_freelists.org
> Betreff: Re: TAF
>
> It is better to set the failover=on and enable=broken and
> also did u check on both listeners side that both instances
> are getting registered for the service which u are using.
>
> I use the following tnsname and is working uptil now.
>
> CMSPRD_BT =
> (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 = 120)
> (DELAY = 2)
> )
> )
> )

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