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"