Hi Listers, We are setting up the our ARS solution using Server group with two Database servers in Active and Standby mode using Data guard. In the application server, the tnsnames.ora has an entry with two hosts(primary and secondary) connected with the same service name.
Below is the txt from tnsnames.ora test = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.230 )(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = x.x.x.231 )(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = abc) ) ) Now when the primary host (.230) is active, the application runs fine. The moment we switch off the primary database (.230)and mount the secondary one. The application shuts down. It gives Unable to connect to Database error. In the tnsnames.ora on the application server, when we make the primary HOST as 231 and secondary as 230, it again runs fine. Why ARS Application does not connect to the secondary address automatically? What can be the solution to this? ARS 7.1 patch 4 on Solaris 10 Oracle 10g on Red hat Linux Regards Ankur _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
