Re: Oracle Migration 8.1.6.0 to 8.1.7.2
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
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
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
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
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).
Oracle Migration 8.1.6.0 to 8.1.7.2
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).