Patrick, you are so cute! IMHO, the best way to perform an upgrade is to start with a brand new server and map my fields from one database to the other, but I like doing a lot of work. ;-D
J Meyer -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: Friday, December 08, 2006 10:38 AM To: [email protected] Subject: Migration Path from ARS 5.12 ~> 7 ** Hello everyone, I wanted to share my testing of a possible migration path for ARS 5.12 ~~> 7.0/01. 1. Tested Migrator 6 / 7p1 / 7p2. 2. Tested ARUtilites Migration (some) 3. Tested DB Move / with Installer Upgrades. ENV:: Solaris 9 / Oracle 9206 -8i libs ~~> Solaris 9 / Oracle 10.2.0.1 - 9i libs >From the above scenario's my conclusion so far are to do option 3 .. EVERYTIME. make backups - make backups - and make backups again. Create 10.2.0.1 DB in an Oracle Home (some folks use oracle as the account name) Create 9.2.0.6 Client Account and install the Client only on that account name (oracle9 -for the discussion) Ensure the 9i account is set so no one can login to it.- security. install ARS 7.0 to the system --> don't worry.. read the rest. using Oracle 10 Client on your PC, login as "system" find aradmin table space - Remove all Tables --- This will clean all the indexes as well. Take the export of your production DB, Ftp it to the new server (in this case /u02). import using a PAR file par file will be like the following:: ------ 69 [EMAIL PROTECTED] /u02 > more ARImport.dat USERID=system/<System Password Here> FROMUSER=ARADMIN TOUSER=ARADMIN buffer=9192000 <--- NOTE:: if you get disapprop errors you do not have this big enough commit=y LOG=/u02/ARS9_ARADMIN_IMP.log FULL=N GRANTS=Y IGNORE=N ROWS=Y FILE=/u02/<Your Dump Name>.dmp ----- Prior to the actual import make sure ARADMIN has unlimited table space, and can create links in the security section user aradmin. --- after the ARImport.dat file is clean and setup imp parfile=ARImport.dat --- That will import all your 9.2 oracle data and create all the links.. (you might have to clean then up some -- tnsnames might need fixing) --- Delete the ARS 7 install manually -- delete folders etc.. (If you got a ARS 7.0 License for a move you are in luck) Install ARS 6.01 patch 1539 -- Both Server and Email and Flashboards and Other app's you have. Install ARS 6.3 patch 19 -- Both Server and Email and Flashboards and Other app's you have. --- At this point you should test your applications check them out.. NOTE:: your ARS 7.0 licenses work for the ARS 6.3 Server.. funny huh. Install ARS 7.0 or Patch 01 -- Both Server and Email and Flashboards and Other app's you have. ---- Check system out again.. I have found that it is pretty Close so far.. <WARNING::> This is purely my result, your results may vary according to ability, functions, platform, no coffee, bad day.. whatever. This comes with no warranty either implied or inferred, it may or may not work -- that is your problem for following this information. I can and will not be held responsible for your data, server or functionality of your server before, now, or in the future. </WARNING::> -- Patrick Zandi __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
