Fwd: OEM 12c - Where to find database patches applied

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Tue, 14 Jan 2014 10:24:20 -0400
Message-ID: <CAGYrQysrth_Pv8xv7h59AUsYB2ZSSf+qfhdePW43y6sy=X5xVg_at_mail.gmail.com>

• Forwarded message ---------- From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com> Date: 2014/1/14 Subject: Re: OEM 12c - Where to find database patches applied To: kmoore_at_zephyrus.com

Maybe you want this
1) In the database
select * from registry$history order by action_time desc;

2) in the engine of Oracle (I didn't patched too much but in 11g, you have to patch first the software of the database, and as a second task you have to patch inside the database)

set oracle_home=C:\app\product\11.2.0.3\dbhome_2 c:
cd C:\app\product\11.2.0.3\dbhome_2\OPatch opatch lsinventory

Ejemplo:

C:\app\product\11.2.0.3\dbhome_2\OPatch>opatch lsinventory

Installer de Parche Temporal de Oracle versi¾n 11.2.0.3.3 Copyright (c) 2012, Oracle Corporation. Todos los Derechos Reservados.

Oracle Home       : C:\app\product\1120~1.3\dbhome_2
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.3.3
OUI version       : 11.2.0.3.0
Log file location :

C:\app\product\1120~1.3\dbhome_2\cfgtoollogs\opatch\opatch2013-03-12_15-02-54PM_ 1.log

Lsinventory Output file location :
C:\app\product\1120~1.3\dbhome_2\cfgtoollogs\opatch\lsinv\lsinven tory2013-03-12_15-02-54PM.txt

---

Productos de nivel superior instalados (1):

Oracle Database 11g
 11.2.0.3.0
Hay 1 productos instalados en este directorio raÝz de Oracle.

Parches temporales (1) :

Patch 16042648 : applied on Thu Mar 07 11:00:44 BOT 2013 Unique Patch ID: 15646955
Patch description: "ORACLE 11G 11.2.0.3 PATCH 15 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64)"
   Created on 10 Jan 2012, 00:06:51 hrs PST8PDT    Bugs fixed:
     16042648, 13337530, 14810890, 13605675, 7335665, 12686027, 16011871  .......

2014/1/13 Keith Moore <kmoore_at_zephyrus.com>

> I need to know what patches have been applied to a database. In OEM 11g I
> could do that by going to the target database and selecting "Software and
> Support" and the "Oracle Home inventory".
>
> For the life of me I can't find the same information in OEM 12c.
>
> Can some help out a long time DBA but OEM newbie?
>
> Thanks
> Keith
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 14 2014 - 15:24:20 CET