Well.. (oracle install 10.2 - oracle install of client 9i) -- I installed these and tested them with a demo ars 7.01 first.. had that all working.. (approx 1 or 2 days) Then started with dropping all the Tables -- Below (1 long day) So 2 - 3 days I suppose.. at most.
On 12/8/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I will be making the upgrade from ARS 5.1.2 to the latest 7 release early in 2007. I would love to use my own ARUtilities but it was not designed for this type of migration. (perhaps I have time to write some additional functionality before my migration). Just curious though, how long did the migration take using your method? I have saved this email for reference when I have to perform the task. Thanks for the details Les Ganton > NOTE:: I am not DIS'ing ARUTILITES / PANACEA / OR MIGRATOR.. It is just the > simple fact that you are moving through too many changes // system > modificaitons.. They are no made to Modify Structures (ars 4 to 7) .. it is > not designed to do so.. > I would afterward use this to keep you data / forms // syncronized > afterward.. they work just fine. But for this instance.. it just did not > work properly -- too many changes. > > > > On 12/8/06, patrick zandi <[EMAIL PROTECTED]> wrote: > > > > 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 > > > > > > -- > Patrick Zandi > > _______________________________________________________________________________ > 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"
-- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
