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:[email protected]] On Behalf Of Daniel Condrea Sent: Wednesday, February 13, 2013 1:52 AM To: [email protected] 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:[email protected]> mailto:[email protected]] On Behalf Of Antonio Monizza Sent: Monday, February 11, 2013 7:10 PM To: <mailto:[email protected]> [email protected] 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"
