I am interested in this however I have a question: why not just replicate server 1 (ars) by Tarball and blow it on the other two servers and change the config to server 2 and 3 in a group and point them accordingly and say go!
I mean no need to install 2-3 times.. Just asking Sent from my iPhone so typo's or funky words can and do happen! On Oct 15, 2011, at 11:43 PM, John Doe <[email protected]> wrote: > ** > That makes sense, but wouldn't that overwrite the previous server 1 > installation in the aradmin tablespace? If it works, that would be a big > help to us because I am honestly stuck not being able to install any further. > > > To JD's case; > The hope here is that if it can be identified that the replication/failover > features of the RAC are the culprit while running arsystem. Then > configuration changes inside of Oracle can possibly (environment depending) > be made to trick arsystem into believing they do not exist. Also, the Oracle > RAC One Node version of Oracle RAC could possibly be used. > > From: Rick Cook <[email protected]> > To: [email protected] > Sent: Saturday, October 15, 2011 10:21 PM > Subject: Re: Oracle-RAC and ARS Issues? > > ** > That is the workaround; to run the installer in single server mode. > Rick > On Oct 15, 2011 8:16 PM, "John Doe" <[email protected]> wrote: > ** > 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 <[email protected]> > To: [email protected] > 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 <[email protected]> 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: [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"_ > > > _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ > _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"
