Hi Conny and others, In the tnsnames.ora we missed out (FAILOVER=on). So now it does identify the secondry host if primary is down BUT ARS is behaving weird after this.
When the ARS is restarted and it finds primary down and then it does connect to the secondry database and the application works fine. Now we restart the ARS again, it still detects that on primary database there is no connection, it jumps to secondry db and the AR server gets up and running. Now when the user tries to log in, it just doesn't connect and after almost 2 mins of trying to set server port (at the login screen) it errors out with ARERR[93] "Database timeout" We restart the AR server once again and everything works well. So every second restart of ARS is leading to database timeout. Any ideas, as what might be wrong. *I have been banging my head on this since last 7 hours* Regards Ankur On Tue, Jul 21, 2009 at 6:09 PM, Conny Martin<[email protected]> wrote: > 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:[email protected]] Im Auftrag von Ankur Gulati > Gesendet: Dienstag, 21. Juli 2009 14:00 > An: [email protected] > 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:[email protected] ARSlist: "Where the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
