Tee-Hee! Hard as it may be to believe, there are managers out there who do work without their shoulders permanently super-glued to their thighs. Some of them have an idea where they want to go and how they want to get there and can even spell "requirement" and say "no." Even more difficult to fathom, some of them are nice people to work for.
But don't let onto my boss I said that, or he'll start to think the whole office is going soft on him. :-) J Meyer -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, December 08, 2006 12:48 PM To: [email protected] Subject: Re: Migration Path from ARS 5.12 ~> 7 "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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
