JD,
We have an RFE on file with BMC for the 7.6.04 installer against Oracle RAC. They have duplicated the issue. AR system installs fine on server 1 but when going to server 2 in order to install AR system in a server grouping. The installer completes but there are "weird" issues. The plugin server fails and when trying to get to the server information screen of AR System that too fails (because it is a plugin server). Because of this, it is impossible to license the server and continue with the install after the AR System install (server 2). Thus the RFE. This isn't exactly like your problem but it is another case of "weird" in Oracle RAC. Installs have always been very difficult on Oracle RAC. I found on the newer versions, the installers choke on SID names. The installers also seem to want to go through only one node of the rack instead of the RAC name. They also have a hard time coping with the differences in syntax in the tnsnames.ora file upon creation through the installer. I think Oracle RAC is a toughy :-). I know I wish I knew more about Oracle RAC. I know this might be a long shot but are you able to disconnect from the RAC then reconnect through only one node of the RAC? Possibly, it could be the Oracle RAC failover capabilities that might be confusing ARSystem. It could be causing a weird phenomenon in the cache. Is it possible to make the Oracle instance as close to a single Oracle instance as you can get? If you can get it to resemble a single node DB (i.e. take node 2 of the RAC offline start up the instance as simple as possible and just with node 1's connect info). Then alter tnsnames.ora file to connect to and through that node only. Possibly, then starting arsystem. Then test and see. I figure this probably isn't a complete solution but hopefully it might get you somewhere down the path. ________________________________ From: JD Hood <hood...@gmail.com> To: arslist@ARSLIST.ORG Sent: Friday, October 14, 2011 7:02 PM Subject: Re: Oracle-RAC and ARS Issues? ** Hey Joe, BMC Support has been briefed. Also given the RAC clue. But with the site security restrictions, they didn't seem too interested in researching too deep for us. Example -- we know there was some issue with Oracle RAC and a previous ARS version, but they advised they could find no mention of any issue with RAC. So, BMC support has probably done all they are going to do. Hence, we are reaching out to the ARS List. Thanks, JDHood On Fri, Oct 14, 2011 at 5:51 PM, Joe Martin D'Souza <jdso...@shyle.net> wrote: ** > >BMC support once gave me a script (SQL) to check for inconsistencies within the database when we had some container related issues.. > >This script verifies such problems and the commented lines in the script tells you what you should expect for a consistent result. You may want to ask them for it and use it to further diagnose your problem. > >Joe >From: JD Hood >Sent: Friday, October 14, 2011 3:13 PM >Newsgroups: public.remedy.arsystem.general >To: arslist@ARSLIST.ORG >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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
