LANG, LC_ALL, etc. are environment variables that define/set the server localization information. See http://www.opengroup.org/onlinepubs/009695399/basedefs/xbd_chap08.html for more information on the available options. The important thing here is that the source and target server are localized in the same way.
ARServer base language - on the source arserver, what localization did you install? For example, if you were using a non-unicode character set on the original db, you would have installed the language of arserver that matched the language of the oracle instance. This needs to be the same at the source and target. Axton Grams On 8/22/07, Mau Remedy <[EMAIL PROTECTED]> wrote: > Axton > > Would you elaborate on arsever localization (base language installed) > and arserver host localization (LANG) > > I´d appreciate it very much > > Sincerely, Mau > > > > 2007/8/20, Axton <[EMAIL PROTECTED]>: > > Are the localization settings the same between servers A/B and X/Y. > > You did not give OS, some some things to think about: > > - arserver localization (base language(s) installed) > > - oracle instance character set (xxx.xUTF8) > > - arserver host localization (LANG) > > - oracle client settings (NLS_) > > - arserver 7.0 vs. 7.0.1 version mismatch during server B install > > > > Axton Grams > > > > On 8/20/07, Mau Remedy <[EMAIL PROTECTED]> wrote: > > > Hello guys > > > > > > I need your assistance in regards to a backup/restore problem, there > > > are corruption errors in our definition file while starting the new > > > ARSystem just after restoring the old database. > > > > > > Can anyone point out the definitive steps to move an arsystem oracle > > > database from one server to a second one, tips and tricks, anything we > > > need to have in mind. > > > > > > Please enlighten me, thanks > > > > > > > > > Here are the details: > > > > > > We are trying to move an arsystem database from ARServer A (actual > > > production box) to ARServer B (new production box). > > > > > > Both ARServers use their respective remote Oracle database: Server A > > > connects to actual Oracle Server X and Server B is intended to connect > > > to Oracle Server Y. > > > > > > Both Oracle servers are 9i, ARServer A is 7.0 with Helpdesk 6.0 > > > heavily customized. ARServer B is intended to have ARSystem 7.0 as > > > well. > > > > > > The steps that were performed: > > > > > > 1. Backup actual production database in Oracle Server X using EXP utility > > > 2. Manually create db user aradmin, tablespace and grant permissions > > > in Oracle Server Y. > > > 3. Restore the backup file with IMP utility to Oracle DB in server Y. > > > (The restored DB had errors in several Views, so the objects were > > > compiled again. No further import errors). > > > > > > (previous steps are Oracle related) > > > > > > 5. Run ar_install script in Server B, it´s intended to install ARSystem > > > v 7.0 > > > 6. At the point where it detects that there´s a previous ARSystem > > > database (the restored db) it asks wether I like to overwrite, share > > > or upgrade. > > > 7. I enter the S (Share) option > > > > > > After these steps, script begins to load some binaries, but at the > > > point it needs to start arserver daemons, I get multiple errors. > > > > > > The most immediate errors in arerror.log are: > > > > > > Mon Aug 20 13:05:21 2007 390600 : El archivo de definición tiene un > > > formato incorrecto (propList format -- > > > 18\3\41\2\1125\600\14850\4100\20\4\14\ID de > > > petición\28\6\1\29\6\4\27\8\2\61\40\22\60\40\1\4\6\1\7\40\2147483641\143\40\4294967295\170\40\0\21\41\2\0\0\13725\1300\151\41\2\0\1400\1 > > > (ARERR 402) > > > Mon Aug 20 13:05:21 2007 schemaId=16 fieldId=1 vuiId=0 propList=(null) > > > > > > arserver daemon starts normally but after too many attempts to load > > > definitions it finally dies. > > > > > > I´d appreciate your help > > > > > > _______________________________________________________________________________ > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > > > the Answers Are" > > > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where > > the Answers Are" > > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
