Oracle Upgrade.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle Upgrade.

  1. #1
    Join Date
    Jan 2001
    Posts
    3

    Thumbs down

    Hi !
    My shop is planing to do an Oracle Upgrade from 7 to 8I on NT.
    I'm a new person in DBA and I need some information on any issues that I might
    have during the Upgrade.

    Thanks a lot.

    [Edited by Vit_R on 01-09-2001 at 02:50 PM]

  2. #2
    Before going Production.
    Test the upgrade procedure in another similar machine.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  3. #3
    Join Date
    Jan 2001
    Posts
    3

    Thumbs down

    Thanks for quick response.
    The problem is that I'm not sure waht is the upgrade
    procedure would be and how much it will take for
    my database.
    Could you help me with that?

    Thanks.

  4. #4
    Join Date
    Apr 2000
    Posts
    126

    Wink

    Actually, going from Oracle 7 to 8i is migrating not upgrading. The Migration Guide will give you all the details for migrating your database.

  5. #5
    Join Date
    Jan 2001
    Posts
    3

    Question

    What needs to be done before actual upgrade ?

  6. #6
    The recommendation above is right, Read the Migration Manual first.
    With no detail would be:
    -Shutdown DB and services
    -Backup DB (and machine if you can)
    -You can install the new kernel in other ORACLE_HOME (recommended)
    -Start the DB with the new kernel.
    -Run the appropiate script (u0703040.sql)
    -Apply patches to the new release (and run post-patch scripts)

    You are allowed to migrate from 7.3.4 only (because that version is supported) If you don't have it you must upgrade first.

    You can migrate using export/import but it is slow.
    And please, read the manual first and test the procedure in Testing. (The procedure includes testing applications)
    Ramon Caballero, DBA, rcaballe@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width