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 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).



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 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-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: Baker, Barbara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public