RE: Oracle Migration 8.1.6.0 to 8.1.7.2

Ken:
I asked this question of the list several weeks ago, and got no reply. I installed 8.1.7.0 on the system, patched up to 8.1.7.3, and then upgraded my test database.
I now want to go directly to exactly the same code tree with my production database because (1) it's been tested with exactly that installed version, and (2) I don't have enough space to install yet another 8.1.7.0 code tree. (I need to keep the 8.0.5 code tree around, at least until the upgrade is complete. I need to keep 8.1.7.3 up for test. So I'd need 3 code trees at once if forced to re-install 8.1.7.0)

Oracle has gotten more adamant about claiming you need to go to vanilla first, but I've yet to see a reason why.

If you get any more info, please share.

Thanks!
Barb

> ----------
> From: Fowler, Kenneth R[SMTP:kenneth_r_fowler_at_groton.pfizer.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, July 18, 2002 12:18 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Migration 8.1.6.0 to 8.1.7.2
>
> The server already has 8.1.6.0 and 8.1.7.2 installed in separate oracle
> homes. We could install 8.1.7.0 in a third oracle home (we have the
> media)
> but are trying to avoid that as we would only need it for migration after
> which we have no use for it. So I was just wondering if we can migrate
> directly (8.1.6.0 -> 8.1.7.2) instead of a two step migration (8.1.6.0 ->
> 8.1.7.0 -> 8.1.7.2)... just to avoid installing yet another version of
> oracle on this server. The docs seem to advise the two step process but
> don't go as far as stating that it must be done this way so I wondered if
> others have first hand experience?
>
> Thanks,
> Ken
> _________________________________________
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026 Fax: (860) 715-8346
> Email: mailto:fowlerkr_at_groton.pfizer.com
>
>
> -----Original Message-----
> Sent: Thursday, July 18, 2002 12:54 PM
> To: Fowler; Kenneth R; Multiple recipients of list ORACLE-L
>
>
> Ken,
>
> How do you plan on getting to 8.1.7.2? You need to apply the patch
> set
> ontop of an 8.1.7.0 install. I'd double check your CD's.
>
> Dick Goulet
>
> ____________________Reply Separator____________________
> Author: "Fowler; Kenneth R" <kenneth_r_fowler_at_groton.pfizer.com>
> Date: 7/18/2002 9:43 AM
>
> List,
>
> One of the DBA's here needs to migrate a fairly sizeable database from
> 8.1.6.0 to 8.1.7.2 on Solaris. The doc's state that it is advisable to
> migrate to 8.1.7.0 and then go to 8.1.7.2 but we don't have 8.1.7.0
> installed and don't want to install it unless we really have to. Anyone
> know if it is possible to migrate directly to 8.1.7.2 (docs don't
> explicitly
> say it can't be done but don't seem to suggest it either).
>
> Ken
> _________________________________________
> Clinical and Regulatory Informatics - Groton/New London
> Coordinator, Business and Technical Services
> Tel: (860) 732-0026 Fax: (860) 715-8346
> Email: mailto:fowlerkr_at_groton.pfizer.com
>
>
>
> LEGAL NOTICE
> Unless expressly stated otherwise, this message is confidential and may be
> privileged. It is intended for the addressee(s) only. Access to this
> E-mail
> by
> anyone else is unauthorized. If you are not an addressee, any disclosure
> or
> copying of the contents of this E-mail or any action taken (or not taken)
> in
> reliance on it is unauthorized and may be unlawful. If you are not an
> addressee,
> please inform the sender immediately.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fowler, Kenneth R
> INET: kenneth_r_fowler_at_groton.pfizer.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fowler, Kenneth R
> INET: kenneth_r_fowler_at_groton.pfizer.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  INET: bbaker_at_denvernewspaperagency.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).