[OAUGNetDBA]-Re: Upgrade to 11.5.10.2 from fresh install

["James Morrow" <morrow.james@gmail.com>]

The basics of the "Rapid Migration" approach are:

1.	Perform a fresh install (including database) on the TARGET
2.	Determine which patches have been applied to SOURCE that have
	not been applied to TARGET (fresh install).  Do this by querying
	ad_bugs.
3.	Apply those patches to the TARGET (preinstall=Y) or (nodatabaseportion).
	All you're doing here is making sure that the filesystem portion of
	those patches is applied to the code tree.
4.	Delete TARGET database.
5.	Copy database from SOURCE to TARGET
6.	Apply latest version of AD patchset (AD.I.6)
7.	Apply the database portion of the maintenance pack.
	(Basically, follow the maintenance pack instructions).
8.	Patch Current.

ADVANTAGES:

-- Your SOURCE environment is not impacted and is therefore available
   as a "failback" should you need it.

-- When a release (11.5.10.2) is relatively new, it can dramatically
   reduce overall downtime.  However, as the release ages, this particular
   advantage diminishes as the "patch current" time grows.

-- You end up with a "clean" and "current" technology stack.

-- You can (to some degree) avoid the need to apply certain techstack
   patches.  (As they'd already be included).

-- You can work in some architectural changes here (new hardware, different
   filesystem layout, etc.)

DISADVANTAGES:

-- Requires additional disk space at a minimum (since you're not doing an
   "upgrade-in-place").

NOTE:  This is only valid when doing "point release" upgrades within 11i.
There is a specific UPGRADE process for 10.7-->11i, 11.0-->11i, and 11i-R12.



You can find more information here:

http://repo.solutionbeacon.net/R11iRapidMigrations2006OW.pdf

-- James

----------------------------------------------------------------------
James J. Morrow | Senior Oracle Applications DBA
morrow.james <at> gmail <dot> com



On Mon, Jun 9, 2008 at 4:40 PM, Leong, Fushan <fushan.leong@sonosite.com> wrote:
>
> Plan to upgrade from 11.5.9 to 11.5.10.2.  Two approaches.  Traditional
> apply 3400000 upgrade patch.  I also heard that you can also lay down
> the fresh installation 11.5.10.2 and use this new appl_top to upgrade.
> Which method is better? What is the advantage or disadvantage on both
> method?
>
> For the fresh installation 11.5.10.2, what is the procedure?
>
> #############################################################
> This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
> To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
> To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
> To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
> To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
> Send administrative queries to  <OAUGNetDBA-request@oaug.com>
>
>

#############################################################
This message is sent to you because you are subscribed to the mailing list <OAUGNetDBA@oaug.com>.
To unsubscribe, E-mail to: <OAUGNetDBA-off@oaug.com>
To switch to the FEED mode, send any message to <OAUGNetDBA-feed@oaug.com>
To switch to the DIGEST mode, E-mail to <OAUGNetDBA-digest@oaug.com>
To switch to the INDEX mode, E-mail to <OAUGNetDBA-index@oaug.com>
Send administrative queries to  <OAUGNetDBA-request@oaug.com>