Fwd: OEM 12c - Where to find database patches applied
- From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 14 Jan 2014 10:24:20 -0400
---------- Forwarded message ----------
From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
Date: 2014/1/14
Subject: Re: OEM 12c - Where to find database patches applied
To: kmoore@xxxxxxxxxxxx
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@xxxxxxxxxxxx>
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
- » Fwd: OEM 12c - Where to find database patches applied - Juan Carlos Reyes Pacheco
