Thanks for the info Theo. One more question. Did you migrate the 3rd party pieces to 64bit as well? We are using Exchange/Outlook for our mail server so we are using the MAPI protocol for the email engine. This means we have to use the 32bit JRE. I'm wondering whether I need to use the 32bit 2.4.x Apache HTTPD or whether I can use the 64bit.
On Mon, 15 Dec 2014 21:10:37 +0200, Theo Fondse (GMail) <theo.fon...@gmail.com> wrote: >Hi Carina, > >We upgraded our "Custom-Only" 7.1/10g/Slolaris server recently to >7.6.4/11g/RedHat. > >I always suggest NOT to skip a major version when doing an upgrade, due to the >fact that BMC only supports the last 3 versions, and therefore, might not test >their software during development for upgrades from unsupported versions at >the time. (I seriously doubt that BMC would have tested a straight upgrade >from 7.1 to 7.6.04 or much less 8.0 or 8.1, due to their version support >policies). > >Before I started my current stint at the company where I am working now, they >attempted an upgrade from 7.1 to 7.6.4 and failed several times. >Even with the assistance of a local support partner, the upgrade failed and >they eventually gave up. > >The solution to the problem later turned out to be that you should not skip >any major versions and go through the installer logs to find out what went >wrong if the installer fails. > >We found a caveat with some of the AR System forms and tables which had to be >addressed manually before the upgrade in order to get the upgrade to work. > >I suggest the following steps which worked for us to do a successful upgrade >(please test it first on a development/test environment before doing this on >prod): > >1. Back up the current DB (full DB export dump). >2. Export and delete all records from the AR System User Central File form. >3. Export and delete all records from the AR System User Preference form. >4. Temporary Disable Automatic Processes (performance tuning to make >upgrade complete faster): > Escalations > Alerts > Archive > Log Files > Server Events >5. Temporary Decrease Threads count (max 2 each) to enable faster >re-caching during upgrade. >6. Shut Down AR System. >7. Verify that the Oracle 11g 64 bit client has been installed on the >server and update the tnsnames file for this client. >8. Verify that at least java 1.6 32 and 64 bit has been installed. >9. Comment out Db-Character-Set: UTF-8 parameter in ar.conf file if using >UTF-8. >10. Run the following script on Oracle (fix for SW00327170): > >CREATE TABLE SCHEMA_ARCHIVE_BACKUP > AS > SELECT SCHEMAID, ARCHIVEFROMFORM FROM SCHEMA_ARCHIVE; >COMMIT; > >UPDATE SCHEMA_ARCHIVE >SET ARCHIVEFROMFORM = NULL; >COMMIT; > >ALTER TABLE SCHEMA_ARCHIVE >MODIFY (ARCHIVEFROMFORM NUMBER (15)); >COMMIT; > >UPDATE SCHEMA_ARCHIVE >SET ARCHIVEFROMFORM = >(SELECT ARCHIVEFROMFORM >FROM SCHEMA_ARCHIVE_BACKUP >WHERE SCHEMA_ARCHIVE_BACKUP.SCHEMAID = SCHEMA_ARCHIVE.SCHEMAID); >COMMIT; > >ALTER TABLE SCHEMA_ARCHIVE >MODIFY (ARCHIVEFROMFORM NOT NULL); > > > >11. Upgrade to ARS 7.5.0 >12. Upgrade to ARS 7.6.04 SP5 >13. Upgrade to ARS 8.0 >14. Upgrade to ARS 8.1 >15. Restore original config for > Escalations > Alerts > Archive > Log Files > Server Events > Threads count >16. Import backed up records for the AR System User Central File form. >17. Import backed up records for the AR System User Preference form. > > > >HTH, > >Best Regards, >Theo > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W >Sent: 12 December 2014 22:44 >To: arslist@ARSLIST.ORG >Subject: Re: Help with upgrade path > >My suggestion > >Take a backup of the Oracle 10g data and copy/restore it to the Oracle 12c >(Your DBA could also do this with oracle DataPump). >Install 8.1 on the new server against the copy/restored data. When >installing it should ask you if you want to upgrade or start new in the >database. Choose upgrade. > (You do NOT need to have an existing set of ARS binaries on the new server > to choose upgrade as this only refers to the database data) > >Fred > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:arslist@ARSLIST.ORG] On Behalf Of Carina Burns >Sent: Friday, December 12, 2014 11:38 AM >To: arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> >Subject: Help with upgrade path > >Greetings!!! > >I am turning to you all for suggestions for an upgrade path for our ARS >system. I've contacted BMC for advice, however our support contract level is >Basic... which is also the adjective I would use to describe my current level >of customer satisfaction. > >Has anyone gone from ARS 7.1 to 8.1? How did you do it? >If you don't want to wade thru my specifics, kindly preface your reply with >TLDR before you explain your upgrade method. > >The specifics: >Our production set up is >ARS 7.1 patch 11 / Midtier7.0.01 patch 5/ Apache Tomcat 5.027 / Crystal >Reports XI running on WinSvr 2003 SP2 against an Oracle 10g last patch >database on RedHat Enterprise 4.0 > >I had thought to step thru and upgrade to 7.6 and then to 8.1 but was advised >after opening a support ticket that since we have custom forms only and are >not using ITSM or any other BMC app, we could go straight to 8.1 from 7.1. > >The compatibility matrix lists the minimums but states that any newer versions >are supported for OS and database. Since hardware only gets upgraded when >bond money exists about every 5-7 years at our school district, I asked for >the latest/greatest. I cleared my choices/plan with support but since it was >going to take a while to get the servers, I closed the ticket saying I would >open another once I had my gear. > >My new servers are virtual; a WinSvr2012 R2 and a Oracle Linux 6 box. I put >Oracle 12c on as the database. > >I had thought to install ARS 7.1 as a "new install", delete the data, copy the >production 10g AR schema over to the 12c user, then run 8.1 as an upgrade. >That's essentially how I did it the last time and support confirmed that a >number of people run their upgrades that way. But Oh-Oh! 7.1 is 32bit and >doesn't want to install on my Win 64bit OS...Maybe both support and I missed >that little hitch or perhaps I misunderstood. Anyhow, I opened a new ticket >and asked if I could do the same thing but with 8.1 instead. In other words, >install ARS 8.1 as a new install, delete the data, copy over the 10g AR schema >to the 12c user, then run 8.1 again as an upgrade. > >Here are the answers I got back on my ticket (paraphrased): >A) 7.1 isn't supported, >B) I was free to experiment using the new install/delete data/move schema/run >upgrade method but it may not work >C) I can try to install 8.1 as new and use the Migrator to move over all my >custom forms >D) Contract professional services and pay BMC to help with my upgrade > >Option D isn't going to happen. So I am left with options B and C. The >analyst on the first support ticket didn't think Migrator would be necessary >since we aren't using ITSM. Thoughts on that (While I go read the migrator >documentation)? Comments on option B? > >Thanks in advance! >Carina > > > > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ><http://www.arslist.org> "Where the Answers Are, and have been for 20 years" > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >"Where the Answers Are, and have been for 20 years" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
