Oracle upgrqade from 8.1.5 to 8.17

[Chucks_k]

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

[gansen]

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

[JMac]

Is this the same for 8.1.5 to 8.1.5 on Windows NT4?

[pravin]

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

[Chucks_k]

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!