Thursday, February 10, 2011

Upgrade oracle to 10.2.0.1 to 10.2.0.4

    1. Backup the database
    2. Download pathset 6810189 from metalink
    3. Shutdown database

      clip_image001[6]

    4. Stop oracle services

      clip_image002[6]

    5. Upgrade the database

      clip_image003[6]

      clip_image004[6]

      clip_image005[6]

      clip_image006[6]

      clip_image007[6]

      clip_image008[6]

      clip_image009[4]

    6. Start all services

      clip_image010[4]

    7. Startup the database with option upgrade

      clip_image011[4]

      Screen clipping taken: 11.2.2011 г.; 11:12 ч.

    8. Run script catupgrd.sql

      clip_image012[4]

      On the end of upgrade will have following screen

      clip_image013[4]

    9. Check the logfile for any errors and if necessary rerun the script
    10. Restart the database

      clip_image014[4]

    11. Compile invalid objects

      clip_image015[4]

    12. Job is now done and we can check the version of the db

      clip_image016[4]

    13. Now I am going to upgrade also oracle on NODE2

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)