We had the same issues and ended up abandoning RAC. Oracle told us that the Transparent Application Failover (TAF) code that made the switch via OCI libaries wasn't supported in the arserver binaries. Or we never figured out how to set up our connection strings properly...
I'd also be interested to hear if someone has figured out how to fail over without affecting arserver or requiring a restart. http://wiki.oracle.com/page/Transparent+Application+Failover+(TAF) Tony Worthington | Sr. Technical Analyst | Kohl?s Department Stores N56 W17000 Ridgewood Drive | Menomonee Falls, WI 53051 | office: (262) 703-7763 | e-mail: tony.worthing...@kohls.com From: "Ramey, Anne" <anne.ra...@its.nc.gov> To: arslist@ARSLIST.ORG Date: 11/13/2009 03:40 PM Subject: Oracle RAC failover Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> ** We've been running ARS 7.0 then upgraded to 7.1 with ITSM 7.0 using Oracle RAC as the DB for the last 2 years. Everything is fine when everything is up, but we discovered recently that the failover just doesn't work. SQLPlus sessions from the ARS servers work fine and recover from the pause in the failover fine. Remedy just doesn't seem to be able to handle it at all. The DBAs say that the oracle errors I see in the ARS logs are normal for a failover--but the app just can't handle it. Does anyone have oracle RAC working so that the failover actually prevents all ARS failures? Anne Ramey *********************************** E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ********************************************************************** CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"