"Clear requirements and Vision"? What is that? I can understand the Vague part, but Clear?
> 6 weeks to a year. Depends on the requirements and the level of idiocy > of whomever's in charge. You know how it is: Clear Requirements & > Vision make for an easy project whereas Vague Requirements and Scope > Creep are every developer's nightmare. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi > Sent: Friday, December 08, 2006 11:51 AM > To: [email protected] > Subject: Re: Migration Path from ARS 5.12 ~> 7 > > ** > Wow, awesome.. > I am Totally impressed with your work ethics !! > How long does it take for you to migrate a server ? > > > > On 12/8/06, Meyer, Jennifer <[EMAIL PROTECTED]> wrote: > > 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] <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" > > > > > > -- > 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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
