Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Hi, NO NO NO!!! You can not do the conversion on the database level. There are all manner of counters and stuff that counts bytes instead of characters, and your system will become corrupt. If you do not have any character that will convert to multibyte in your application, for example on a field label, you might possibly get it to work. As for the data, it will work to some extent, but data might have swollen into more bytes than you allow in certain fields without you knowing about it. This will give users problems when changing old records. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Note:In BMC Remedy AR System 6.x, it is possible to run a BMC Remedy AR System server in non-Unicode mode with a Unicode database. In BMC Remedy AR System 7.x and later, this type of configuration is not supported. I have tried in my test system prior to upgrade and it worked well. 01. export the database dump exp system/admin tablespaces=ARSYSTEM file=ARSYSTEM.dmp 02. Import again within the database which is configured as unicode instance imp system/admin tablespaces=arsystem file=arsystem.dmp FROMUSER=ARADMIN TOUSER=ARADMIN When you import it on unicode instance, it will do charset conversion Export file created by EXPORT:V10.02.01 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) 03. once you able to get the db import, run the 7.1 installer and select unicode this time 04. Perform upgrade install of 7.6.04. Hope this helps ~ Vaibhav On Tue, Feb 12, 2013 at 10:56 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: What do you have on the ARS server for the language environment variables? LANG, LC_ALL, NLS_LANG -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Tuesday, February 12, 2013 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hi Kiran, I'm afraid I don't quite understand your suggestions, please note our current frame: given that 1) we need to upgrade from 7.1 to 7.6.04 but we need to stay on our current app server machines and our current db machines 2) our current production ARS 7.1 installation is non UNICODE and current oracle db is UNICODE and everything has always been running fine so far what's puzzling for us is that it seems that the upgrade from 7.1 to 7.6.04 (running the installer) is forcing us to convert our ARS app server installation from non UNICODE to UNICODE, while we would like to avoid that because it would imply extra costs, time, maybe machines etc.. Answers from BMC on this topic so far have been that either we convert our oracle instance from UNICODE to non UNICODE to continue with the upgrade, OR we do a new fresh install of ARS 7.6.04 on a new db instance, in UNICODE, and then move objects and data from current servers to new instances/servers. Both ways are hardly viable for us, due to a number of reasons/constraints, that's why we're seeking advise here thanks for your help Kind Regards, Antonello Monizza -Original Message- On Tue, Feb 12, 2013 at 4:45 PM, Hullule, Kiran wrote: ** The option that I can think of is (to convert your non Unicode data to Unicode ) use remedy migrator tool and migrate your non unicode server to Unicode server (making sure you have identical setup ready )- 7604 as that of 7.1 when it comes to the applications. OR another option is use remedy migrator between existing 7.1 non Unicode to new 7.1 unicode server , this will take care of all characters , localized data conversion, then upgrade ARS only to 7604 - run BPCU tool to identify your customization and convert them into overlay. Once this is done think of rest of the application upgrade. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 10:39 PM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Hi, we simply cannot afford copying the data from current installation to a new one because 1) we cannot stop our ARS based applications in production environment, which are used worldwide 24/24, for more than 24 hours, and since we have hundreds of custom tables with millions of data records we guess it would take days to do the job, even using tools like RRRChive or BMC DDM-Delta Data Migration. 2) we are not going to change the application and db servers, they have to stay the same that we currently use 3) finally, even if we used your suggested approach, we would be blocked already at step 1 just because of the UNICODE error any other ideas? thanks Antonello Monizza On Mon, Feb 11, 2013 at 8:51 PM, patchsk vamsi...@gmail.com wrote: Why is option 2, not feasible? I think that is the most cleanest way. There might be some hardwork for copying the data but you can use tools like (RRRChive, BMC DDM-Delta Data Migration). Yes there is some learning curve to understand those tools but once you spend a day or two to test various scenarios the copying of data is pretty much automated. Just execute a command and it does everything for you. I think what you could do is: 1. First run the upgrade on ARS7.1(Just the ARS no Email,ARDBC etc..) 2. Convert the objects to custom or overly as needed. 3. Run the installer again to upgrade remaining components. 4. Readjust overlays, custom objects as needed. 5. Take a full export of all the def files. 6. Now build a new ARS with OOTB objects with no sample data, just plain vanilla remedy. 7. Import your objects from Step5 into the new vanilla environment. 8. Run the (RRRChive or BMC DDM) to copy the data from 7.1 to new version. 9. Test all your integrations and applications. 10. Fix all the bugs in the new environment. 11. Rerun (RRRChive or BMC DDM) to copy the data from 7.1(PROD) to new version env. 12. Cut over the new environment as your production. 13. Rebuild your dev,test environment from a copy of new production. We have actually upgraded from 7.1 to 8.x and things seems to be fine so far. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Hi, The idea with RRR|Chive would be to first do a copy of the production while it is still in use by your users. This might take days or even several weeks. During this time, the impact of the production would be next to none. When you are ready to do the final cutover, this will take no more than an hour or two to do, while the last small changes are synchronized. This would be your only downtime. If you need to run production on your current database, you will also need additional time to copy your temp database into the real database after the final SYNCTOTARGET. The Unicode translation will all be handled by the AR API, so that is not a problem. If you have a lot of multy-byte characters in your database, you may encounter situations where data does not fit in a field when translated from 8-bit to multibyte. But with the above aproach these things can be attended to in a leasurly way, without additional downtime. Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011) Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10/11/12): * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. Find these products, and many free tools and utilities, at http://rrr.se. Hi, we simply cannot afford copying the data from current installation to a new one because 1) we cannot stop our ARS based applications in production environment, which are used worldwide 24/24, for more than 24 hours, and since we have hundreds of custom tables with millions of data records we guess it would take days to do the job, even using tools like RRRChive or BMC DDM-Delta Data Migration. 2) we are not going to change the application and db servers, they have to stay the same that we currently use 3) finally, even if we used your suggested approach, we would be blocked already at step 1 just because of the UNICODE error any other ideas? thanks Antonello Monizza On Mon, Feb 11, 2013 at 8:51 PM, patchsk vamsi...@gmail.com wrote: Why is option 2, not feasible? I think that is the most cleanest way. There might be some hardwork for copying the data but you can use tools like (RRRChive, BMC DDM-Delta Data Migration). Yes there is some learning curve to understand those tools but once you spend a day or two to test various scenarios the copying of data is pretty much automated. Just execute a command and it does everything for you. I think what you could do is: 1. First run the upgrade on ARS7.1(Just the ARS no Email,ARDBC etc..) 2. Convert the objects to custom or overly as needed. 3. Run the installer again to upgrade remaining components. 4. Readjust overlays, custom objects as needed. 5. Take a full export of all the def files. 6. Now build a new ARS with OOTB objects with no sample data, just plain vanilla remedy. 7. Import your objects from Step5 into the new vanilla environment. 8. Run the (RRRChive or BMC DDM) to copy the data from 7.1 to new version. 9. Test all your integrations and applications. 10. Fix all the bugs in the new environment. 11. Rerun (RRRChive or BMC DDM) to copy the data from 7.1(PROD) to new version env. 12. Cut over the new environment as your production. 13. Rebuild your dev,test environment from a copy of new production. We have actually upgraded from 7.1 to 8.x and things seems to be fine so far. ___ 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
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
The option that I can think of is (to convert your non Unicode data to Unicode ) use remedy migrator tool and migrate your non unicode server to Unicode server (making sure you have identical setup ready )- 7604 as that of 7.1 when it comes to the applications. OR another option is use remedy migrator between existing 7.1 non Unicode to new 7.1 unicode server , this will take care of all characters , localized data conversion, then upgrade ARS only to 7604 - run BPCU tool to identify your customization and convert them into overlay. Once this is done think of rest of the application upgrade. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 10:39 PM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following error: The database is configured for UNICODE but your system LANG variable is set to C You must change your LANG variable to a supported UNICODE language before you can complete this installation Now: 1) our current ARS 7.1 non UNICODE installation has been always running without any problem on a UNICODE Oracle db 2) our idea is to avoid all the complications involved in transforming our ARS installation into a UNICODE ARS, mostly because we realized in the past that it wasn't possible to change ARS from non UNICODE to UNICODE during the execution of the ARS 7.1 upgrade scipt, and BMC told us to do a fresh new installation and data exp/imp instead, which is not feasible for us We just opened a ticket to BMC and they told us that the upgrade from Non-Unicode to Unicode environment and Unicode to non-Unicode is not supported from ARS 7.5 onward, and that we should tell our DBA to change the database to non-Unicode to proceed with the ARS 7.6 upgrade Again, for a number of reasons we cannot change our DB to non UNICODE. How should we proceed now? Any tips? Thanks a lot in advance Kind Regards, Antonello Monizza _ARSlist: 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
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Hi Kiran, I'm afraid I don't quite understand your suggestions, please note our current frame: given that 1) we need to upgrade from 7.1 to 7.6.04 but we need to stay on our current app server machines and our current db machines 2) our current production ARS 7.1 installation is non UNICODE and current oracle db is UNICODE and everything has always been running fine so far what's puzzling for us is that it seems that the upgrade from 7.1 to 7.6.04 (running the installer) is forcing us to convert our ARS app server installation from non UNICODE to UNICODE, while we would like to avoid that because it would imply extra costs, time, maybe machines etc.. Answers from BMC on this topic so far have been that either we convert our oracle instance from UNICODE to non UNICODE to continue with the upgrade, OR we do a new fresh install of ARS 7.6.04 on a new db instance, in UNICODE, and then move objects and data from current servers to new instances/servers. Both ways are hardly viable for us, due to a number of reasons/constraints, that's why we're seeking advise here thanks for your help Kind Regards, Antonello Monizza On Tue, Feb 12, 2013 at 4:45 PM, Hullule, Kiran kiran_hull...@bmc.comwrote: ** The option that I can think of is (to convert your non Unicode data to Unicode ) use remedy migrator tool and migrate your non unicode server to Unicode server (making sure you have identical setup ready )– 7604 as that of 7.1 when it comes to the applications. OR another option is use remedy migrator between existing 7.1 non Unicode to new 7.1 unicode server , this will take care of all characters , localized data conversion, then upgrade ARS only to 7604 – run BPCU tool to identify your customization and convert them into overlay. Once this is done think of rest of the application upgrade. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Antonio Monizza *Sent:* Monday, February 11, 2013 10:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** ** ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following error: The database is configured for UNICODE but your system LANG variable is set to C You must change your LANG variable to a supported UNICODE language before you can complete this installation Now: 1) our current ARS 7.1 non UNICODE installation has been always running without any problem on a UNICODE Oracle db 2) our idea is to avoid all the complications involved in transforming our ARS installation into a UNICODE ARS, mostly because we realized in the past that it wasn't possible to change ARS from non UNICODE to UNICODE during the execution of the ARS 7.1 upgrade scipt, and BMC told us to do a fresh new installation and data exp/imp instead, which is not feasible for us We just opened a ticket to BMC and they told us that the upgrade from Non-Unicode to Unicode environment and Unicode to non-Unicode is not supported from ARS 7.5 onward, and that we should tell our DBA to change the database to non-Unicode to proceed with the ARS 7.6 upgrade Again, for a number of reasons we cannot change our DB to non UNICODE. How should we proceed now? Any tips? Thanks a lot in advance Kind Regards, Antonello Monizza _ARSlist: Where the Answers Are and have been for 20 years_ _ARSlist: 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
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
What do you have on the ARS server for the language environment variables? LANG, LC_ALL, NLS_LANG -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Tuesday, February 12, 2013 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hi Kiran, I'm afraid I don't quite understand your suggestions, please note our current frame: given that 1) we need to upgrade from 7.1 to 7.6.04 but we need to stay on our current app server machines and our current db machines 2) our current production ARS 7.1 installation is non UNICODE and current oracle db is UNICODE and everything has always been running fine so far what's puzzling for us is that it seems that the upgrade from 7.1 to 7.6.04 (running the installer) is forcing us to convert our ARS app server installation from non UNICODE to UNICODE, while we would like to avoid that because it would imply extra costs, time, maybe machines etc.. Answers from BMC on this topic so far have been that either we convert our oracle instance from UNICODE to non UNICODE to continue with the upgrade, OR we do a new fresh install of ARS 7.6.04 on a new db instance, in UNICODE, and then move objects and data from current servers to new instances/servers. Both ways are hardly viable for us, due to a number of reasons/constraints, that's why we're seeking advise here thanks for your help Kind Regards, Antonello Monizza -Original Message- On Tue, Feb 12, 2013 at 4:45 PM, Hullule, Kiran wrote: ** The option that I can think of is (to convert your non Unicode data to Unicode ) use remedy migrator tool and migrate your non unicode server to Unicode server (making sure you have identical setup ready )- 7604 as that of 7.1 when it comes to the applications. OR another option is use remedy migrator between existing 7.1 non Unicode to new 7.1 unicode server , this will take care of all characters , localized data conversion, then upgrade ARS only to 7604 - run BPCU tool to identify your customization and convert them into overlay. Once this is done think of rest of the application upgrade. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 10:39 PM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following error: The database is configured for UNICODE but your system LANG variable is set to C You must change your LANG variable to a supported UNICODE language before you can complete this installation Now: 1) our current ARS 7.1 non UNICODE installation has been always running without any problem on a UNICODE Oracle db 2) our idea is to avoid all the complications involved in transforming our ARS installation into a UNICODE ARS, mostly because we realized in the past that it wasn't possible to change ARS from non UNICODE to UNICODE during the execution of the ARS 7.1 upgrade scipt, and BMC told us to do a fresh new installation and data exp/imp instead, which is not feasible for us We just opened a ticket to BMC and they told us that the upgrade from Non-Unicode to Unicode environment and Unicode to non-Unicode is not supported from ARS 7.5 onward, and that we should tell our DBA to change the database to non-Unicode to proceed with the ARS 7.6 upgrade Again, for a number of reasons we cannot change our DB to non UNICODE. How should we proceed now? Any tips? Thanks a lot in advance Kind Regards, Antonello Monizza ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Note:In BMC Remedy AR System 6.x, it is possible to run a BMC Remedy AR System server in non-Unicode mode with a Unicode database. In BMC Remedy AR System 7.x and later, this type of configuration is not supported. I have tried in my test system prior to upgrade and it worked well. 01. export the database dump exp system/admin tablespaces=ARSYSTEM file=ARSYSTEM.dmp 02. Import again within the database which is configured as unicode instance imp system/admin tablespaces=arsystem file=arsystem.dmp FROMUSER=ARADMIN TOUSER=ARADMIN When you import it on unicode instance, it will do charset conversion Export file created by EXPORT:V10.02.01 via conventional path import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) 03. once you able to get the db import, run the 7.1 installer and select unicode this time 04. Perform upgrade install of 7.6.04. Hope this helps ~ Vaibhav On Tue, Feb 12, 2013 at 10:56 AM, Grooms, Frederick W frederick.w.gro...@xo.com wrote: What do you have on the ARS server for the language environment variables? LANG, LC_ALL, NLS_LANG -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Tuesday, February 12, 2013 11:11 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hi Kiran, I'm afraid I don't quite understand your suggestions, please note our current frame: given that 1) we need to upgrade from 7.1 to 7.6.04 but we need to stay on our current app server machines and our current db machines 2) our current production ARS 7.1 installation is non UNICODE and current oracle db is UNICODE and everything has always been running fine so far what's puzzling for us is that it seems that the upgrade from 7.1 to 7.6.04 (running the installer) is forcing us to convert our ARS app server installation from non UNICODE to UNICODE, while we would like to avoid that because it would imply extra costs, time, maybe machines etc.. Answers from BMC on this topic so far have been that either we convert our oracle instance from UNICODE to non UNICODE to continue with the upgrade, OR we do a new fresh install of ARS 7.6.04 on a new db instance, in UNICODE, and then move objects and data from current servers to new instances/servers. Both ways are hardly viable for us, due to a number of reasons/constraints, that's why we're seeking advise here thanks for your help Kind Regards, Antonello Monizza -Original Message- On Tue, Feb 12, 2013 at 4:45 PM, Hullule, Kiran wrote: ** The option that I can think of is (to convert your non Unicode data to Unicode ) use remedy migrator tool and migrate your non unicode server to Unicode server (making sure you have identical setup ready )- 7604 as that of 7.1 when it comes to the applications. OR another option is use remedy migrator between existing 7.1 non Unicode to new 7.1 unicode server , this will take care of all characters , localized data conversion, then upgrade ARS only to 7604 - run BPCU tool to identify your customization and convert them into overlay. Once this is done think of rest of the application upgrade. -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 10:39 PM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following error: The database is configured for UNICODE but your system LANG variable is set to C You must change your LANG variable to a supported UNICODE language before you can complete this installation Now: 1) our current ARS 7.1 non UNICODE installation has been always running without any problem on a UNICODE Oracle db 2) our idea is to avoid all the complications involved in transforming our ARS installation into a UNICODE ARS, mostly because we realized in the past that it wasn't possible to change ARS from non UNICODE to UNICODE during the execution of the ARS 7.1 upgrade scipt, and BMC told us to do a fresh new installation and data exp/imp instead, which is not feasible for us We just opened a ticket to BMC and they told us that the upgrade from Non-Unicode to Unicode environment and Unicode to non-Unicode is not supported from ARS 7.5 onward, and that we should tell our DBA to change the database to non
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Hi All, My advice is to use something from RRR. I cannot remember its name, but do not use BMC Migrator. I've started with Migrator than used RRR for daily syncs. In the end it proves that we have correctly synchronized last records/thickets, while the first records/thickets where out of sync. Daniel From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 7:10 PM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following error: The database is configured for UNICODE but your system LANG variable is set to C You must change your LANG variable to a supported UNICODE language before you can complete this installation Now: 1) our current ARS 7.1 non UNICODE installation has been always running without any problem on a UNICODE Oracle db 2) our idea is to avoid all the complications involved in transforming our ARS installation into a UNICODE ARS, mostly because we realized in the past that it wasn't possible to change ARS from non UNICODE to UNICODE during the execution of the ARS 7.1 upgrade scipt, and BMC told us to do a fresh new installation and data exp/imp instead, which is not feasible for us We just opened a ticket to BMC and they told us that the upgrade from Non-Unicode to Unicode environment and Unicode to non-Unicode is not supported from ARS 7.5 onward, and that we should tell our DBA to change the database to non-Unicode to proceed with the ARS 7.6 upgrade Again, for a number of reasons we cannot change our DB to non UNICODE. How should we proceed now? Any tips? Thanks a lot in advance Kind Regards, Antonello Monizza _ARSlist: Where the Answers Are and have been for 20 years_ _ Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration, France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci This message and its attachments may contain confidential or privileged information that may be protected by law; they should not be distributed, used or copied without authorization. If you have received this email in error, please notify the sender and delete this message and its attachments. As emails may be altered, France Telecom - Orange shall not be liable if this message was modified, changed or falsified. Thank you. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
As Misi stated RRRChive will do the conversion. Can you add a ARSYSTEM2 database to your dev environment? If so, you may want to do this and use RRRChive. Once ARSYSTEM2 is at the proper coding you can then run a synctotarget with prod and the new db in case your dev db is not synced with prod. I would then run the installers. If you use RRRChive after the upgrade to sync the new systems with prod be careful with your configurations since you are going from 7.1 to 7.6.04. The DBA's don't have a way to do this from the database level? This is only the beginning of your headaches. Good Luck, Brian From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Daniel Condrea Sent: Wednesday, February 13, 2013 1:52 AM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hi All, My advice is to use something from RRR. I cannot remember its name, but do not use BMC Migrator. I've started with Migrator than used RRR for daily syncs. In the end it proves that we have correctly synchronized last records/thickets, while the first records/thickets where out of sync. Daniel From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG mailto:arslist@ARSLIST.ORG] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 7:10 PM To: mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue ** Hello listers, we're upgrading an ARS 7.1 patch 7 non UNICODE on AIX 5.3 against an Oracle DB with UTF8 character set to ARS 7.6.04 SP4 always on Oracle with UTF8 As a first step we're doing the upgrade on our dev environment, then we'll proceed with test env and finally with prod During the installation process, after the Type of Installation (Upgrade, Overwrite, Server group) step, for which we selected the Upgrade option, the Installer gave us the following error: The database is configured for UNICODE but your system LANG variable is set to C You must change your LANG variable to a supported UNICODE language before you can complete this installation Now: 1) our current ARS 7.1 non UNICODE installation has been always running without any problem on a UNICODE Oracle db 2) our idea is to avoid all the complications involved in transforming our ARS installation into a UNICODE ARS, mostly because we realized in the past that it wasn't possible to change ARS from non UNICODE to UNICODE during the execution of the ARS 7.1 upgrade scipt, and BMC told us to do a fresh new installation and data exp/imp instead, which is not feasible for us We just opened a ticket to BMC and they told us that the upgrade from Non-Unicode to Unicode environment and Unicode to non-Unicode is not supported from ARS 7.5 onward, and that we should tell our DBA to change the database to non-Unicode to proceed with the ARS 7.6 upgrade Again, for a number of reasons we cannot change our DB to non UNICODE. How should we proceed now? Any tips? Thanks a lot in advance Kind Regards, Antonello Monizza _ARSlist: Where the Answers Are and have been for 20 years_ _ Ce message et ses pieces jointes peuvent contenir des informations confidentielles ou privilegiees et ne doivent donc pas etre diffuses, exploites ou copies sans autorisation. Si vous avez recu ce message par erreur, veuillez le signaler a l'expediteur et le detruire ainsi que les pieces jointes. Les messages electroniques etant susceptibles d'alteration, France Telecom - Orange decline toute responsabilite si ce message a ete altere, deforme ou falsifie. Merci This message and its attachments may contain confidential or privileged information that may be protected by law; they should not be distributed, used or copied without authorization. If you have received this email in error, please notify the sender and delete this message and its attachments. As emails may be altered, France Telecom - Orange shall not be liable if this message was modified, changed or falsified. Thank you. _ARSlist: 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
Re: Upgrade ARS 7.1 to ARS 7.6.04 SP4 - UNICODE issue
Why is option 2, not feasible? I think that is the most cleanest way. There might be some hardwork for copying the data but you can use tools like (RRRChive, BMC DDM-Delta Data Migration). Yes there is some learning curve to understand those tools but once you spend a day or two to test various scenarios the copying of data is pretty much automated. Just execute a command and it does everything for you. I think what you could do is: 1. First run the upgrade on ARS7.1(Just the ARS no Email,ARDBC etc..) 2. Convert the objects to custom or overly as needed. 3. Run the installer again to upgrade remaining components. 4. Readjust overlays, custom objects as needed. 5. Take a full export of all the def files. 6. Now build a new ARS with OOTB objects with no sample data, just plain vanilla remedy. 7. Import your objects from Step5 into the new vanilla environment. 8. Run the (RRRChive or BMC DDM) to copy the data from 7.1 to new version. 9. Test all your integrations and applications. 10. Fix all the bugs in the new environment. 11. Rerun (RRRChive or BMC DDM) to copy the data from 7.1(PROD) to new version env. 12. Cut over the new environment as your production. 13. Rebuild your dev,test environment from a copy of new production. We have actually upgraded from 7.1 to 8.x and things seems to be fine so far. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: Upgrade ARS 7.1 to ARS 7.6.04
Hi, The 11g client donot work properly, with the Oracle 10g R2 Server. In a recent up gradation, i have faced the same issue, and was forced to degrade the client version to 10g R2 client. It is mentioned in the Oracle site (as far as I remember) that the server and clients should be in the same version, but release doesnot matter. Thanks, Shiju On Wed, Apr 4, 2012 at 6:56 AM, jaya munjal jaya_mun...@yahoo.com wrote: ** Frederick We are on Unix and know we need a 64 bit Oracle 11g client. But wanted to check if there are any issues that people have faced using 11g client with 10g server. As BMC support is saying that we would have to test ourselves if 11g client is fully compatible with 10g server Regards Jaya -- *From:* Grooms, Frederick W frederick.w.gro...@xo.com *To:* arslist@ARSLIST.ORG *Sent:* Wednesday, April 4, 2012 12:55 AM *Subject:* Re: Upgrade ARS 7.1 to ARS 7.6.04 ** What OS are you on? For unix/Linux ARS 7.6.04 requires the 64 bit Oracle 11g client which will work with the 10g server. Also I am with you that you never want to do both a DB upgrade and an application upgrade at the same time. Fred *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *jaya munjal *Sent:* Tuesday, April 03, 2012 1:57 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards -- *From:* Easter, David david_eas...@bmc.com *To:* arslist@ARSLIST.ORG *Sent:* Wednesday, April 4, 2012 12:18 AM *Subject:* Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g *Oracle 10g Release 2 (10.2.0)* In July 2005 http://www.orafaq.com/wiki/2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010 http://www.orafaq.com/wiki/2010(First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011 http://www.orafaq.com/wiki/2011) Extended Support Ends: 31-Jul-2013 http://www.orafaq.com/wiki/2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. *From:* Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] *On Behalf Of *jaya munjal *Sent:* Tuesday, April 03, 2012 11:35 AM *To:* arslist@ARSLIST.ORG *Subject:* Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ -- Thanks and Regards, Shiju John ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Upgrade ARS 7.1 to ARS 7.6.04
We have been using the Oracle 11g client against a 10g r2 (10.2.0.3) server with no problems. Just set up the connection as a remote DB server (even if it is on the same server) using TWO_TASK and SERVICE_NAME or SID. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 10:57 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Frederick We are on Unix and know we need a 64 bit Oracle 11g client. But wanted to check if there are any issues that people have faced using 11g client with 10g server. As BMC support is saying that we would have to test ourselves if 11g client is fully compatible with 10g server Regards Jaya From: Grooms, Frederick W To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:55 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** What OS are you on? For unix/Linux ARS 7.6.04 requires the 64 bit Oracle 11g client which will work with the 10g server. Also I am with you that you never want to do both a DB upgrade and an application upgrade at the same time. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 1:57 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards From: Easter, David david_eas...@bmc.commailto:david_eas...@bmc.com To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:18 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005http://www.orafaq.com/wiki/2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010http://www.orafaq.com/wiki/2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011http://www.orafaq.com/wiki/2011) Extended Support Ends: 31-Jul-2013http://www.orafaq.com/wiki/2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Upgrade ARS 7.1 to ARS 7.6.04
While that is recommended by Oracle (and perhaps all other DB vendors), it is not always possible to do that. Applications (not just Remedy) that depend on a vendor database, are designed to connect and communicate with the database using a client library. So when that client library is upgraded, the application may no longer be compatible with the underlying DB. Client libraries of a DB on the other hand are generally always compatible for at least one version backwards. I would update client libraries with as much care as upgrading the underlying DB, and not just do it because the underlying DB is compatible with the application, but not its client of that same version.. The upgrade problem you had must have been specific to that particular upgrade script if I was you, I would raise it as a defect as the upgrade script was perhaps deficient to not handle the previous database client libraries.. Joe From: Shiju John Sent: Wednesday, April 04, 2012 8:55 AM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi, The 11g client donot work properly, with the Oracle 10g R2 Server. In a recent up gradation, i have faced the same issue, and was forced to degrade the client version to 10g R2 client. It is mentioned in the Oracle site (as far as I remember) that the server and clients should be in the same version, but release doesnot matter. Thanks, Shiju On Wed, Apr 4, 2012 at 6:56 AM, jaya munjal jaya_mun...@yahoo.com wrote: ** Frederick We are on Unix and know we need a 64 bit Oracle 11g client. But wanted to check if there are any issues that people have faced using 11g client with 10g server. As BMC support is saying that we would have to test ourselves if 11g client is fully compatible with 10g server Regards Jaya -- From: Grooms, Frederick W frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:55 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** What OS are you on? For unix/Linux ARS 7.6.04 requires the 64 bit Oracle 11g client which will work with the 10g server. Also I am with you that you never want to do both a DB upgrade and an application upgrade at the same time. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards -- From: Easter, David david_eas...@bmc.com To: arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:18 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011) Extended Support Ends: 31-Jul-2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS
Re: Upgrade ARS 7.1 to ARS 7.6.04
I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005http://www.orafaq.com/wiki/2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010http://www.orafaq.com/wiki/2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011http://www.orafaq.com/wiki/2011) Extended Support Ends: 31-Jul-2013http://www.orafaq.com/wiki/2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Upgrade ARS 7.1 to ARS 7.6.04
Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards From: Easter, David david_eas...@bmc.com To: arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:18 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011) Extended Support Ends: 31-Jul-2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Upgrade ARS 7.1 to ARS 7.6.04
What OS are you on? For unix/Linux ARS 7.6.04 requires the 64 bit Oracle 11g client which will work with the 10g server. Also I am with you that you never want to do both a DB upgrade and an application upgrade at the same time. Fred From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards From: Easter, David david_eas...@bmc.commailto:david_eas...@bmc.com To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:18 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005http://www.orafaq.com/wiki/2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010http://www.orafaq.com/wiki/2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011http://www.orafaq.com/wiki/2011) Extended Support Ends: 31-Jul-2013http://www.orafaq.com/wiki/2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]mailto:[mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: Upgrade ARS 7.1 to ARS 7.6.04
Frederick We are on Unix and know we need a 64 bit Oracle 11g client. But wanted to check if there are any issues that people have faced using 11g client with 10g server. As BMC support is saying that we would have to test ourselves if 11g client is fully compatible with 10g server Regards Jaya From: Grooms, Frederick W frederick.w.gro...@xo.com To: arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:55 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** What OS are you on? For unix/Linux ARS 7.6.04 requires the 64 bit Oracle 11g client which will work with the 10g server. Also I am with you that you never want to do both a DB upgrade and an application upgrade at the same time. Fred From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 1:57 PM To: arslist@ARSLIST.ORG Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi David Thanks for your response. Yes we plan to upgrade to Oracle 11g but we are planning to upgrade to ARS 7.6.04 in one change window and in the following week upgrade the DB to oracle 11g. The reason for this is that we have around 5 AR servers (server group setup) and 13 mid-tier to upgrade. Incase we go for both the upgrades in the same window our downtime will be very high. In order to reduce the downtime we are planning to split the ARS and DB upgrades. But I wanted to ensure that apart from the Oracle support perspective are there any known issues or potential performance issues if application works on Oracle 10g Regards From:Easter, David david_eas...@bmc.com To: arslist@ARSLIST.ORG Sent: Wednesday, April 4, 2012 12:18 AM Subject: Re: Upgrade ARS 7.1 to ARS 7.6.04 ** I would recommend you consider the further supportability of Oracle 10gR2 by Oracle as the primary factor in your decision. http://www.orafaq.com/wiki/Oracle_10g Oracle 10g Release 2 (10.2.0) In July 2005, Oracle Database 10.2.0.1 - also known as Oracle Database 10g Release 2 (10gR2) - was released. Status: Supported Latest patch-set: 10.2.0.5 (the terminal patch set for this release) Premier Support Ends: 31-Jul-2010 (First Year Extended Support fees waived, so it will be fully supported until 31-Jul-2011) Extended Support Ends: 31-Jul-2013 So if you upgrade to AR System 7.6.04 SP2 without upgrading the database, do you have Extended Support for your Oracle implementation? Even if you do, will you plan to upgrade again prior to July 2013? -David J. Easter Manager of Product Management, Remedy Platform BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From:Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of jaya munjal Sent: Tuesday, April 03, 2012 11:35 AM To: arslist@ARSLIST.ORG Subject: Upgrade ARS 7.1 to ARS 7.6.04 ** Hi List We are planning to upgrade our existing ARS server from ARS 7.1 patch 5 to ARS 7.6.04 SP2. Currently we are using Oracle 10g R2 which is minimum version of Oracle that is supported by ARS 7.6.04 as per the compatibility matrix. I wanted to check is there any merit or does BMC recommend that Oracle DB should be upgrade to 11g along with the ARS upgrade, or it can be done seperately. I would really appreciate if you could share your experiences. Thank Jaya _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are