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

Thread: migrating from 8.1.5 t0 8.1.7

  1. #1
    Join Date
    Nov 2000
    Posts
    169

    Red face

    Hi guys can any one tell where I can find a documentation on migration from version 8.1.5 to 8.1.7 of Oracle 8i enterprise edition?

  2. #2
    Join Date
    Jun 2000
    Posts
    179

    Talking

    Her are the steps to migrate on NT/2000 Platform :

    - Shudown all services for 8.1.5
    - Install 8.1.7 on the same home of 8.1.5
    - During installation choose custom , you will find that many components are marked with "upgrade " this means that Oracle is going to upgrade this product to the new release so leave it as is , choose all other new componenets to install .
    - Start Installation , It will take a while ( It took 35 Minutes on PIII 700 + 128 M Ram + SCSI HARD ) .
    - Restart Machine
    - Start Listener

    DO THE FOLLOWING STEPS TO UPGRADE EVERY DATABASE IN THE BOX :

    - Open DOS Window
    - Set Environment variable to the SID you want to upgrade
    - Start Server manager
    - Connect internal
    - Run the script needed to upgrade the database , this script usually look like this :u0801050.sql ,, tha path is :
    %Oracle_Home%ora81\rdbms\admin\u0801050.sql

    Do this steps to update every database .

    GOOD LUCK
    Hisham Nagia
    IT Manager For Development
    Oracle Consultant - OCP

  3. #3
    Join Date
    Nov 2000
    Posts
    169
    Do you have any idea how to migrate in UNIX(AIX)? Sorry, I should have told you I'm operating AIX

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    How big is your database? If your database is not very big (not more than 20GB, in which you have to use compress utility and named pipe to limit your dump file size), See my response for cravi posting 'upgrade' on 12/21/00 using exp/imp. Its upgrade and it should work unless you have specific reasons to 'MIGRATE', not upgrade. Make sure there are no datatypes changed for your application from 815 to 817, in case exp/imp doesn't work. I don't think datatype changed from 815 to 817. Not sure, check it up with 817 release documentation.


  5. #5
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Use oracle migration work bench tool to migrate. It is less hassel. It is available for download at technet.oracle.com

    Good luck.
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  6. #6
    Join Date
    Mar 2000
    Location
    Sydney
    Posts
    9
    Guys,
    Hope you are all aware of the fact that Oracle 8.x to 8i is just a upgrade and not a Migration. Migration is called only when you migrate from a base version such as 7.x to 8.x where there are lots of changes involved. If you want to upgrade from 8.1.5/6 to 8.1.7 then this is an upgrade and not MIGRATION. Yes, you have to install it on the same ORACLE HOME and run the upgrade script found in $ORACLE_HOME/admin/scripts dir.

    Thanks
    GK

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