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"