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.it