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!!!
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
Is this the same for 8.1.5 to 8.1.5 on Windows NT4?
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 -
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!
Click Here to Expand Forum to Full Width