Oracle-RAC and ARS Issues?

2011-10-14 Thread JD Hood
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

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread Chowdhury, Tauf
cture - Service Management Office: 631.858.7765 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Friday, October 14, 2011 3:13 PM To: arslist@ARSLIST.ORG Subject: Oracle-RAC and ARS Issues? ** Having a really weird issue at a client

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread John Sundberg
Sounds like a creepy problem. I would look into "disk problems". -John On Oct 14, 2011, at 2:13 PM, JD Hood wrote: ** 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 s

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread LJ LongWing
e 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:arslist@ARSLIST.ORG] On Behalf Of JD Hood Sent: Friday, October 14, 2011 1:13 PM To: arslist@ARSLIST.ORG Subject: Oracle-RAC and AR

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread Chowdhury, Tauf
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: arslist@ARSLIST.ORG Subject: Re: Oracle-RAC and ARS Issues? ** JD, While I have nev

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread Rick Cook
nd > 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:* arslist@ARSLIST.ORG > *Subject:* Re: Oracle-RAC and ARS Issues? >

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread Grooms, Frederick W
, Tauf Sent: Friday, October 14, 2011 4:04 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle-RAC and ARS Issues? ** 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 individu

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread Joe Martin D'Souza
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

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread JD Hood
t; 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) o

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread JD Hood
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: > arslist@ARSLIST.ORG] *On Behalf Of *JD Hood > *Sent:* Friday, October 14, 2011 1:1

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread JD Hood
blem. > > 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

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread Patrick Zandi
I would export tables Import into another db , hook up an ars and clean it up. Sent from my iPhone so typo's or funky words can and do happen! On Oct 14, 2011, at 3:13 PM, JD Hood wrote: > ** Having a really weird issue at a client where, when you restart the AR > Server service (not every ti

Re: Oracle-RAC and ARS Issues?

2011-10-14 Thread John Peto
Hi, Do you have affinity set between oracle client / db (think this is just tns syntax), or are not using a load balanced VIP for the SID? TNS affinity causes app servers to prefer a particular db node if it's available, can make troubleshooting easier and would mean that all admin work is car

Re: Oracle-RAC and ARS Issues?

2011-10-15 Thread JD Hood
Hi John, We're not quite sure where the problem is coming from, but the discrepancies between ARSCHEMA numfields and the corresponding rowcounts in FIELD is an actual data discrepancy. The DB is not corrupted and appears quite readable, but ARS data (the field counts, the way views are displayed w

Re: Oracle-RAC and ARS Issues?

2011-10-15 Thread John Doe
d see.  I figure this probably isn't a complete solution but hopefully it might get you somewhere down the path. From: JD Hood To: arslist@ARSLIST.ORG Sent: Friday, October 14, 2011 7:02 PM Subject: Re: Oracle-RAC and ARS Issues? ** Hey Joe, BMC Suppo

Re: Oracle-RAC and ARS Issues?

2011-10-15 Thread Rick Cook
a complete solution but hopefully it might get you > somewhere down the path. > > > > ---------- > *From:* JD Hood > *To:* arslist@ARSLIST.ORG > *Sent:* Friday, October 14, 2011 7:02 PM > *Subject:* Re: Oracle-RAC and ARS Issues? > > ** Hey Joe

Re: Oracle-RAC and ARS Issues?

2011-10-15 Thread John Doe
Sent: Saturday, October 15, 2011 10:16 PM Subject: Re: Oracle-RAC and ARS Issues? ** 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 s

Re: Oracle-RAC and ARS Issues?

2011-10-15 Thread John Doe
ly be used.  From: Rick Cook To: arslist@ARSLIST.ORG 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&qu

Re: Oracle-RAC and ARS Issues?

2011-10-15 Thread Patrick Zandi
y (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 > To: arslist@ARSLIST.ORG > Sent: Saturday, October 15, 2011 10:21 PM > Subject: Re: O

Re: Oracle-RAC and ARS Issues?

2011-10-16 Thread John Peto
Hi - I did an upgrade from 7.01 to 7.6.3 in a server group and the second install always had to fail once (can't remember the reason) For the licensing just add the licence for server 2 after installing server 1, as the licences are all in the database - 2 should then install pre-licensed. It w

Re: Oracle-RAC and ARS Issues?

2011-10-16 Thread John Peto
Hi JD, I think it's got to be something mis-configured, it's obviously not random as it's only affecting the system-data as you've described.. I think for more help you need to explain the config. How's the tns setup? Is it a server group? Is there a loadbalancer for the db? How many app serv

Re: Oracle-RAC and ARS Issues?

2011-10-16 Thread JD Hood
Apologies for not detailing the env further (can't ya'll read my mind?) So... Three environments, Prod, Test, Dev. All single servers, no AR Server groups involved. All are ARS 7.1, CMDB 2.01, ITSM 6.x on ORA 10g Yes, the versions are old and 7.1 is unsupported, but it was working just fine unt

Re: Oracle-RAC and ARS Issues?

2011-10-16 Thread John Peto
Hi JD, I'd say RAC with one node running is very close to a stand alone db... Post restore I presume if you don't make any admin changes - the problem doesn't happen? If that's the case then it's got to be worth putting SQL logging whilst you make changes, and until the problem occurs. Either

Re: Oracle-RAC and ARS Issues?

2011-10-16 Thread Joe Martin D'Souza
rom one of them? Its unlikely anyone would do that mistake, but not an impossibility.. Joe -Original Message- From: John Peto Sent: Sunday, October 16, 2011 3:22 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Oracle-RAC and ARS Issues? Hi JD, I'

Re: Oracle-RAC and ARS Issues?

2011-10-17 Thread Garrison, Sean (Norcross)
nvironment. Thanks, Sean -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Joe Martin D'Souza Sent: Sunday, October 16, 2011 4:13 PM To: arslist@ARSLIST.ORG Subject: Re: Oracle-RAC and ARS Issues? John's note struck a

Re: Oracle-RAC and ARS Issues?

2011-10-17 Thread Chowdhury, Tauf
] On Behalf Of Garrison, Sean (Norcross) Sent: Monday, October 17, 2011 9:40 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle-RAC and ARS Issues? We have had this issue before with the oracle RAC. There is a setting in oracle called "max_commit_propagation_delay" that must be set to zer