Oracle upgrqade from 8.1.5 to 8.17
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle upgrqade from 8.1.5 to 8.17

  1. #1
    Join Date
    Dec 2001
    Posts
    337
    Hello,

    Can anyone point me to a 'checklist' as to what needs to be carried out to upgrade from 8.1.5 to 8.1.7 on a solaris box. The upgrade will be done over x-window access.. This is my first time so am a bit nervous!!!

    Thanks
    Chucks_k

  2. #2
    Join Date
    Feb 2002
    Posts
    7
    Install oracle 8.1.7 on a different dir
    copy 8.1.5 init.ora to 8.1.7 Oracle_home/dbs dir
    change the oracle_home of the sid running in 8.1.5 to
    8.1.7 oracle_home in /etc/oratab file

    shutdown the 8.1.5 database
    set the oraenv of the sid which is running in 8.1.5
    startup the database using svrmgrl

    run the script U0801050.sql which is in $ORACLE_HOME/rdbms/admin dir
    which will take care of upgrade

    Thats it, you are done.,

    All the best
    Ganesan S.

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Is this the same for 8.1.5 to 8.1.5 on Windows NT4?

  4. #4
    Join Date
    Dec 2001
    Location
    SAN FRANCISCO, CA
    Posts
    306
    just one question

    what about the backups from 8.1.5 ?

    He has to take the cold backup of all the files and extract it in 8.1.7 ? right
    Eat , Drink & Enjoy life -

    pravin_kini@hotmail.com

  5. #5
    Join Date
    Dec 2001
    Posts
    337
    Thanks all..

    I think i have to take a cold backup b4 i do anything..just in case something goes wrong!
    Another thing i have noticed is that the system tablespace has some user tables in it. What is the best way to move these to their default tablespaces? I was thinking of using the MOVE statement and then rebuilding the indexes..is this the best way to do it?

    Thanks once again!

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