Re: Upgrading 8i to 10g drama

On 1 Dec 2004 05:09:59 -0800, phph109_at_yahoo.es (Pedro Hernandez) wrote:

>Howard J. Rogers wrote:
>
>> Did you actually look very hard? Under the 10g documentation, click the
>> Books tab, and you'll find a book called "Upgrade Guide". Sounds like it
>> might be what you're after to me.
>
>:-[
>Thanks
>
> ph

I did something similar myself, not for production purposes, just to export one tablespace from old database, which I forgot (why can't I just mount old database file with tablespace I need in new version read-only???). I've been migrating data from Oracle 8.1.7 for IBM AIX 4.3.3 (IBM RS6000 model F50, 32-bit) to Oracle 9.2.0.7 for IBM AIX 5L V3 (IBM pSeries 570p, 64-bit), and I thought I got no chance of doing it due to different machine word length (the other option I had is pull old server out of store room, remove Linux which I installed out of curiosity and reload OS, Oracle and data from backup tapes).

I just copied database files (and $ORACLE_HOME/admin/$SID directory with all files) over to new server from tape, set up symbolic links to database files (to reflect old database file structure), created new orapw$SID file, removed couple of old entries from init$SID.ora, linked $ORACLE_HOME/admin/$SID/pfile/init$SID.ora to $ORACLE_HOME/dbs/init$SID.ora, did a STARTUP MIGRATE and run scripts manually (dbua utility did not work as expected, I tried different combinations, did an RTFM too!)

 I'll suggest looking in $ORACLE_HOME/rdbms/admin/u0801070.sql and read comments (obviously this script has different contents in 10g). Then run scripts in sequence proposed.

Alex Received on Thu May 11 2006 - 02:54:32 CDT