RE: Patch 8174 in 2nd Oracle Home

Here is what we ended up doing to get around this problem:

1. Removed oraInst.loc file (it is under /var/opt/oracle)
2. Installed 8.1.7.0 under O_H /u01/home/oracle/product/8.1.7.0 after setting ORACLE_BASE to ORACLE_HOME
3. Renamed oraInst.loc to oraInst_8170.loc
4. Installed 8.1.7.0 under O_H /u01/home/oracle/product/8.1.7.4 after setting ORACLE_BASE to ORACLE_HOME
5. Applied 8.1.7.4 patch to the ORACLE_HOME in (4)
6. Renamed oraInst.loc to oraInst_8174.loc

Setting ORACLE_BASE to ORACLE_HOME kept the OraInventory directory under each ORACLE_HOME. We found that safer to apply future patches.

This setup is working on a number of our servers running various Oracle versions (that use OraInventory stuff...)

HTH,

• Kirti

-----Original Message-----
Sent: Friday, May 16, 2003 12:08 PM
To: Multiple recipients of list ORACLE-L

When I applied 8.1.7.3 (not 8.1.7.4 though) to my 8.1.7 oracle db on Solaris 2.8, $ORACLE_HOME was not changed. If you already have 8.1.7 installed, you don't need another oracle home for 8.1.7.4. Your problem might be due to two copied of 8.1.7 vanilla on your system.

Guang

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Barbara
> Baker
> Sent: Friday, May 16, 2003 12:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Patch 8174 in 2nd Oracle Home
>
>
> I hate oui.
> hateithateithateithateithateithateithateit
>
> I need to upgrade an 8.0.5 database to 8.1.7.4
> (Solaris 2.6) Oracle will not support direct upgrade,
> so I need to upgrade 8.0.5 to 8.1.7, then as a
> separate step patch up to 8.1.7.4 So I need 2 8i
> oracle home's: the 8.1.7 vanilla which I'll delete as
> soon as the database is upgraded, and then the
> 8.1.7.4, the db's permanent home.
>
> I currently have 2 copies of 8.1.7 vanilla on 2
> separate mount points, and I'm trying to apply 8.1.7.4
> patchset to 1 of them. I set the environment for the
> correct directory tree, then run runInstaller. I
> consistently get the message "There are no patches
> that need to be applied from the patch set Oracle 8i
> Patchset 8.1.7.4". I assume this has something to do
> with the inventory location, but I don't know how to
> fix it.
>
> Any ideas?
> Thanks in advance for any help.
>
> Barb
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).