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 <[email protected]>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_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
