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: Mike.Hately_at_npowernorthern.com

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