Re: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-21 Thread Ray Stell



Just an aside, I have been pretty unhappy with 8.1.7.1.2, lots
of crashes/core dumps with 7445 errors.  I would not suggest
going there, I hope 8.1.7.4 is a better place to be.



On Thu, Jul 18, 2002 at 09:43:26AM -0800, Fowler, Kenneth R wrote:
> 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:[EMAIL PROTECTED]
> 
> 
> 
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).

-- 
===
Ray Stell   [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ray Stell
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Paul . Parker

Currently going through a migration from 8.1.6.0.0 to 8.1.7.4

1.  Had 8.1.6 installed.
2.  Install 8.1.7.0 into new ORACLE_HOME
3.  Apply pathset to get to 8.1.7.4
4.  Upgrade database to 8.1.7.4

You only need to upgrade once, with only 2 oracle homes.

Paul


-Original Message-
Sent: Thursday, July 18, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L


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:[EMAIL PROTECTED]


-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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]



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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: 
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Baker, Barbara

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:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]
> 
> 
> -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" <[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]
> 
> 
> 
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> 
> 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

RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Fowler, Kenneth R

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:[EMAIL PROTECTED]


-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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]



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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: Oracle Migration 8.1.6.0 to 8.1.7.2

2002-07-18 Thread Vergara, Michael (TEM)

Ken:

My Two Cents'...

It seems to me that you're gonna have to install the 8.1.7.0.0
code in order to apply the 8.1.7.2 patch.  So where's the
problem?  You install 8.1.7, upgrade the DB, apply the .2 patch,
and it's Miller Time.

Cheers,
Mike

-Original Message-
Sent: Thursday, July 18, 2002 10:43 AM
To: Multiple recipients of list ORACLE-L


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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).