Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 'upgrade' to same $ORACLE_HOME
> To follow up on my earlier post on 8.1.5 on Solaris 7 is is possible to just
> onstall 8.1.7 into the the same home to perform an 'upgrade' or does it have
> to be done in a different way?
>
> Does the database have to be stopped or anything like that?
You can do an upgrade installing the new executables in the same
ORACLE_HOME but you have to stop everything b4 upgrade
(including listeners and any other oracle service)
The installer will recognize you are upgrading and it will
ask to upgrade your databases too;
BTW i would take a cold backup of databases b4 the upgrade because
you will need to upgrade the databases too. Take in consideration
that upgrade the database is a quite long task and the wizard sometimes
says it has upgraded but it has just modified your init.ora files, so
if the wizard would fail in this way you can find the upgrade scripts
located in $ORACLE_HOME/rdbms/admin/ and they are named like
u[old database version].sql e.g. to upgrade your oracle 8.1.5 you
would use u0801050.sql logged as sys (you can find instructions on the
header of the file itself).
If you want further clarifications feel free to contact me by email.
ciao
-- ----------------- Silvia Cara, CCNA - CCNP ICQ #27395959 Seti@Home Member http://www.setiathome.com HomeStable @ http://www.duvacche.itReceived on Mon Sep 09 2002 - 03:55:06 CDT