*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@xxxxxxxxxxx] > Gesendet: Donnerstag, 14. Juli 2005 16:18 > An: BERNHARD Nora; oracle-l@xxxxxxxxxxxxx > 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) > ) > ) > ) -- //www.freelists.org/webpage/oracle-l