Ankur, IMHO your oracle listener isn't configured properly. Try to stop the listener on .230 after switch.
Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Ankur Gulati Gesendet: Dienstag, 21. Juli 2009 14:00 An: arslist@ARSLIST.ORG Betreff: Unable to connect to secondry host in tnsnames.ora 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
