RE: Oracle 9.0.1 and 9.2
Hi Kevin, In the 9i R2 Migration Guide (p 321), Step 10 of the upgrade process specifies that you should open the database using "STARTUP MIGRATE". This option sets the status of the database to 'OPEN MIGRATE' in V$INSTANCE. That makes it a migration. Hence the discussion we had a few months ago along the lines of "Yes, 9i Release 1 was really only 8.2 and this is the real 9i" Did you use the Database Upgrade Assistant? That may explain why you didn't see the "migrate" step. I think my phrasing implied that migrating to release 2 was far harder than upgrading to a new version. Thanks to improvements in the process this is no longer the case. Regards, Mike Hately -Original Message- Sent: 05 December 2002 12:34 To: Multiple recipients of list ORACLE-L > The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Can you explain this? I've upgraded multiple databases (Solaris) from 9.0.1 to 9.2.0 by doing a simple upgrade. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9.0.1 and 9.2
> The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Can you explain this? I've upgraded multiple databases (Solaris) from 9.0.1 to 9.2.0 by doing a simple upgrade. -Original Message- Sent: Thursday, December 05, 2002 4:18 AM To: Multiple recipients of list ORACLE-L Stefan, The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Whether you want to go through that is your choice really. If I had the disk to burn I'd go for the fresh install but then I like to have a version of everything available. Regards, Mike Hately -Original Message- Sent: 05 December 2002 08:29 To: Multiple recipients of list ORACLE-L Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a "minor" update like 8.1.5 -> 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9.0.1 and 9.2
I'd install a new home for 9.2 - once the db is upgraded and working fine, then blow away the 9.0 version. Otherwise there is always that risk that you lose a little file that you would have liked to keep (eg listener.ora etc etc) hth connor --- Stefan Jahnke <[EMAIL PROTECTED]> wrote: > Hi everybody > > I've got 9.0.1 and 8.1.7 running on one laptop (to > test stuff). Now I want > to upgrade the 9.0.1 to 9.2. Does it make sense to > just install the 9.2 to a > new Oracle home or would it be better to get rid of > 9.0.1 and do a fresh > install of 9.2 ? Can 9.2 generally be seen as a > "minor" update like 8.1.5 -> > 8.1.6 or more like 8.0.5 to 8.1.x, which would be a > different major version > ? > > Regards, > Stefan > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Stefan Jahnke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > 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). > = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9.0.1 and 9.2
Stefan, The move to 9.2 from 9.0.1 requires a migration rather than a simple update. Whether you want to go through that is your choice really. If I had the disk to burn I'd go for the fresh install but then I like to have a version of everything available. Regards, Mike Hately -Original Message- Sent: 05 December 2002 08:29 To: Multiple recipients of list ORACLE-L Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a "minor" update like 8.1.5 -> 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 9.0.1 and 9.2
Hi everybody I've got 9.0.1 and 8.1.7 running on one laptop (to test stuff). Now I want to upgrade the 9.0.1 to 9.2. Does it make sense to just install the 9.2 to a new Oracle home or would it be better to get rid of 9.0.1 and do a fresh install of 9.2 ? Can 9.2 generally be seen as a "minor" update like 8.1.5 -> 8.1.6 or more like 8.0.5 to 8.1.x, which would be a different major version ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).