Install Patch 25437695 component patch of combo patch 25434018 in Grid
Infrastructure 12.1.0.2 in Oracle Enterprise Linux 7.3 x64
Patch 25437695 is component-patch
of combo patch 25434018. First we install component-patch 25434003 and then 25437695.
Operating System: Oracle Enterprise Linux 7 Update 2 x64
Oracle Software: Or``acle Grid Infrastructure 12c R1 (12.1.0.2)
Prerequisites:
1.
Installed Oracle Grid
Infrastructure 12c R1 (12.1.0.2) (p17694377_121020_Linux-x86-64_3of8.zip and p17694377_121020_Linux-x86-64_4of8.zip)
2.
Download patch p25434018_121020_Linux-x86-64_12.1.0.2.170418_DB_GI_PSU.zip from My Oracle Support.
3.
Unzip patch in a staging
area. In my case I have the patch unzipped at “/media/sf_SharedFolder/DB12c/R1/Patch/”
4.
This patching procedure is
for Oracle Restart Environment, which means there is No-Shared Grid Infrastructure Home and No-Shared Oracle Database Home. There is no ACFS configured.
5.
Applied sub-component patch
25434003.
Please refer to my earlier post "Install Patch 25434003 component patch of combo patch 25434018 in Grid Infrastructure 12.1.0.2 in Oracle Enterprise Linux 7.3 x64" to see how to install sub-component patch 25434003.
6.
Always refer to README.html file provided with the
patch.
Assumptions:
1. $ORACLE_BASE= /u01/app/oracle
2. $ORACLE_HOME = /u01/app/oracle/product/12.1.0.2/db_1
3. Role segregation
has been implemented, which means grid user is used to install Grid
Infrastructure Binaries and oracle user is used to install Oracle
Database Binaries.
4. Patch p25434018_121020_Linux-x86-64_12.1.0.2.170418_DB_GI_PSU.zip includes 2
sub-component patches 25434003 and 25437695. This blog
is about installing component patch 25437695.
Patching Process:
1. Set oracle
user environment variables
Utility $ORACLE_HOME/OPatch/opatch has to be
executed as oracle user to
install this patch.
Profile of oracle user:
[oracle@db12c-01 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
.
~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export EDITOR=vi
export ORACLE_BASE=/u01/app/oracle
export
ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1
export
PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export ORACLE_SID=IIOCDB
export ORACLE_UNQNAME=IIOCDB
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH
[oracle@db12c-01 ~]$
2. Check opatch version
In order to install this patch, make sure the OPatch
utility version 12.1.0.1.2 or later is installed in $ORACLE_HOME.
[oracle@db12c-01 25434018]$
[oracle@db12c-01 25434018]$ which opatch
/u01/app/oracle/product/12.1.0.2/db_1/OPatch/opatch
[oracle@db12c-01 25434018]$
[oracle@db12c-01 25434018]$ opatch version
OPatch Version: 12.2.0.1.8
OPatch succeeded.
[oracle@db12c-01 25434018]$
3. Modify opatch executable
Refer to my earlier post opatch lsinventory throws "java.text.ParseException: Unparseable
date"
4. Check for
applied patches
Check for applied patches using “opatch lsinventory“ before
the patch is installed. At this time patch 25434003 has been
applied in $GRID_HOME and $ORACLE_HOME. Please refer to my earlierpost to Install sub-component patch 25434003 in Grid Infrastructure 12.1.0.2 in
Oracle Enterprise Linux 7.3 x64.
A sample output from $ORACLE_HOME
[oracle@db12c-01 25434018]$ opatch lsinventory
Oracle Interim Patch Installer version
12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version : 12.2.0.1.8
OUI version : 12.1.0.2.0
Log file location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_19-45-53PM_1.log
Lsinventory Output file location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_19-45-53PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: db12c-01
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c
12.1.0.2.0
There are 1 products installed in this Oracle
Home.
Interim patches (2) :
Patch
25363740 : applied on Fri Apr
28 21:38:16 AEST 2017
Unique Patch ID: 20990699
Patch description: "OCW Patch Set Update : 12.1.0.2.170418
(25363740)"
Created on 7 Mar 2017, 23:34:43 hrs PST8PDT
Bugs
fixed:
21339083, 18589889, 20768643, 19061429, 19133945, 19341538, 19521169
20011424, 19361757, 19187207, 19302350, 19130141, 19530755, 21441387
19028836, 19699720, 19620918, 19168690, 18899171, 17005215, 19244316
19653795, 18634372, 19471722, 19536337, 19184188, 19131709, 20160490
20995001, 21131037, 19380733, 20985167, 18943696, 20552947, 19591984
18135723,
18461246, 20014326, 19524857, 25250824, 18890943, 19154753
19499021, 25206628, 19046190, 20923930, 20028666, 24451580, 19051385
19050688, 19682695, 19831611, 22891868, 21607972, 18922918, 21087799
18956780, 19683886, 23757020, 19026993, 20110156, 21269977, 18261648
18362971, 19558324, 22651583, 20185476, 18882642, 19478119, 19414274
17447588, 19262534, 20752167, 19147513, 22475834, 18893463, 21242118
19514085, 20758997, 19659885, 19319904, 18703978, 23079844, 24796183
19700256, 19703246, 20467806, 19192901,
21527118, 19479503, 19147751
18901356, 21232394, 18964974, 22162062, 18835366, 19013789, 19207286
18950232, 22583325, 19148791, 19556820, 16505171, 21228405, 22261732
22135419, 19449737, 21878613, 21646169, 19187515, 19230771, 20795241
19453778, 19853036, 18843572, 18520351, 21430567, 19185148, 19232454
21220597, 18541110, 18834955, 19204743, 20175174, 19140891, 18747335
20676340, 19270660, 19325701, 20877003, 19222693, 19662663, 19684131
19010177, 19272663, 18910576, 18907170, 19426384, 9372680, 20737462
19700294, 20289828, 19331454, 22568500, 20278216, 20827053, 20119857
19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
19589221, 18952857, 19537762, 21152052, 16286734, 20669114, 18762843
18945249, 19184799, 19205086, 19351363, 20091753, 19031737, 19079087
19148367, 18968981, 19150517, 20231741, 19217019, 18730096, 18975620
19067804, 21259359, 19054979, 19209951, 19318983, 18747382, 19154673
18752378, 22905714, 19150088, 19013444, 19234177, 18999857, 19075747
19367276, 19612597, 19874047, 19677813, 23049292, 19427050, 18910443
20033787, 19148982, 19777496, 20730170, 24362631, 18523468, 19277814
20562133, 19071526, 21420753, 25537905, 18850051, 20433932, 20061168
18468128, 19370739, 20822591, 19609388, 18776786, 20136892, 18989446
19148793, 22904978, 19585454, 18317489, 19955755, 19059053, 19807548
19124972, 22229116, 18910748, 19147509, 18849896, 19617592, 19398098
22840085, 19076165, 19498411, 19704993, 21294273, 19459023, 20634511
21229744, 19516572, 21474380, 21484367, 20276459, 21550724, 17208793
19234907, 20007009, 19538714, 22867050, 22728264, 19383028, 19513969
22195657, 23111368, 19986391, 19314048, 18834934, 19473851, 19458082
18894342, 19522067, 23618734, 18116578, 19241857, 19076778, 19066699
25206563, 19068003, 18937186, 20267877, 19916737, 19770543, 22863466
19635215, 19613533, 21057239, 20783416, 19315522, 19141785, 19163887
19885321, 25233268, 18715868, 18852058, 19701617, 19280860, 19139608
21453435, 18946768, 19135521, 18604143, 23150001, 19627476, 20568884
20317221, 20177779, 19266658, 19491996, 24522717, 18330979, 19027351
21227730, 18707416, 21118157, 21113068, 19925992, 20235486, 20006646
15922206, 18439295, 18991776, 21245437, 23170839, 19163425, 19550195
20389257, 18849021, 18861196, 17940721, 18524834, 19287706, 19522313
18835283, 18748932, 19184765, 21639478, 14851828, 20598625, 19226141
19053891, 18871287, 25371730, 18998228, 18980002, 19682778, 19325604
8934841, 18777835, 17338864, 18945906, 19513650, 19702758, 18952577
19473088, 19178517, 18729269, 19529729, 19455563, 20877072, 23275930
20340620, 18536826, 19292605, 22264951, 20920711, 20660273, 20011635
17592037, 18935857, 22989069, 19029647, 19179158, 22302421, 23076471
19140712, 20012766, 23049301, 19184276, 25206643, 20510208, 20001507
20079414, 19680763, 19259765, 18962892, 19513888, 14661880, 21519340
21222147, 20218012, 19551830, 21616278, 19068333, 18945435, 20775015
19319192, 20839581, 19178629, 18774591, 21694237, 19304104, 19284357
22594310, 20725084, 19457575, 21297657, 19069755, 19021575, 18715884
19584688, 18798573, 19812592, 19018001, 19292272, 19270956, 21967791
21794779, 23055224, 18700893, 21276514, 20467377, 18406774, 20607821
21976167, 21082737, 21694632, 20115586, 20883009, 19164099, 18283792
19155350, 19884033, 19146822, 18798432, 21123424, 24356071, 19471836
20936562, 18750781, 19045143, 20559126, 22483804, 19146980, 19601003
20099624, 21378016, 19537547, 19281106, 18862203, 19954372, 18235274
19205617, 19513351, 20219458, 19150313, 18843054, 18708349, 19332386
18953639, 21423055, 19371270, 25221056, 19203996, 20038431, 19370846
21053036, 18998379, 20157569, 21357522, 19273577, 24709351, 25206634
22113170, 19632437, 18990354, 19288396, 20620581, 19557558, 19127078
22548137, 21792881, 20900588, 20053557, 22088198, 22664609, 19315567
19444471, 19154933, 20953798, 18290252, 18813323, 19915945, 19500293
18643483, 19134098, 23034352, 25206614, 18965694, 19226858, 19591356
19602208, 22884308, 20069197, 18417590, 18920408, 18263259, 18636884
22289350, 19043795, 20746507, 18260170, 18919682, 18678829, 19319357
19273758, 18953878, 18999195, 24314323, 18759724, 20458032, 19066844
13843841, 20290467, 22934855, 19649640, 19062675, 21924910, 18859710
20862812, 19504641, 23101611, 19341481, 20293730, 19343245, 18304090
19241655, 19470791, 18242738, 20649573, 18372060, 18953889, 18827679
19140711, 19023430, 19259290, 19045388, 20186278, 25197395, 19522571
19709663, 18875012, 18861564, 21075392, 19273760, 19225265, 15885689
20853464, 21696068, 18819158, 21394146, 19049721, 19368917, 25206650
21255373, 22393909, 20408163, 20579351, 18868829, 20350915, 21327402
22024217, 23101338, 19820247, 25206585, 20363708, 19538241, 19804032
Patch
25171037 : applied on Fri Apr
28 21:36:44 AEST 2017
Unique Patch ID: 21099266
Patch description: "Database Patch Set Update :
12.1.0.2.170418 (25171037)"
Created on 7 Mar 2017, 12:37:23 hrs PST8PDT
Sub-patch
24732082; "Database Patch Set Update : 12.1.0.2.170117
(24732082)"
Sub-patch
24006101; "Database Patch Set Update : 12.1.0.2.161018
(24006101)"
Sub-patch
23054246; "Database Patch Set Update : 12.1.0.2.160719
(23054246)"
Sub-patch
22291127; "Database Patch Set Update : 12.1.0.2.160419
(22291127)"
Sub-patch
21948354; "Database Patch Set Update : 12.1.0.2.160119
(21948354)"
Sub-patch
21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch
20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch
20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch
19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs
fixed:
19309466, 21172913, 19902195, 18250893, 25475853, 17655240, 19383839
21266085, 19028800, 19035573, 16756406, 19366375, 18456643, 24523374
19289642, 18845653, 19915271, 21291274, 18417036, 20475845, 22148226
22528741, 19243521, 19658708, 21153266, 19326908, 19597583, 17414008
20897759, 19174430, 22046677, 22243719, 24825843, 21960504, 19054077
22657942, 20688221, 20428621, 21899588, 21387964, 13542050, 19723336
19835133, 17532734, 19333670, 21373473, 23260854, 19687159, 14643995
20977794, 20734332, 19012119, 19869255, 17551063, 18681056, 21977392
23324000, 19676012, 20588502, 19520602, 19841800, 19439759, 20245930
19303936, 19001359, 21476308, 22916353, 19393542, 23533524, 21099555
22353346, 19141838, 19644859, 21106027, 21915719, 19908836, 21421886
22529728, 19358317, 19134173, 19524158, 20447445, 20803014, 23025340
21188584, 19335438, 19390567, 19058490, 18799993, 19769480, 19475971
21097043, 21225209, 20677396, 19284031, 19450314, 19016730, 18967382
20919320, 22075064, 20347562, 20348653, 22551446, 19896336, 24812585
20048359, 21896069, 22496904, 19524384, 18440095, 16439813, 18354830
20596234, 20440930, 22022760, 20936905, 19171086, 23197103, 17867700
19791273, 18990023, 21241829, 19591608, 22296366, 20173897, 17210525
18914624, 19571367, 21260431, 19501299, 20181030, 25056052, 20425790
21868720, 19124589, 19402853, 19888853, 16870214, 17722075, 18202441
18743542, 19001390, 20882568, 25546608, 19081128, 22173980, 21875360
19178851, 19149990, 20951038, 22168163, 16777441, 25161298, 19606174
24308635, 20848335, 20569094, 19791377, 19050649, 19382851, 20920911
20528052, 22762046, 19189525, 19469538, 20598042, 22458049, 18988834
19176326, 19048007, 22905130, 19238590, 20387265, 16941434, 21263635
24397438, 20673810, 22160989, 20356733, 22380919, 18499088, 18436647
21059919, 20825533, 18952989, 19124336, 22294260, 20794034, 19468347
20284155, 19883092, 20657441, 17365043, 25539063, 21285458, 20952966
25330273, 19176223, 21300341, 18288842, 19699191, 22353199, 24437510
22083366, 21419850, 20669434, 18964978, 19577410, 21373076, 14283239
19931709, 20368850, 21239530, 20880215, 20798891, 18122373, 20043616
23124895, 19013183, 18856999, 21450666, 21133343, 22695831, 18893947
21196809, 21354456, 19587324, 20464614, 24808595, 22062026, 19189317
18307021, 21917884, 19708632, 20711718, 20134339, 22077517, 22815955
24690216, 18973548, 22507210, 20101006, 20250147, 19197175, 23501901
18797519, 19597439, 21387128, 19180770, 19879746, 19354335, 21785691
19730508, 22366558, 24285405, 6599380, 21297872, 20322560, 18964939
22520320, 21575362, 20171986, 22365117, 21542577, 22507234, 23170620
20627866, 20124446, 16923858, 19518079, 19371175, 20466322, 18940497
19074147, 22923409, 20842388, 17274537, 21380789, 19154375, 20474192
19044962, 19532017, 19662635, 22374754, 20560611, 18899974, 18705806
20471920, 19052488, 22024071, 19503821, 22809871, 20074391, 21184223
23089357, 19157754, 21220620, 24316947, 18921743, 19865345, 19065677
19065556, 19018447, 19018206, 19777862, 22223463, 19304354, 20878790
21322887, 20879889, 20890311, 24350831, 19578350, 20869721, 21142837
21756699, 20217801, 18819908, 19363645, 25483815, 21072646, 20898391
19291380, 19593445, 20373598, 19248799, 20031873, 19155797, 19279273
18886413, 18618122, 25490238, 20922010, 19990037, 20509482, 24739928
18966843, 19077215, 20703000, 21526048, 20704450, 19068970, 21620471
19023822, 20543011, 19670108, 19068610, 20267166, 21756677, 20476175
18549238, 20328248, 18674047, 19385656, 18849537, 19684504, 20315311
20899461, 19308965, 19143550, 21911701, 19024808, 18948177, 19468991
20009833, 20868862, 20466628, 21756661, 20397490, 19706965, 22178855
19604659, 16359751, 19032777, 19329654, 20862087, 19928926, 18974476
23314180, 20212067, 20603378, 20859910, 19307662, 21847223, 21668627
20281121, 19075256, 20877664, 19487147, 19076343, 24577566, 19430401
19676905, 20844426, 20904530, 20925795, 20441797, 21296029, 21629064
21442094, 23229229, 22865673, 20708701, 25079710, 19280225, 21315084
18840932, 19213447, 18740837, 20294666, 19989009, 18191823, 21517440
22062517, 19174942, 17319928, 21889720, 19703301, 20122715, 18411216
20117253, 19258504, 21188532, 24386767, 17890099, 21649497, 16887946
25264559, 18791688, 19721304, 22092979, 19490948, 19619732, 21164318
20879709, 20165574, 19272708, 19818513, 19547370, 20139391, 24693382
20228093, 21281532, 19978542, 22165897, 22359063, 19409212, 19805359
19461270, 19434529, 18799063, 18990693, 20378086, 21246723, 17008068
21422580, 21632821, 20831538, 20424899, 22351572, 20361671, 18674024
19689979, 20235511, 23220453, 19873610, 16619249, 24411921, 20562898
21091431, 19440586, 22757364, 18610915, 22175564, 19561643, 19399918
19195895, 20832516, 20017509, 20907061, 21665897, 20746251, 19183343
21787056, 23096938, 21273804, 19067244, 18043064, 21329301, 18885870
19536415, 17835294, 25093739, 20446883, 21299490, 24413809, 21744290
18254023, 20591183, 20413820, 19185876, 22465352, 20558005, 20402832
19627012, 20093776, 18909599, 20618595, 16863642, 19639483, 19315691
20331945, 19512341, 21479753, 19637186, 19174521, 19022470, 18607546
20401975, 18306996, 18851894, 19649152, 20581111, 19201867, 20318889
20936731, 21060755, 21294938, 20898997, 18510194, 19534363, 19188927
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@db12c-01 25434018]$
5. Go to the top level patch folder
Go to the top level patch folder and check if the
patch files has been unzipped.
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25437695]$ cd
/media/sf_SharedFolder/DB12c/R1/Patch/25434018/25437695
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25437695]$ pwd
/media/sf_SharedFolder/DB12c/R1/Patch/25434018/25437695
[oracle@db12c-01 25437695]$ ls
etc files
README.html README.txt
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25434018]$ ls
25434003 25437695
README.html
[oracle@db12c-01 25434018]$
6. Check patches conflict
[oracle@db12c-01 25437695]$ pwd
Determine whether any currently
installed one-off patches conflict with the PSU patch as follows:
/media/sf_SharedFolder/DB12c/R1/Patch/25434018/25437695
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25437695]$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 12.2.0.1.8
Copyright (c) 2017, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home
: /u01/app/oracle/product/12.1.0.2/db_1
Central Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch version
: 12.2.0.1.8
OUI version
: 12.1.0.2.0
Log file location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_19-52-44PM_1.log
Invoking prereq
"checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail"
passed.
OPatch succeeded.
[oracle@db12c-01 25437695]$
7. Stop all the services running from $ORACLE_HOME
My $ORACLE_HOME has only 1 service running i.e. database IIOCDB so I will stop this database before applying the patch.
If there are any other services running from $ORACLE_HOME
then all these services should be stopped.
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25437695]$ srvctl stop
database -d IIOCDB
[oracle@db12c-01 25437695]$
#srvctl stop home -o
/u01/app/oracle/product/12.1.0.2/db_1/ -s /home/oracle/ora_stat.txt -t
IMMEDIATE
8. Apply the patch using opatch executable
As oracle user apply the patch.
[oracle@db12c-01
25437695]$ pwd
/media/sf_SharedFolder/DB12c/R1/Patch/25434018/25437695
[oracle@db12c-01
25437695]$
[oracle@db12c-01
25437695]$ opatch
apply
Oracle Interim
Patch Installer version 12.2.0.1.8
Copyright (c)
2017, Oracle Corporation. All rights
reserved.
Oracle
Home :
/u01/app/oracle/product/12.1.0.2/db_1
Central
Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file
location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_20-05-09PM_1.log
Verifying
environment and performing prerequisite checks...
OPatch
continues with these patches: 25437695
Do you want to
proceed? [y|n]
y
User Responded
with: Y
All checks
passed.
Please shutdown
Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home =
'/u01/app/oracle/product/12.1.0.2/db_1')
Is the local
system ready for patching? [y|n]
y
User Responded
with: Y
Backing up
files...
Applying
interim patch '25437695' to OH '/u01/app/oracle/product/12.1.0.2/db_1'
ApplySession:
Optional component(s) [ oracle.sqlj, 12.1.0.2.0 ] not present in the Oracle Home or a higher
version is found.
Patching
component oracle.javavm.server, 12.1.0.2.0...
Patching
component oracle.javavm.server.core, 12.1.0.2.0...
Patching
component oracle.rdbms.dbscripts, 12.1.0.2.0...
Patching
component oracle.rdbms, 12.1.0.2.0...
Patching
component oracle.javavm.client, 12.1.0.2.0...
Patching
component oracle.dbjava.jdbc, 12.1.0.2.0...
Patching
component oracle.dbjava.ic, 12.1.0.2.0...
Patch 25437695
successfully applied.
Log file
location:
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_20-05-09PM_1.log
OPatch
succeeded.
[oracle@db12c-01
25437695]$ opatch apply
Oracle Interim
Patch Installer version 12.2.0.1.8
Copyright (c)
2017, Oracle Corporation. All rights
reserved.
Oracle
Home :
/u01/app/oracle/product/12.1.0.2/db_1
Central
Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file
location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_20-06-44PM_1.log
Verifying
environment and performing prerequisite checks...
The following
patch(es) are duplicate patches with patches installed in the Oracle Home.
[ 25437695]
You have
already installed same patch(es) with same UPI(s) or same version(s).
These patch(es)
will be skipped.
OPatch Session
completed with warnings.
Log file
location: /u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_20-06-44PM_1.log
OPatch
completed with warnings.
[oracle@db12c-01
25437695]$
9. Check for the applied patch
Use “opatch lsinventory”
to check for the applied patch. The output below is from $ORACLE_HOME.
[oracle@db12c-01
25437695]$ opatch
lsinventory
Oracle
Interim Patch Installer version 12.2.0.1.8
Copyright
(c) 2017, Oracle Corporation. All rights
reserved.
Oracle
Home :
/u01/app/oracle/product/12.1.0.2/db_1
Central
Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.1.0.2/db_1/oraInst.loc
OPatch
version : 12.2.0.1.8
OUI
version : 12.1.0.2.0
Log file
location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/opatch2017-05-01_20-10-32PM_1.log
Lsinventory
Output file location :
/u01/app/oracle/product/12.1.0.2/db_1/cfgtoollogs/opatch/lsinv/lsinventory2017-05-01_20-10-32PM.txt
--------------------------------------------------------------------------------
Local
Machine Information::
Hostname:
db12c-01
ARU platform
id: 226
ARU platform
description:: Linux x86-64
Installed
Top-level Products (1):
Oracle
Database 12c
12.1.0.2.0
There are 1
products installed in this Oracle Home.
Interim
patches (3) :
Patch 25437695
: applied on Mon May 01 20:06:04 AEST 2017
Unique Patch
ID: 21057393
Patch
description: "Database PSU
12.1.0.2.170418, Oracle JavaVM Component (APR2017)"
Created on 27 Feb 2017, 10:29:56 hrs PST8PDT
Bugs fixed:
25437695, 25494413, 25494379, 24917972,
25067795, 24534298, 25076732
25076756, 24315824, 21659726, 24448240,
24448282, 23177536, 22675136
23265914, 23265965, 23727148, 22674709,
22670413, 22670385, 21188537
22139226, 22118835, 22118851, 21555660,
21811517, 19623450, 21566993
21566944, 19176885, 21068507, 21047803,
21047766, 20415564, 20408829
20408866, 19877336, 19855285, 19909862,
19895362, 19895326, 19153980
19231857, 19223010, 19245191, 19699946
Patch 25363740
: applied on Fri Apr 28 21:38:16 AEST 2017
Unique Patch
ID: 20990699
Patch
description: "OCW Patch Set Update
: 12.1.0.2.170418 (25363740)"
Created on 7 Mar 2017, 23:34:43 hrs PST8PDT
Bugs fixed:
21339083, 18589889, 20768643, 19061429,
19133945, 19341538, 19521169
20011424, 19361757, 19187207, 19302350,
19130141, 19530755, 21441387
19028836, 19699720, 19620918, 19168690,
18899171, 17005215, 19244316
19653795, 18634372, 19471722, 19536337,
19184188, 19131709, 20160490
20995001, 21131037, 19380733, 20985167,
18943696, 20552947, 19591984
18135723, 18461246, 20014326, 19524857,
25250824, 18890943, 19154753
19499021, 25206628, 19046190, 20923930,
20028666, 24451580, 19051385
19050688, 19682695, 19831611, 22891868,
21607972, 18922918, 21087799
18956780, 19683886, 23757020, 19026993,
20110156, 21269977, 18261648
18362971, 19558324, 22651583, 20185476,
18882642, 19478119, 19414274
17447588, 19262534, 20752167, 19147513,
22475834, 18893463, 21242118
19514085, 20758997, 19659885, 19319904,
18703978, 23079844, 24796183
19700256, 19703246, 20467806, 19192901,
21527118, 19479503, 19147751
18901356, 21232394, 18964974, 22162062,
18835366, 19013789, 19207286
18950232, 22583325, 19148791, 19556820,
16505171, 21228405, 22261732
22135419, 19449737, 21878613, 21646169,
19187515, 19230771, 20795241
19453778, 19853036, 18843572, 18520351,
21430567, 19185148, 19232454
21220597, 18541110, 18834955, 19204743,
20175174, 19140891, 18747335
20676340, 19270660, 19325701, 20877003,
19222693, 19662663, 19684131
19010177, 19272663, 18910576, 18907170,
19426384, 9372680, 20737462
19700294, 20289828, 19331454, 22568500,
20278216, 20827053, 20119857
19703199, 22456393, 20588164, 18955644,
20991879, 18508710, 19908346
19589221, 18952857, 19537762, 21152052,
16286734, 20669114, 18762843
18945249, 19184799, 19205086, 19351363,
20091753, 19031737, 19079087
19148367, 18968981, 19150517, 20231741,
19217019, 18730096, 18975620
19067804, 21259359, 19054979, 19209951,
19318983, 18747382, 19154673
18752378, 22905714, 19150088, 19013444,
19234177, 18999857, 19075747
19367276, 19612597, 19874047, 19677813,
23049292, 19427050, 18910443
20033787, 19148982, 19777496, 20730170,
24362631, 18523468, 19277814
20562133, 19071526, 21420753, 25537905,
18850051, 20433932, 20061168
18468128, 19370739, 20822591, 19609388,
18776786, 20136892, 18989446
19148793, 22904978, 19585454, 18317489,
19955755, 19059053, 19807548
19124972, 22229116, 18910748, 19147509,
18849896, 19617592, 19398098
22840085, 19076165, 19498411, 19704993,
21294273, 19459023, 20634511
21229744, 19516572, 21474380, 21484367,
20276459, 21550724, 17208793
19234907, 20007009, 19538714, 22867050,
22728264, 19383028, 19513969
22195657, 23111368, 19986391, 19314048,
18834934, 19473851, 19458082
18894342, 19522067, 23618734, 18116578,
19241857, 19076778, 19066699
25206563, 19068003, 18937186, 20267877,
19916737, 19770543, 22863466
19635215, 19613533, 21057239, 20783416,
19315522, 19141785, 19163887
19885321, 25233268, 18715868, 18852058,
19701617, 19280860, 19139608
21453435, 18946768, 19135521, 18604143,
23150001, 19627476, 20568884
20317221, 20177779, 19266658, 19491996,
24522717, 18330979, 19027351
21227730, 18707416, 21118157, 21113068,
19925992, 20235486, 20006646
15922206, 18439295, 18991776, 21245437,
23170839, 19163425, 19550195
20389257, 18849021, 18861196, 17940721,
18524834, 19287706, 19522313
18835283, 18748932, 19184765, 21639478,
14851828, 20598625, 19226141
19053891, 18871287, 25371730, 18998228,
18980002, 19682778, 19325604
8934841, 18777835, 17338864, 18945906,
19513650, 19702758, 18952577
19473088, 19178517, 18729269, 19529729,
19455563, 20877072, 23275930
20340620, 18536826, 19292605, 22264951,
20920711, 20660273, 20011635
17592037, 18935857, 22989069, 19029647,
19179158, 22302421, 23076471
19140712, 20012766, 23049301, 19184276,
25206643, 20510208, 20001507
20079414, 19680763, 19259765, 18962892,
19513888, 14661880, 21519340
21222147, 20218012, 19551830, 21616278,
19068333, 18945435, 20775015
19319192, 20839581, 19178629, 18774591,
21694237, 19304104, 19284357
22594310, 20725084, 19457575, 21297657,
19069755, 19021575, 18715884
19584688, 18798573, 19812592, 19018001,
19292272, 19270956, 21967791
21794779, 23055224, 18700893, 21276514,
20467377, 18406774, 20607821
21976167, 21082737, 21694632, 20115586,
20883009, 19164099, 18283792
19155350, 19884033, 19146822, 18798432,
21123424, 24356071, 19471836
20936562, 18750781, 19045143, 20559126,
22483804, 19146980, 19601003
20099624, 21378016, 19537547, 19281106,
18862203, 19954372, 18235274
19205617, 19513351, 20219458, 19150313,
18843054, 18708349, 19332386
18953639, 21423055, 19371270, 25221056,
19203996, 20038431, 19370846
21053036, 18998379, 20157569, 21357522,
19273577, 24709351, 25206634
22113170, 19632437, 18990354, 19288396,
20620581, 19557558, 19127078
22548137, 21792881, 20900588, 20053557,
22088198, 22664609, 19315567
19444471, 19154933, 20953798, 18290252,
18813323, 19915945, 19500293
18643483, 19134098, 23034352, 25206614,
18965694, 19226858, 19591356
19602208, 22884308, 20069197, 18417590,
18920408, 18263259, 18636884
22289350, 19043795, 20746507, 18260170,
18919682, 18678829, 19319357
19273758, 18953878, 18999195, 24314323,
18759724, 20458032, 19066844
13843841, 20290467, 22934855, 19649640,
19062675, 21924910, 18859710
20862812, 19504641, 23101611, 19341481,
20293730, 19343245, 18304090
19241655, 19470791, 18242738, 20649573,
18372060, 18953889, 18827679
19140711, 19023430, 19259290, 19045388,
20186278, 25197395, 19522571
19709663, 18875012, 18861564, 21075392,
19273760, 19225265, 15885689
20853464, 21696068, 18819158, 21394146,
19049721, 19368917, 25206650
21255373, 22393909, 20408163, 20579351,
18868829, 20350915, 21327402
22024217, 23101338, 19820247, 25206585,
20363708, 19538241, 19804032
Patch 25171037
: applied on Fri Apr 28 21:36:44 AEST 2017
Unique Patch
ID: 21099266
Patch description: "Database Patch Set Update :
12.1.0.2.170418 (25171037)"
Created on 7 Mar 2017, 12:37:23 hrs PST8PDT
Sub-patch 24732082; "Database Patch Set Update :
12.1.0.2.170117 (24732082)"
Sub-patch 24006101; "Database Patch Set Update :
12.1.0.2.161018 (24006101)"
Sub-patch 23054246; "Database Patch Set Update :
12.1.0.2.160719 (23054246)"
Sub-patch 22291127; "Database Patch Set Update :
12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update :
12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update :
12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update :
12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update :
12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update :
12.1.0.2.2 (19769480)"
Bugs fixed:
19309466, 21172913, 19902195, 18250893,
25475853, 17655240, 19383839
21266085, 19028800, 19035573, 16756406,
19366375, 18456643, 24523374
19289642, 18845653, 19915271, 21291274,
18417036, 20475845, 22148226
22528741, 19243521, 19658708, 21153266,
19326908, 19597583, 17414008
20897759, 19174430, 22046677, 22243719,
24825843, 21960504, 19054077
22657942, 20688221, 20428621, 21899588,
21387964, 13542050, 19723336
19835133, 17532734, 19333670, 21373473,
23260854, 19687159, 14643995
20977794, 20734332, 19012119, 19869255,
17551063, 18681056, 21977392
23324000, 19676012, 20588502, 19520602,
19841800, 19439759, 20245930
19303936, 19001359, 21476308, 22916353,
19393542, 23533524, 21099555
22353346, 19141838, 19644859, 21106027,
21915719, 19908836, 21421886
22529728, 19358317, 19134173, 19524158,
20447445, 20803014, 23025340
21188584, 19335438, 19390567, 19058490,
18799993, 19769480, 19475971
21097043, 21225209, 20677396, 19284031,
19450314, 19016730, 18967382
20919320, 22075064, 20347562, 20348653,
22551446, 19896336, 24812585
20048359, 21896069, 22496904, 19524384,
18440095, 16439813, 18354830
20596234, 20440930, 22022760, 20936905,
19171086, 23197103, 17867700
19791273, 18990023, 21241829, 19591608,
22296366, 20173897, 17210525
18914624, 19571367, 21260431, 19501299,
20181030, 25056052, 20425790
21868720, 19124589, 19402853, 19888853,
16870214, 17722075, 18202441
18743542, 19001390, 20882568, 25546608,
19081128, 22173980, 21875360
19178851, 19149990, 20951038, 22168163,
16777441, 25161298, 19606174
24308635, 20848335, 20569094, 19791377,
19050649, 19382851, 20920911
20528052, 22762046, 19189525, 19469538,
20598042, 22458049, 18988834
19176326, 19048007, 22905130, 19238590,
20387265, 16941434, 21263635
24397438, 20673810, 22160989, 20356733,
22380919, 18499088, 18436647
21059919, 20825533, 18952989, 19124336,
22294260, 20794034, 19468347
20284155, 19883092, 20657441, 17365043,
25539063, 21285458, 20952966
25330273, 19176223, 21300341, 18288842,
19699191, 22353199, 24437510
22083366, 21419850, 20669434, 18964978,
19577410, 21373076, 14283239
19931709, 20368850, 21239530, 20880215,
20798891, 18122373, 20043616
23124895, 19013183, 18856999, 21450666,
21133343, 22695831, 18893947
21196809, 21354456, 19587324, 20464614,
24808595, 22062026, 19189317
18307021, 21917884, 19708632, 20711718,
20134339, 22077517, 22815955
24690216, 18973548, 22507210, 20101006,
20250147, 19197175, 23501901
18797519, 19597439, 21387128, 19180770,
19879746, 19354335, 21785691
19730508, 22366558, 24285405, 6599380,
21297872, 20322560, 18964939
22520320, 21575362, 20171986, 22365117,
21542577, 22507234, 23170620
20627866, 20124446, 16923858, 19518079,
19371175, 20466322, 18940497
19074147, 22923409, 20842388, 17274537,
21380789, 19154375, 20474192
19044962, 19532017, 19662635, 22374754,
20560611, 18899974, 18705806
20471920, 19052488, 22024071, 19503821,
22809871, 20074391, 21184223
23089357, 19157754, 21220620, 24316947,
18921743, 19865345, 19065677
19065556, 19018447, 19018206, 19777862,
22223463, 19304354, 20878790
21322887, 20879889, 20890311, 24350831,
19578350, 20869721, 21142837
21756699, 20217801, 18819908, 19363645,
25483815, 21072646, 20898391
19291380, 19593445, 20373598, 19248799,
20031873, 19155797, 19279273
18886413, 18618122, 25490238, 20922010,
19990037, 20509482, 24739928
18966843, 19077215, 20703000, 21526048,
20704450, 19068970, 21620471
19023822, 20543011, 19670108, 19068610,
20267166, 21756677, 20476175
18549238, 20328248, 18674047, 19385656,
18849537, 19684504, 20315311
20899461, 19308965, 19143550, 21911701,
19024808, 18948177, 19468991
20009833, 20868862, 20466628, 21756661,
20397490, 19706965, 22178855
19604659, 16359751, 19032777, 19329654,
20862087, 19928926, 18974476
23314180, 20212067, 20603378, 20859910,
19307662, 21847223, 21668627
20281121, 19075256, 20877664, 19487147,
19076343, 24577566, 19430401
19676905, 20844426, 20904530, 20925795,
20441797, 21296029, 21629064
21442094, 23229229, 22865673, 20708701,
25079710, 19280225, 21315084
18840932, 19213447, 18740837, 20294666,
19989009, 18191823, 21517440
22062517, 19174942, 17319928, 21889720,
19703301, 20122715, 18411216
20117253, 19258504, 21188532, 24386767,
17890099, 21649497, 16887946
25264559, 18791688, 19721304, 22092979,
19490948, 19619732, 21164318
20879709, 20165574, 19272708, 19818513,
19547370, 20139391, 24693382
20228093, 21281532, 19978542, 22165897,
22359063, 19409212, 19805359
19461270, 19434529, 18799063, 18990693,
20378086, 21246723, 17008068
21422580, 21632821, 20831538, 20424899,
22351572, 20361671, 18674024
19689979, 20235511, 23220453, 19873610,
16619249, 24411921, 20562898
21091431, 19440586, 22757364, 18610915,
22175564, 19561643, 19399918
19195895, 20832516, 20017509, 20907061,
21665897, 20746251, 19183343
21787056, 23096938, 21273804, 19067244,
18043064, 21329301, 18885870
19536415, 17835294, 25093739, 20446883,
21299490, 24413809, 21744290
18254023, 20591183, 20413820, 19185876,
22465352, 20558005, 20402832
19627012, 20093776, 18909599, 20618595,
16863642, 19639483, 19315691
20331945, 19512341, 21479753, 19637186,
19174521, 19022470, 18607546
20401975, 18306996, 18851894, 19649152,
20581111, 19201867, 20318889
20936731, 21060755, 21294938, 20898997,
18510194, 19534363, 19188927
--------------------------------------------------------------------------------
OPatch
succeeded.
[oracle@db12c-01
25437695]$
10. Start the services from the $ORACLE_HOME
Start the services which we stopped earlier.
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25437695]$ srvctl start
database -d IIOCDB
[oracle@db12c-01 25437695]$
11. Check if the database type
Check if the database is Standalone or CDB/Multitenant.
The existence if IIOPDB1 PDB confirms this database is of
type CDB/multitenant.
[oracle@db12c-01
25437695]$
[oracle@db12c-01
25437695]$ .
oraenv
ORACLE_SID
= [IIOCDB] ?
The
Oracle base remains unchanged with value /u01/app/oracle
[oracle@db12c-01
25437695]$ sqlplus
'/as sysdba'
SQL*Plus:
Release 12.1.0.2.0 Production on Mon May 1 20:18:43 2017
Copyright
(c) 1982, 2014, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With
the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and
Real Application Testing options
SQL>
SELECT NAME FROM
V$PDBS;
NAME
------------------------------
PDB$SEED
IIOPDB1
SQL>
12. Load modified SQLs into Database
Now follow steps to load modified
SQLs into CDB/Multitenant database.
a.
Stop the database
[oracle@db12c-01 25437695]$ srvctl stop
database -d IIOCDB
b.
Start the database in upgrade mode
Start the CDB (Container) database in UPGRADE mode.
[oracle@db12c-01 25437695]$ . oraenv
ORACLE_SID = [IIOCDB] ?
The Oracle base remains unchanged
with value /u01/app/oracle
[oracle@db12c-01 25437695]$ sqlplus '/as
sysdba'
SQL*Plus: Release 12.1.0.2.0
Production on Mon May 1 20:26:46 2017
Copyright (c) 1982, 2014,
Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP UPGRADE
ORACLE instance started.
Total System Global Area
2399141888 bytes
Fixed Size 2927192 bytes
Variable Size 1459619240 bytes
Database Buffers 922746880 bytes
Redo Buffers 13848576 bytes
Database mounted.
Database opened.
SQL>
c.
Open all the pluggable database in upgrade mode
After the CDB is started in UPGRADE mode, open the PDBs in UPGRADE mode.
SQL>
SQL> ALTER PLUGGABLE DATABASE ALL OPEN UPGRADE;
Pluggable database altered.
SQL> SELECT NAME, OPEN_MODE FROM V$PDBS;
NAME OPEN_MODE
------------------------------ ----------
PDB$SEED MIGRATE
IIOPDB1 MIGRATE
SQL>
d.
Exit from SQL*Plus Session
SQL> EXIT
Disconnected from Oracle Database
12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic
Storage Management, OLAP, Advanced Analytics
and Real Application Testing
options
[oracle@db12c-01 25437695]$
e.
Go to OPatch directory
[oracle@db12c-01 25437695]$
[oracle@db12c-01 25437695]$ cd
$ORACLE_HOME/OPatch
[oracle@db12c-01 OPatch]$ pwd
/u01/app/oracle/product/12.1.0.2/db_1/OPatch
[oracle@db12c-01 OPatch]$
f.
Run datapatch
[oracle@db12c-01 OPatch]$ ./datapatch
-verbose
SQL Patching tool version
12.1.0.2.0 Production on Mon May 1
20:33:42 2017
Copyright (c) 2012, 2016,
Oracle. All rights reserved.
Log file for this invocation:
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_26588_2017_05_01_20_33_42/sqlpatch_invocation.log
Connecting to database...OK
Note: Datapatch will only apply or rollback SQL
fixes for PDBs
that are in an open state, no patches
will be applied to closed PDBs.
Please refer to Note: Datapatch:
Database 12c Post Patch SQL Automation
(Doc ID 1585822.1)
Bootstrapping registry and
package to current versions...done
Determining current state...done
Current state of SQL patches:
Patch 25437695 (Database PSU
12.1.0.2.170418, Oracle JavaVM Component (APR2017)):
Installed in the binary registry only
Bundle series PSU:
ID 170418 in the binary registry and ID 170418 in PDB CDB$ROOT, ID
170418 in PDB PDB$SEED
Adding patches to installation
queue and performing prereq checks...
Installation queue:
For the following PDBs: CDB$ROOT PDB$SEED
Nothing to roll back
The following patches will be applied:
25437695 (Database PSU 12.1.0.2.170418,
Oracle JavaVM Component (APR2017))
For the following PDBs: IIOPDB1
Nothing to roll back
The following patches will be applied:
25437695 (Database PSU 12.1.0.2.170418,
Oracle JavaVM Component (APR2017))
25171037 (DATABASE PATCH SET UPDATE
12.1.0.2.170418)
Installing patches...
Patch installation complete. Total patches installed: 4
Validating logfiles...
Patch 25437695 apply (pdb
CDB$ROOT): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/25437695/21057393/25437695_apply_IIOCDB_CDBROOT_2017May01_20_34_28.log
(no errors)
Patch 25437695 apply (pdb
PDB$SEED): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/25437695/21057393/25437695_apply_IIOCDB_PDBSEED_2017May01_20_36_18.log
(no errors)
Patch 25437695 apply (pdb
IIOPDB1): SUCCESS
logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/25437695/21057393/25437695_apply_IIOCDB_IIOPDB1_2017May01_20_36_55.log
(no errors)
Patch 25171037 apply (pdb
IIOPDB1): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/25171037/21099266/25171037_apply_IIOCDB_IIOPDB1_2017May01_20_37_35.log
(no errors)
SQL Patching tool complete on Mon
May 1 20:38:30 2017
[oracle@db12c-01 OPatch]$
g.
Restart the database
[oracle@db12c-01 OPatch]$ sqlplus '/as
sysdba'
SQL*Plus: Release 12.1.0.2.0
Production on Mon May 1 20:39:45 2017
Copyright (c) 1982, 2014,
Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise
Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic
Storage Management, OLAP, Advanced Analytics
and Real Application Testing
options
SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> EXIT
Disconnected from Oracle Database
12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic
Storage Management, OLAP, Advanced Analytics
and Real Application Testing
options
[oracle@db12c-01 OPatch]$
[oracle@db12c-01 OPatch]$ srvctl start
database -d IIOCDB
[oracle@db12c-01 OPatch]$
h.
Open all the pluggable databases
[oracle@db12c-01 OPatch]$ sqlplus '/as
sysdba'
SQL*Plus: Release 12.1.0.2.0
Production on Mon May 1 20:42:07 2017
Copyright (c) 1982, 2014,
Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise
Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic
Storage Management, OLAP, Advanced Analytics
and Real Application Testing
options
SQL> ALTER PLUGGABLE DATABASE ALL OPEN;
Pluggable database altered.
SQL> SELECT NAME, OPEN_MODE FROM V$PDBS;
NAME OPEN_MODE
------------------------------
----------
PDB$SEED READ ONLY
IIOPDB1 READ WRITE
SQL>
i.
Check log files for errors
Check the following log files in
$ORACLE_BASE/cfgtoollogs/sqlpatch/25437695/<unique patch ID> for errors:
25437695_apply_<database
SID>_<CDB name>_<timestamp>.log
Where database SID is the database SID, CDB name is the name of the
multitenant container database, and timestamp is of the form
YYYYMMMDD_HH_MM_SS.
[oracle@db12c-01 OPatch]$ cd
$ORACLE_BASE/cfgtoollogs/sqlpatch/25437695
[oracle@db12c-01 25437695]$ ls
21057393 >>>> unique patch id
[oracle@db12c-01 25437695]$ cd 21057393/
[oracle@db12c-01 21057393]$ ls
25437695_apply_IIOCDB_CDBROOT_2017May01_20_34_28.log
25437695_apply_IIOCDB_IIOPDB1_2017May01_20_36_55.log 25437695_apply_IIOCDB_PDBSEED_2017May01_20_36_18.log
[oracle@db12c-01 21057393]$
j.
Compile invalid packages
After installing the SQL portion of the patch, some packages could become
INVALID. This will get recompiled upon access or you can run utlrp.sql to get
them back into a VALID state.
[oracle@db12c-01 21057393]$
[oracle@db12c-01 21057393]$ cd
$ORACLE_HOME/rdbms/admin
[oracle@db12c-01 admin]$ sqlplus '/as
sysdba'
SQL*Plus: Release 12.1.0.2.0
Production on Mon May 1 20:47:16 2017
Copyright (c) 1982, 2014,
Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise
Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic
Storage Management, OLAP, Advanced Analytics
and Real Application Testing
options
SQL> @utlrp.sql
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_BGN 2017-05-01 20:47:24
DOC> The following PL/SQL block invokes
UTL_RECOMP to recompile invalid
DOC> objects in the database. Recompilation time
is proportional to the
DOC> number of invalid objects in the database,
so this command may take
DOC> a long time to execute on a database with a
large number of invalid
DOC> objects.
DOC>
DOC> Use the following queries to track
recompilation progress:
DOC>
DOC> 1. Query returning the number of invalid
objects remaining. This
DOC> number should decrease with time.
DOC> SELECT COUNT(*) FROM obj$ WHERE status
IN (4, 5, 6);
DOC>
DOC> 2. Query returning the number of objects
compiled so far. This number
DOC> should increase with time.
DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
DOC>
DOC> This script automatically chooses serial or
parallel recompilation
DOC> based on the number of CPUs available
(parameter cpu_count) multiplied
DOC> by the number of threads per CPU (parameter
parallel_threads_per_cpu).
DOC> On RAC, this number is added across all RAC
nodes.
DOC>
DOC> UTL_RECOMP uses DBMS_SCHEDULER to create
jobs for parallel
DOC> recompilation. Jobs are created without
instance affinity so that they
DOC> can migrate across RAC nodes. Use the
following queries to verify
DOC> whether UTL_RECOMP jobs are being created
and run correctly:
DOC>
DOC> 1. Query showing jobs created by UTL_RECOMP
DOC> SELECT job_name FROM
dba_scheduler_jobs
DOC> WHERE job_name like
'UTL_RECOMP_SLAVE_%';
DOC>
DOC> 2. Query showing UTL_RECOMP jobs that are
running
DOC> SELECT job_name FROM
dba_scheduler_running_jobs
DOC> WHERE job_name like
'UTL_RECOMP_SLAVE_%';
DOC>#
PL/SQL procedure successfully
completed.
TIMESTAMP
--------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END 2017-05-01 20:47:32
DOC> The following query
reports the number of objects that have compiled
DOC> with errors.
DOC>
DOC> If the number is higher
than expected, please examine the error
DOC> messages reported with
each object (using SHOW ERRORS) to see if they
DOC> point to system
misconfiguration or resource constraints that must be
DOC> fixed before attempting
to recompile these objects.
DOC>#
OBJECTS WITH ERRORS
-------------------
0
DOC> The following query
reports the number of errors caught during
DOC> recompilation. If this
number is non-zero, please query the error
DOC> messages in the table
UTL_RECOMP_ERRORS to see if any of these errors
DOC> are due to
misconfiguration or resource constraints that must be
DOC> fixed before objects can
compile successfully.
DOC>#
ERRORS DURING RECOMPILATION
---------------------------
0
Function created.
PL/SQL procedure successfully
completed.
Function dropped.
...Database user "SYS",
database schema "APEX_040200", user# "98" 20:48:07
...Compiled 0 out of 3014 objects
considered, 0 failed compilation 20:48:08
...271 packages
...263 package bodies
...452 tables
...11 functions
...16 procedures
...3 sequences
...457 triggers
...1320 indexes
...211 views
...0 libraries
...6 types
...0 type bodies
...0 operators
...0 index types
...Begin key object existence
check 20:48:08
...Completed key object existence
check 20:48:09
...Setting DBMS Registry 20:48:09
...Setting DBMS Registry Complete
20:48:09
...Exiting validate 20:48:09
PL/SQL procedure successfully
completed.
SQL>
Hope this helps.
