Download Oracle
Patches from Oracle
For this example the
patch files are stored in C:\shared
Download and extract
latest version of OPatch – replace existing OPatch in Oracle home directory.
Database Patch
c:\shared\p19542943_121010_MSWIN-x86-64\19542943>set
ORACLE_HOME=C:\oracle12c\product\12.1.0\dbhome_1
c:\shared\p19542943_121010_MSWIN-x86-64\19542943>echo %ORACLE_HOME%
C:\oracle12c\product\12.1.0\dbhome_1
c:\shared\p19542943_121010_MSWIN-x86-64\19542943>set
PATH=%ORACLE_HOME%\opatch;%PATH%
c:\shared\p19542943_121010_MSWIN-x86-64\19542943>opatch version
OPatch
Version: 12.1.0.1.5
OPatch
succeeded.
Open Windows Services
----->
STOP ORACLE
SERVICES
Open Command line and execute the following command to
stop Microsoft Distributed Transactions
-----> net stop msdtc
c:\shared\p19542943_121010_MSWIN-x86-64\19542943>opatch apply
Oracle Interim
Patch Installer version 12.1.0.1.5
Copyright (c)
2014, Oracle Corporation. All rights
reserved.
Oracle
Home :
C:\oracle12c\product\12.1.0\dbhome_1
Central
Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch
version : 12.1.0.1.5
OUI
version : 12.1.0.1.0
Log file
location : C:\oracle12c\product\12.1.0\dbhome_1\cfgtoollogs\opatch\1954
2943_Oct_28_2014_15_10_16\apply2014-10-28_15-10-16PM_1.log
Applying
interim patch '19542943' to OH 'C:\oracle12c\product\12.1.0\dbhome_1'
Verifying
environment and performing prerequisite checks...
Patch
19542943: Optional component(s) missing : [ oracle.oraolap, 12.1.0.1.0 ] ,
[ oracle.rdbms.ic, 12.1.0.1.0 ] , [
oracle.has.cfs, 12.1.0.1.0 ] , [ oracle.has
.crs,
12.1.0.1.0 ] , [ oracle.has.cvu, 12.1.0.1.0 ] , [ oracle.usm, 12.1.0.1.0 ]
All checks
passed.
Provide your
email address to be informed of security issues, install and
initiate
Oracle Configuration Manager. Easier for you if you use your My
Oracle Support
Email address/User Name.
Email
address/User Name: somebody@somewhere.com ß Use
your Oracle support e-mail or leave blank
Provide your
My Oracle Support password to receive security updates via your My
Oracle Support
account.
Password
(optional):********* ß Use your Oracle support password
The update may sit a blinking cursor for a long time on virtual machines
Please
shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home =
'C:\oracle12c\product\12.1.0\dbhome_1')
Is the local
system ready for patching? [y|n]
y
User Responded
with: Y
Backing
up files...
Patching
component oracle.rdbms, 12.1.0.1.0...
- - - LIST OF PATCHES WILL BE DISPLAYED - - -
Patching
component oracle.has.rsf, 12.1.0.1.0...
Verifying the
update...
Patch 19542943
successfully applied
Log file
location: C:\oracle12c\product\12.1.0\dbhome_1\cfgtoollogs\opatch\19542
943_Oct_28_2014_15_10_16\apply2014-10-28_15-10-16PM_1.log
OPatch
succeeded.
Java VM Patch - IF jvm component is enabled on the database.
Open Windows Command window
C:\> set ORACLE_HOME=
C:\oracle12c\product\12.1.0\dbhome_1
C:\> cd %ORACLE_HOME%\opatch
C:\oracle12c\product\12.1.0\dbhome_1\OPatch>opatch lsinventory
Oracle Interim
Patch Installer version 12.1.0.1.5
Copyright (c)
2014, Oracle Corporation. All rights
reserved.
Oracle
Home :
C:\oracle12c\product\12.1.0\dbhome_1
Central
Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch
version : 12.1.0.1.5
OUI
version : 12.1.0.1.0
Log file
location : C:\oracle12c\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opat
ch2014-11-07_16-35-32PM_1.log
Lsinventory
Output file location : C:\oracle12c\product\12.1.0\dbhome_1\cfgtooll
ogs\opatch\lsinv\lsinventory2014-11-07_16-35-32PM.txt
------------------------------------------------------------------------
Installed
Top-level Products (1):
Oracle
Database 12c
12.1.0.1.0
There are 1
products installed in this Oracle Home.
Interim
patches (1) :
Patch 19542943
: applied on Tue Oct 28 17:26:36 MDT 2014
Unique Patch
ID: 18159462
Patch
description: "WINDOWS DB BUNDLE
PATCH 12.1.0.1.14 (64bit): (19542943)"
Created on 15 Oct 2014, 05:44:18 hrs PST8PDT
Bugs fixed:
17716305, 17854334, 16694728, 17257820,
16042673, 18096714, 16476044
17439871, 16320173, 17762256, 16954950,
17006570, 17305959, 17710315
14506328, 17806676, 17443596, 16878635,
17804338, 16429953, 16845022
------------------------------------------------------------------------
OPatch
succeeded.
c:\oracle12c\product\12.1.0\dbhome_1\OPatch>cd c:\
c:> cd
c:\shared\Java-patch-p19801531_1210114forWindows_MSWIN-x86-64\19801531
c:\shared\Java-patch-p19801531_1210114forWindows_MSWIN-x86-64\19801531>set PATH=
%ORACLE_HOME%\opatch;%PATH%
c:\>cd
c:\shared\Java-patch-p19801531_1210114forWindows_MSWIN-x86-64\19801531
c:\shared\Java-patch-p19801531_1210114forWindows_MSWIN-x86-64\19801531>opatch prereq
CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim
Patch Installer version 12.1.0.1.5
Copyright (c)
2014, Oracle Corporation. All rights
reserved.
PREREQ session
Oracle
Home :
C:\oracle12c\product\12.1.0\dbhome_1
Central
Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch
version : 12.1.0.1.5
OUI
version : 12.1.0.1.0
Log file
location :
C:\oracle12c\product\12.1.0\dbhome_1\cfgtoollogs\opatch\opatch2014-11-07_16-49-21PM_1.log
Invoking
prereq "checkconflictagainstohwithdetail"
Prereq
"checkConflictAgainstOHWithDetail" passed.
OPatch
succeeded.
c:\shared\Java-patch-p19801531_1210114forWindows_MSWIN-x86-64\19801531>opatch apply
Oracle Interim
Patch Installer version 12.1.0.1.5
Copyright (c)
2014, Oracle Corporation. All rights
reserved.
Oracle
Home :
C:\oracle12c\product\12.1.0\dbhome_1
Central
Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch
version : 12.1.0.1.5
OUI
version : 12.1.0.1.0
Log file
location : C:\oracle12c\product\12.1.0\dbhome_1\cfgtoollogs\opatch\1980
1531_Nov_07_2014_16_49_52\apply2014-11-07_16-49-52PM_1.log
Applying
interim patch '19801531' to OH 'C:\oracle12c\product\12.1.0\dbhome_1'
Verifying
environment and performing prerequisite checks...
Patch
19801531: Optional component(s) missing : [ oracle.sqlj, 12.1.0.1.0 ] , [
oracle.sqlj.companion,
12.1.0.1.0 ]
All checks
passed.
Please
shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home =
'C:\oracle12c\product\12.1.0\dbhome_1')
Is the local
system ready for patching? [y|n]
y
User Responded
with: Y
Backing up
files...
Patching
component oracle.javavm.server, 12.1.0.1.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.1.0...
Patching
component oracle.rdbms, 12.1.0.1.0...
Verifying the
update...
Patch 19801531
successfully applied
Log file
location: C:\oracle12c\product\12.1.0\dbhome_1\cfgtoollogs\opatch\19801
531_Nov_07_2014_16_49_52\apply2014-11-07_16-49-52PM_1.log
OPatch
succeeded.
Use these instructions with caution. They may not be complete for your environment or situation...