JD, Interesting timing for this post. I have a consultant working in our non-prod environment right now noticing a strange issue and we are on RAC. Basically, we have 2 servers in a server group. The one server is fine... but the primary is getting timeout errors and when we try to open filters on it, we get messages stating that the filter is referencing data that doesn't exist.
I'll let you know what we find. As it's a non-prod environment, we may have more room to troubleshoot. Tauf Chowdhury | Forest Laboratories, Inc. Service Portfolio Manager Infrastructure - Service Management Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of JD Hood Sent: Friday, October 14, 2011 3: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"_ ********************************************************************** 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. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
