Re: Upgrading 7.2 to 7.3 non-ofa

From: oracle <oracle_at_nightmare.com>
Date: 1997/03/06
Message-ID: <331F7466.2C52@nightmare.com>#1/1

------------44E514D719D323
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii

Robert Cordingley wrote:

>
> Okay, this is probably obvious.  Is there any way to upgrade from 7.2
> to 7.3 in a non-OFA setup WITHOUT doing a full export/import?  The
> lovely orainst program doesn't offer to upgrade the database for me
> and it's not obvious which scripts I should run to do the upgrade
> manually.  I've searched metallink for a white paper or something,
> but the only advice I've found is the imp/exp thing.  Does anybody
> have any productive advice or am I stuck trying to find 20gb of spare
> disk in my shop?
>
>                                 Robert

I am assuming that you are doing this on a UNIX box and I am also assuming that once you have the 7.3.2.1 software installed you are applying the madatory patch to go to 7.3.2.3. This will also assume that you are installing in the same ORACLE_HOME.

Make a damn good backup!
Deinstall all the 7.2 products.
Install the 7.3.2.1 products by choosing to "Add/Upgrade Software"
Apply the patches to get your kernel and products up to date with the 7.3.2.3 patch. Make sure you upgrade the installer.
Make sure ORACLE_BASE is not set.
Use the new installer to upgrade database objects.

This should work. If you are installing into a new ORACLE_HOME of course you do not need to deinstall the 7.2 products. Also there is another workaround but you need to modify the "unix.stp" and "unix.zoo" so it does not ask for a mount-point but this is easier and will work.

Let me know if you run into any trouble.

------------44E514D719D323
Content-Transfer-Encoding: 7bit
Content-Type: text/html; charset=us-ascii

<HTML><BODY>

<DT>Robert Cordingley wrote: 

>  
> Okay, this is probably obvious.  Is there any way to upgrade from 7.2 
> to 7.3 in a non-OFA setup WITHOUT doing a full export/import?  The

&gt; lovely orainst program doesn't offer to upgrade the database for me<BR>
&gt; and it's not obvious which scripts I should run to do the upgrade<BR>
&gt; manually.&nbsp; I've searched metallink for a white paper or something,<BR>
&gt; but the only advice I've found is the imp/exp thing.&nbsp; Does anybody<BR>
&gt; have any productive advice or am I stuck trying to find 20gb of spare<BR>
&gt; disk in my shop?<BR>
&gt;&nbsp;<BR>
&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Robert 
 </DT>

<DT>I am assuming that you are doing this on a UNIX box and I am also assuming
that once you have the 7.3.2.1 software installed you are applying the madatory patch to go to 7.3.2.3.  This will also assume that you are installing in the same ORACLE_HOME.</DT>

<DT> </DT>

<DT>1) Make a damn good backup!</DT>

<DT>2) Deinstall all the 7.2 products.</DT>

<DT>3) Install the 7.3.2.1 products by choosing to "Add/Upgrade Software"</DT>

<DT>4) Apply the patches to get your kernel and products up to date with
the 7.3.2.3</DT>

<DT>    patch.  Make sure you upgrade the installer.  </DT>

<DT>5) Make sure ORACLE_BASE is not set.</DT>

<DT>6) Use the new installer to upgrade database objects.</DT>

<DT> </DT>

<DT>This should work.  If you are installing into a new ORACLE_HOME
of course you do not need to deinstall the 7.2 products.  Also there is another workaround but you need to modify the "unix.stp" and "unix.zoo" so it does not ask for a mount-point but this is easier and will work.</DT>

<DT> </DT>

<DT>Let me know if you run into any trouble. </DT>

</BODY>
</HTML>

------------44E514D719D323-- Received on Thu Mar 06 1997 - 00:00:00 CST