Antonio, Simply changing parameters, locale settings etc. won't work. The reason is explained in document "BMC Remedy Action Request System 7.1.00 Installing" on page 162. The only supported way to "upgrade" to Unicode is from 6.3 to 7.x
But you can do a little hack. In short: 1. UPDATE .control SET dbversion = 21 (21 means ARS 6.3) 2. run arupora (this will update the serialized qualifiers to have the correct byte lengths) 3. UPDATE .control SET dbversion = 23 I can provide you additional information if you're not familiar with the internals of the upgrade process. HTH Kind Regards Conny ________________________________ Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Antonio Monizza Gesendet: Dienstag, 29. Juni 2010 15:05 An: arslist@ARSLIST.ORG Betreff: ARS 7.1.0 from NON unicode to unicode - oracle from 9.x to 10.x on new machines ** Hello listers, we have a custom application, with ARS 7.1.0 server on AIX machine, installed in NON Unicode mode and pointing to AIX db server with Oracle 9.2, characterset UTF8. So database is already Unicode enabled, ARS is not. We are planning to do a major upgrade: we need to have our ARS server in Unicode mode, then we will point app server to a new db machine with Oracle 10, eventually we want to upgrade to ARS 7.5. Currently we are focusing on the non Unicode to Unicode upgrade step, so we are looking for any valuable advise on the topic. At BMC support they keep on saying that a brand new ARS installation in Unicode mode is needed (i.e. no upgrade), and then def+data must be imported at ARS level Has anyone of you ever tried to upgrade ARS 7.1.0 from non Unicode to Unicode mode 'simply' changing parameters and environment variables (LANG and LC_ALL) and locale settings on the ARS application server, acting directly on ar.conf and arsystem files, and then doing a stop/restart of ars server? Should a new installation be inevitable, we really want to avoid using migrator or arimport for data migration (too many forms, too many data...), and use oracle export/import instead of whole arschema: has anyone of you ever tried this option? Any advise and suggestion on this topic is very welcome! Thanks in advance Best Regards, Antonio Monizza _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
