Re: Oracle-Two-Task in Oracle LoadBalanced Oracle DB

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.

Re: Oracle-Two-Task in Oracle LoadBalanced Oracle DB

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

Re: Oracle-Two-Task in Oracle LoadBalanced Oracle DB

Hello Sonia, you should try add the following information for both server (ITSM764_125, ITSM764_126) in the transname.ora file ITSM764_125 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ARS7604)(PORT = 1521)) ) (CONNECT_DATA = (SID = ITSM764_125)

Oracle-Two-Task in Oracle LoadBalanced Oracle DB

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)