upgrade database 8.1.5 to 8.1.7.2.1
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: upgrade database 8.1.5 to 8.1.7.2.1

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    Wink

    Here is the situations:

    UNIX: Compaq Tru64
    Current Version: 8.1.5.0.0

    We have an 8.1.7.2.1 server installed. I created an 8.1.5.0.0 database (just like our PROD) and now need to upgrade the database to 8.1.7.2.1.

    My question:

    If I run the manual upgrade script: /oracle/product/8.1.7/rdbms/admin/u0801050.sql (to upgrade from 8.1.5.x.x) - this script WILL upgrade the database to the latest version of the 8.1.7.2.1 servers ??? And not just to 8.1.7.0.0 ???

    I do not need to run any of the scripts manually, right ???
    ....except things like catrep.sql, etc.

    Thanks.

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Use the Oracle data migration assistant (odma) from the new install to detect the instances from the old install and migrate them. It will take care of running all the necessary scripts to migrate your database from 8.1.5 to 8.1.7.x. Also remember to follow the readme for the patchsets and run the appropriate scripts too.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    Thanks for the info on the migration assistant.

    BUT, what I want to know is what happens when the upgrade script is run ???

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    It would recreate the catalog and make the appropriate changes to the existing schema...

    You can also view on what it exactly does by opening the script on some text editor...

    less $ORACLE_HOME/rdbms/admin/...


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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