Thanks Rick -- We're in the same boat with just a vague recollection. But at least your recollection and ours indicates it wasn't some weird dream. Or does it? BMC Support (backline) says no Oracle-RAC issues exist in their KB's! Maybe we *are* in the twilight zone.
JDHood On Fri, Oct 14, 2011 at 5:17 PM, Rick Cook <[email protected]> wrote: > ** I seem to recall an issue in 7.5 where RAC would not play nicely with > Server Groups. It was a while ago, so I don't remember the details. > Sorry. :-/ > > Rick > > > On Fri, Oct 14, 2011 at 2:03 PM, Chowdhury, Tauf > <[email protected]>wrote: > >> ** >> Yeah, from my understanding, the way RAC works is similar to load >> balancing. >> You connect to a virtual SID like "Remedy-RAC" >> Then, based on some magical parameters, your individual DB connections get >> spread out amongst the nodes like Node1, Node2, Node3 etc... >> Now, could there be an issue with the Nodes themselves having replication >> issues? Maybe... I guess a good test would be to do some SQL queries >> directly against the nodes after determining which one of your servers are >> connecting to which node. >> That is the troubleshooting route we may take but it's late on a Friday >> and there's a slim chance I'll find any DBA help now. >> >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) on behalf of LJ >> LongWing >> *Sent:* Fri 10/14/2011 3:34 PM >> *To:* [email protected] >> *Subject:* Re: Oracle-RAC and ARS Issues? >> >> ** >> >> JD, >> >> While I have never seen these symptoms, I agree with you that it appears, >> somehow to be related with the communication method between your remedy >> server and your DB. As I understand the RAC, it’s a Clustering software, >> and if not performing properly, I could totally see problems with restarting >> and the node you were on is not the one you re-connected to. One >> troubleshooting step you could take would be to shut down all of the nodes >> of the cluster except one….work with it for awhile…then shutdown and restart >> to see if you have problems….I know it’s a bit extreme…and may not be >> feasible to your situation, but it’s something I would put on my list of ‘to >> try’ J >> >> >> >> *From:* Action Request System discussion list(ARSList) [mailto: >> [email protected]] *On Behalf Of *JD Hood >> *Sent:* Friday, October 14, 2011 1:13 PM >> *To:* [email protected] >> *Subject:* Oracle-RAC and ARS Issues? >> >> >> >> ** Having a really weird issue at a client where, when you restart the AR >> Server service (not every time, but at random nth restarts)... >> >> - Random forms fail to load in the server (won't list in client & won't >> list in the Admin tool, but T,H,B tables are still there with data) >> >> - Random fields vanish on forms >> >> - All guides (filter & active link) fail to load >> >> - could be some other probs, but we didn't look as we have our hands full >> dealing with the first three >> >> >> >> The first time this occurred, we found that the numfields value in >> ARSCHEMA table did not agree with the rowcount in the FIELD table for some >> CMDB forms (AST: forms). The problem has occurred three times over as many >> weeks and restoring the DB from backup each time it happens is not feasible >> as along term resolution -- we need to figure out the root cause. The site >> is secure and sharing logs, screenshots or webexing is not allowed, so >> troubleshooting is problematic. >> >> >> >> I mentioned the symptoms to a colleague and it prompted a vague memory of >> some issue between an earlier version of ARS and Oracle-RAC, even though the >> versions were listed as compatible. BMC support can't find any mention and >> so far (considering the site security restrictions) have only been treating >> the symptoms. BMC support seems to think the problem is running multiple >> class manager jobs at the same time, but we aren't doing that. The last time >> it happened, the system came back up with a *bunch* of corrupted forms (bad >> field counts between arschema and field tables for a variety of forms) and a >> "change pending" class manager job showed up out of nowhere -- before system >> restart, we weren't doing anything in class manager / class manager was >> idle. >> >> >> >> In trying to make sense of this, I can only imagine that ARS starts up and >> connects to the Oracle-RAC cluster in such a screwed-up fashion that it >> either retrieves (or causes RAC to return) pieces of the database from >> different points in time -OR- skips parts of the DB -OR- the Oracle-RAC >> cluster is not keeping itself in sync like we think -OR- >> <heck-if-i-know-feel-free-to-guess>. All I can say is I've never encountered >> the behavior before and it's beyond weird. >> >> >> >> Two questions: >> >> 1. Disregarding the issues I've mentioned, does anyone recall ANY (and I >> mean *any*) issues between Oracle-RAC and any version of ARS? It's the only >> clue we have at this point and I'm grasping at straws. >> >> >> >> 2. Has anybody experienced the described weirdness, regardless of ARS >> version? >> >> >> >> Thanks, >> >> JDHood >> >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ >> ------------------------------ >> This e-mail and its attachments may contain Forest Laboratories, Inc. >> proprietary information that is privileged, confidential or subject to >> copyright belonging to Forest Laboratories, Inc. This e-mail is intended >> solely for the use of the individual or entity to which it is addressed. If >> you are not the intended recipient of this e-mail, or the employee or agent >> responsible for delivering this e-mail to the intended recipient, you are >> hereby notified that any dissemination, distribution, copying or action >> taken in relation to the contents of and attachments to this e-mail is >> strictly prohibited and may be unlawful. If you have received this e-mail in >> error, please notify the sender immediately and permanently delete the >> original and any copy of this e-mail and any printout. >> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
