9iUpgrade.htm
Bikle
-----------------

Upgrading an 8i Database to 9i

Summary
-------

-Note relevant documentation
-Create a copy of the 8i Database from RMAN backup
-Install 9i software
-Upgrade the 8i Database to 9i


Details
-------

-Note relevant documentation

Oracle8i Recovery Manager User's Guide and Reference Part Number A76990-01:
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76990/toc.htm
My Reading Notes: crDupWithRMANnotes.txt

9.2.0.1 Release Notes For Solaris (32 bit) Part No. A97348-02:
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/A97348_01/toc.htm
My Reading Notes: RelNotesNotes.txt

Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems Part No. A96167-01:
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/A96167_01/html/toc.htm
My Reading Notes: insNotes.txt

Oracle9i Administrator's Reference Release 2 (9.2.0.1.0) for UNIX Systems Part No. A97297-01:
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/A97297_01/html/toc.htm
My Reading Notes: adminNotes.txt

Oracle9i Database Migration Release 2 (9.2) Part Number A96530-02:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96530/toc.htm
My Reading Notes: MigNotes.txt

-Create a copy of the 8i Database from RMAN backup
 -Use RMAN to backup an 8i DB (qbikle is good choice; only 800mb)
  Details: RMANbackup8i.txt

 -Create an environment for 8i copy with ORACLE_SID=i9
  (Although ORACLE_SID=i9, this is still an 8i DB)

  -Build .i9 file which will be used to supply env variables:
    .i9
  -Build initi9.ora file to supply parameters to the the new 8i database:
    initi9.ora
  -Create an orapwi9 file for the new 8i DB (syntax: orapwd file=orapwi9 password=sys)
  -Attempt STARTUP NOMOUNT
  -Ensure Net8 Connectivity to the the new 8i DB
    -Create a simple .txt file with a tns entry in it
    -Load the .txt file into the names server
    -Screen dump: 
      i9IntoNames.txt
    -Add entry to listener.ora
      listener.ora
    -Bounce listener
    -Check sqlnet connectivity


 -Use RMAN to restore copy of the 8i Database into i9 environment
  -Build an RMAN script to restore the files:
    RMANi9.sh
  -Study the output:
    RMANi9-out1.txt
  -Build and run a CREATE CONTROLFILE script:
    crctl-out.txt
  -Make archived redologs available and then rollforward:
    rollForward-out.txt

-Install 9i software

ins9i.txt

-Upgrade the 8i Database to 9i

upg8to9.txt