You should be using the VIP address / racscan address as well, you don't normally just use any address so check with you oracle Dba/ network pugs a d make sure
Sent from my iPhone On May 8, 2013, at 3:20, Mayuresh Wagh <mayurbw...@gmail.com> wrote: > ** > Hi Sonia, > > How to do you connect to see both the DB instances? As far as connection is > concerned from the AR Side, AR will connect to single instance only. However > since this is load balanced if that particular instance is down, then AR will > retry the connection & connects to the other instance. This will keep your > ARS up & running without any issues. > > Does that answer your query? > > > > > On Wed, May 8, 2013 at 10:05 AM, Jennifer Varkey <sonia_m...@yahoo.co.uk> > wrote: >> ** >> Hello All, >> >> I have the following entries in the tnsnames.ora >> >> ORCL = >> (DESCRIPTION = >> (ADDRESS = (PROTOCOL = TCP)(HOST = ITSM764_125)(PORT = 1521)) >> (ADDRESS = (PROTOCOL = TCP)(HOST = ITSM764_126)(PORT = 1521)) >> (LOAD_BALANCE = yes) >> (CONNECT_DATA = >> (SERVER = DEDICATED) >> (SERVICE_NAME = orcl) >> ) >> >> Now, in the ar.conf the parameter for Oracle-Two-Task is "orcl". >> >> When I connect I get to see data from both the DB instances. >> >> How do I configure settings in ar.conf so that it connects to just one >> instance in a load-balanced Oracle environment? >> >> Regards, >> Sonia >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
