Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to patch oracle database dataguard on windows

dbapeSep 7 2015 — edited Sep 8 2015

Hi friends,

I need to update an Oracle Database 11g Dataguard on Windows 8 Pro x64, with the last Critical Patch Update available for this configuration. I have read that there is a CPU 20833831 (July 2015).

What Oracle documents do you suggest to read? or what are the steps that I must follow? Or what is the best way to accomplish this task?

Details from database PRIMARY:

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Personal Oracle Database 11g Release 11.2.0.4.0 - Production

PL/SQL Release 11.2.0.4.0 - Production

CORE    11.2.0.4.0      Production

TNS for 32-bit Windows: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> SELECT * FROM registry$history;

ACTION_TIME                  ACTION                    NAMESPACE    VERSION            ID COMMENTS                    BUNDLE_SERIES

---------------------------- ------------------------- ------------ ---------- ---------- ----------------------------------- -----

07/08/14 21:59:26,422000     APPLY                     SERVER       11.2.0.4            4 WinBundle 11.2.0.4.4                PSU

SQL>

C:\app\product\11.2.0\dbhome_1\OPatch>opatch lsinventory

Installer de Parche Temporal de Oracle versi¾n 11.2.0.3.6

Copyright (c) 2013, Oracle Corporation. Todos los Derechos Reservados.

Oracle Home       : C:\app\product\112~1.0\dbhome_1

Central Inventory : C:\Program Files (x86)\Oracle\Inventory

   from           : n/a

OPatch version    : 11.2.0.3.6

OUI version       : 11.2.0.4.0

Log file location : C:\app\product\112~1.0\dbhome_1\cfgtoollogs\opatch\opatch2015-09-06_19-54-29PM_1.log

Lsinventory Output file location : C:\app\product\112~1.0\dbhome_1\cfgtoollogs\opatch\lsinv\lsinventory2015-09-06_19-54-29PM

--------------------------------------------------------------------------------

Productos de nivel superior instalados (1):

Oracle Database 11g                                                  11.2.0.4.0

Hay 1 productos instalados en este directorio raÝz de Oracle.

Parches temporales (1) :

Patch  18296644     : applied on Thu Aug 07 18:48:26 COT 2014

Unique Patch ID:  17560341

Patch description:  "WINDOWS DB BUNDLE PATCH 11.2.0.4.4 : (18296644)"

   Created on 22 Apr 2014, 02:01:38 hrs

   Bugs fixed:

     16809786, 17716305, 16180763, 17545847, 17597748, 16992075, 17610798

     18235390, 17446237, 16450169, 16731148, 17761775, 14602788, 17726838

     17441661, 17050888, 17622427, 17546761, 13866822, 16315398, 17215306

     17040764, 14010183, 16837842, 16228604, 17346671, 18084625, 16683112

     14133975, 17721717, 17602269, 16777840, 17577218, 17071721, 16929165

     18241194, 17080436, 17265217, 17036973, 16698971, 4189542, 14852021

     16399083, 13609098, 17493764, 16785708, 17987366, 16187992, 17781991

     17313525, 16833527, 16618694, 17741995, 11733603, 14285317, 17341326

     16491477, 17357979, 17344412, 17088068, 17332800, 13498243, 16850630

     17783588, 14580303, 16296213, 18223971, 17393683, 18069285, 16863422

     16069901, 17443671, 17897511, 18296644, 17389192, 17394950, 10136473

     17785632, 14458214, 18069723, 17397545, 17186905, 17325413, 13364795

     16472716, 17468141, 13944971, 17883081, 16721594, 13853126, 18088509

     17205719, 16849620, 17284817, 17239687, 17079301, 18180390, 16976121

     17235750, 17951124, 17564992, 17754782, 17082359, 16314254, 17478145

     18154779, 18160822, 16613964, 17174582, 16043574, 17865671, 16943711

     18232462, 17612828, 17375354, 17393915, 17571306, 16825679, 18230522

     17546973, 17209410, 16633319, 16956380, 13077335, 16470836, 18328509

     12905058, 17921190, 17799716, 17614227, 18094246, 18018515, 18034871

     17672719, 16912439, 17385178, 16394467, 16220077, 17016369, 18115594

     17501491, 17027426, 17591148, 16875449, 17465741, 17752121, 17892268

     17614134, 14829250, 17288409, 17296856, 16285691, 17390431, 14338435, 17323222

--------------------------------------------------------------------------------

OPatch succeeded.

Best Regards,

dbape.

This post has been answered by Pavan Kumar on Sep 7 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2015
Added on Sep 7 2015
2 comments
920 views