Manual upgrade Oracle 8i to Oracle9i
                                                 Last update (2011-11-25 10:58:36)
                                                                                                                   Date added (2010-02-09 09:56:44)

Summary
Here are the steps to manual upgrade an Oracle8i (8.1.7.0) database to Oracle9iR2 in the same Unix environment.

1. With the same os user that owns the $ORACLE_HOME (8i) and database files create a new 9i $ORACLE_HOME. You can copy paste the Oracle9i binaries from another server and relink them to make them valid.

2. Set the Oracle 9i environment ($ORACLE_HOME, $ORACLE_SID, $PATH, $LD_LIBRARY_PATH) for the os user

3. Copy the Oracle8i initSID.ora and orapwSID (password file) to the new Oracle9i home. Remove entry for local_listener if exists in initSID.ora and set shared_pool_size = 110485760 (>110 MB)

4. Copy listener.ora and tnsnames.ora files from the old Oracle8i home to the new Oracle9i and start Oracle9i Listener.

5. Shutdown the Oracle8i database

6. Change directory to new 9i $ORACLE_HOME/rdbms/admin and execute >sqlplus "/ as sysdba"

7. Execute SQL>startup migrate

8. Execute SQL>SPOOL upgrade.log

9. Execute SQL>@u0801070.sql;

10. Check if the database components have been upgraded
SELECT comp_name, version, status FROM dba_registry;

COMP_NAME                      VERSION                        STATUS
------------------------------ ------------------------------ -----------
Oracle9i Catalog Views         9.2.0.8.0                      VALID
Oracle9i Packages and Types    9.2.0.8.0                      VALID
11. Execute SQL>@cmpdbmig.sql;

12. Restart the database (shutdown immediate and startup)

13. Compile all objests SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

After the upgrade you have to manual migrate:
1. New UNDO tablespace from rollback segments
2. New compatible parameters for Oracle 9i (compatible = 9.2.0, spfile, db_cache_size, background_dump_dest, obsolete parameters, etc)

Other links
Manual upgrade Oracle 8i InterMedia to Oracle 9i
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search