Patch
27674384 - Database Apr 2018 Release Update 12.2.0.1.180417
Note that Oracle 12cR2(12.1.02) and above uses
new RUs (Release Update)
and RURs (Release Update
Revisions) patches which replaces the old CPU/PSU patching concepts.
These new patches will be applied in the similar opatch utility using RAC Rolling or Data Guard/GG
switchover techniques. You can switch back and forth between RUs and RURs. Both
patches are released quarterly.
RUs (Release Update):
- This contain Query
optimizer fixes which can change execution plans but this must be enabled
manually after patching.
- There are separate
Database RU, Grid Infrastructure RU, and OJVM RU.
RURs (Release Update Revisions):
- This is similar like
former PSUs.
- This contain security
and regression fixes.
- These are not
available for Windows OS.
Here, I am applying RU patch Apr-2018 27674384.
Step 1: Check how
many databases are running on OS and how many Oracle homes exist on server.
[oracle@test ~]$ env
| grep ORA
ORACLE_SID=orcl
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1
[oracle@test ~]$ ps
-ef | grep pmon
oracle 21468 1 0
14:31 ? 00:00:00 ora_pmon_orcl
oracle 24081
15283 0 14:40 pts/1 00:00:00 grep --color=auto pmon
[oracle@test ~]$ ps
-ef | grep tns
root 15 2 0
11:23 ? 00:00:00 [netns]
oracle 16412 1 0
14:16 ? 00:00:00
/u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr LISTENER_MANOJ -inherit
oracle 17780 1 0
14:19 ? 00:00:00
/u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 24109
15283 0 14:40 pts/1 00:00:00 grep --color=auto tns
[oracle@test ~]$ ps -ef | grep agent
rupesh 2161 1946 0
11:23 ? 00:00:00 /usr/bin/ssh-agent
/bin/sh -c exec -l /bin/bash -c "env GNOME_SHELL_SESSION_MODE=classic
gnome-session --session gnome-classic"
oracle 3809 3607 0
11:30 ? 00:00:00
/usr/bin/ssh-agent /bin/sh -c exec -l /bin/bash -c "env
GNOME_SHELL_SESSION_MODE=classic gnome-session --session gnome-classic"
oracle 24174
15283 0 14:40 pts/1 00:00:00 grep --color=auto agent
Step 2: Check whether
PDBs exist in the database and check free space is available on server.
SQL> select con_id,name,open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
------- --------- -------------
2 PDB$SEED READ ONLY
3 ORCLPDB READ WRITE
[oracle@test u01]$ df
-h /u02
Filesystem
Size Used Avail Use% Mounted on
/dev/mapper/ol-root
39G 26G 14G
66% /
Step 3: Download
latest RU patch for 12.2.0.1 database hosted on oel 7.5 server.
Step 4: Set PATH
variable and check current opatch version.
[oracle@test u01]$ export PATH=$ORACLE_HOME/OPatch:$PATH
[oracle@test u01]$ opatch version
OPatch Version: 12.2.0.1.6
OPatch succeeded.
You must use the
OPatch utility version 12.2.0.1.12 or later to apply this patch. Oracle
recommends that you use the latest released OPatch version for 12.2, which is
available for download from My Oracle Support patch 6880880 by selecting the 12.2.0.1.0
release.
I have downloaded new opatch version and replaced with
existing opatch after taking backup of the opatch directory.
[root@test ~]# cd /media/sf_Oracle_12c_R2_Installation/
[root@test
sf_Oracle_12c_R2_Installation]# ll
total 11063104
-rwxrwx--- 1 root vboxsf
207525705 Jun 3 14:39
p27674384_122010_Linux-x86-64.zip
-rwxrwx--- 1 root vboxsf
97422646 Jun 3 14:48 p6880880_180000_Linux-x86-64.zip
[root@test
sf_Oracle_12c_R2_Installation]# cp p6880880_180000_Linux-x86-64.zip /u02
[root@test sf_Oracle_12c_R2_Installation]# chmod 777
/u02/p6880880_180000_Linux-x86-64.zip
[root@test
sf_Oracle_12c_R2_Installation]# cp p27674384_122010_Linux-x86-64.zip /u02
[root@test sf_Oracle_12c_R2_Installation]# chmod 777
/u02/p27674384_122010_Linux-x86-64.zip
[oracle@test u01]$ cd /u02
[oracle@test u02]$ ls -ltr
total 297804
drwxr-xr-x 7 oracle oinstall 117 Jan 26 2017 database
-rwxrwxrwx 1 root
root 97422646 Jun 3 14:50 p6880880_180000_Linux-x86-64.zip
-rwxrwxrwx 1 root root 207525705 Jun 3 14:51 p27674384_122010_Linux-x86-64.zip
[oracle@test u02]$ unzip p6880880_180000_Linux-x86-64.zip
oracle@test u02]$ ls -ltr
total 297808
drwxr-xr-x 7 oracle
oinstall 117 Jan 26 2017 database
drwxr-x--- 14 oracle oinstall 4096 Apr 16 14:28 OPatch
-rwxrwxrwx 1
root root 97422646 Jun 3 14:50 p6880880_180000_Linux-x86-64.zip
-rwxrwxrwx 1
root root 207525705 Jun 3 14:51 p27674384_122010_Linux-x86-64.zip
[oracle@test u02]$ cd $ORACLE_HOME/
[oracle@test
dbhome_1]$ ls -ld OPatch
drwxr-xr-x 12 oracle oinstall 4096 May 31 15:37 OPatch
[oracle@test
dbhome_1]$ mv OPatch bkp_OPatch
[oracle@test
dbhome_1]$ mv /u02/OPatch/ .
[oracle@test
dbhome_1]$ ls -ld OPatch/
drwxr-x--- 14 oracle oinstall 4096 Apr 16 14:28 OPatch/
Now my current Opatch version is replaced with new Opatch
version.
[oracle@test dbhome_1]$ opatch version
OPatch Version: 12.2.0.1.13
OPatch succeeded.
Step 5: You can
check last applied patch on using below commands.
SQL> select patch_id,version,action,status,action_time,description
from dba_registry_sqlpatch;
no rows selected
[oracle@test dbhome_1]$ opatch lsinventory | grep applied
[oracle@test
dbhome_1]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version :
12.2.0.1.13
OUI version :
12.2.0.1.4
Log file location :
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-06-03_14-56-57PM_1.log
Lsinventory Output file location :
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-06-03_14-56-57PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c
12.2.0.1.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
OPatch succeeded.
[oracle@test u02]$ pwd
/u02
[oracle@test u02]$ ls
-ltr
total 202664
drwxr-xr-x 7 oracle oinstall 117 Jan 26
2017 database
-rwxrwxrwx 1 root
root 207525705 Jun 3 14:51 p27674384_122010_Linux-x86-64.zip
[oracle@test u02]$ df -h .
Filesystem
Size Used Avail Use% Mounted on
/dev/mapper/ol-root
39G 26G 13G
68% /
Step 6: Unzip the
downloaded patch.
[oracle@test u02]$ unzip p27674384_122010_Linux-x86-64.zip
Archive:
p27674384_122010_Linux-x86-64.zip
creating: 27674384/
inflating:
27674384/README.html
extracting:
27674384/README.txt
creating:
27674384/etc/
creating: 27674384/files/rdbms/xml/em/orarep/
creating:
27674384/files/rdbms/xml/em/orarep/exadata/
inflating:
27674384/files/rdbms/xml/em/orarep/exadata/emExadata.swf
inflating:
27674384/files/rdbms/xml/em/orarep/exadata/exadataHtml.xsl
inflating:
27674384/files/rdbms/xml/em/orarep/exadata/exadataDiffHtml.xsl
inflating:
PatchSearch.xml
[oracle@test u02]$ ls -ltr
total 202780
drwxr-xr-x 7 oracle oinstall 117 Jan 26 2017 database
drwxr-xr-x 4 oracle oinstall 67 Apr
9 13:13 27674384
-rw-rw-r-- 1 oracle oinstall 117390 Apr 17 17:58 PatchSearch.xml
-rwxrwxrwx 1 root
root 207525705 Jun 3 14:51 p27674384_122010_Linux-x86-64.zip
Step 7: Perform
prerequisites using below command.
[oracle@test 27674384]$ opatch prereq CheckConflictAgainstOHWithDetail
-ph ./
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home :
/u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version :
12.2.0.1.13
OUI version :
12.2.0.1.4
Log file location :
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-06-03_15-00-29PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Step 8: Shut down
all Oracle Services.
- PDBs
- Database
- Listener
- Agent
- TFA
[oracle@test 27674384]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jun 3
15:01:02 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 -
64bit Production
SQL> alter pluggable database all close;
Pluggable database altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition
Release 12.2.0.1.0 - 64bit Production
[oracle@test 27674384]$ ps -ef | grep tns
root 15 2 0
11:23 ? 00:00:00 [netns]
oracle 16412 1 0
14:16 ? 00:00:00 /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr
LISTENER_MANOJ -inherit
oracle 17780 1 0
14:19 ? 00:00:00
/u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr LISTENER -inherit
oracle 31434
29176 0 15:02 pts/1 00:00:00 grep --color=auto tns
[oracle@test 27674384]$ lsnrctl stop
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on
03-JUN-2018 15:02:10
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.localdomain)(PORT=1521)))
The command completed successfully
[oracle@test 27674384]$ lsnrctl stop LISTENER_MANOJ
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on
03-JUN-2018 15:02:17
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.localdomain)(PORT=1522)))
The command completed successfully
[oracle@test 27674384]$
ps -ef | grep pmon
oracle 31683
29176 0 15:02 pts/1 00:00:00 grep --color=auto pmon
[oracle@test
27674384]$ ps -ef | grep tns
root 15 2 0
11:23 ? 00:00:00 [netns]
oracle 31700
29176 0 15:02 pts/1 00:00:00 grep --color=auto tns
Login by root user
and then stop tfa which is owned by root user.
[oracle@test ~]$ su -
Password:
Last login: Sun Jun 3
15:20:20 IST 2018 on pts/1
[root@test ~]# /etc/init.d/init.tfa tfactl disable
Usage: /etc/init.d/init.tfa {stop|start|shutdown|restart}
[root@test ~]# /etc/init.d/init.tfa shutdown
Shutting down TFA
Removed symlink
/etc/systemd/system/multi-user.target.wants/oracle-tfa.service.
Removed symlink
/etc/systemd/system/graphical.target.wants/oracle-tfa.service.
. . . . .
. . .
Successfully shutdown TFA..
Here I have disabled TFA as this is my testing server.
Ensure that all
Oracle Services have been stopped.
[oracle@test ~]$ ps -ef | grep pmon
oracle 16352
16296 0 15:54 pts/0 00:00:00 grep --color=auto pmon
[oracle@test ~]$ ps -ef | grep tns
root 15 2 0
15:07 ? 00:00:00 [netns]
oracle 16356
16296 0 15:54 pts/0 00:00:00 grep --color=auto tns
[oracle@test ~]$ ps -ef | grep tfa
oracle 16361
16296 0 15:54 pts/0 00:00:00 grep --color=auto tfa
[oracle@test ~]$ ps -ef | grep oracle
root 16289
15909 0 15:54 pts/0 00:00:00 su - oracle
oracle 16296
16289 0 15:54 pts/0 00:00:00 -bash
oracle 16365
16296 0 15:54 pts/0 00:00:00 ps -ef
oracle 16366
16296 0 15:54 pts/0 00:00:00 grep --color=auto oracle
Step 9: Apply the
patch using “opatch apply” command.
[oracle@test 27674384]$ opatch apply
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version :
12.2.0.1.13
OUI version :
12.2.0.1.4
Log file location :
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-06-03_15-55-42PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 27674384
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.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '27674384' to OH
'/u01/app/oracle/product/12.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.has.crs, 12.2.0.1.0
] , [ oracle.oid.client, 12.2.0.1.0 ] , [ oracle.ons.daemon, 12.2.0.1.0 ] , [
oracle.network.cman, 12.2.0.1.0 ] not
present in the Oracle Home or a higher version is found.
Patching component oracle.network.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.deconfig, 12.2.0.1.0...
Patching component oracle.tfa, 12.2.0.1.0...
Patching component oracle.rdbms.dbscripts, 12.2.0.1.0...
Patching component oracle.assistants.server, 12.2.0.1.0...
Patching component oracle.has.deconfig, 12.2.0.1.0...
Patching component oracle.ctx.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.dv, 12.2.0.1.0...
Patching component oracle.rdbms.oci, 12.2.0.1.0...
Patching component oracle.ldap.rsf, 12.2.0.1.0...
Patching component oracle.precomp.common, 12.2.0.1.0...
Patching component oracle.rdbms.crs, 12.2.0.1.0...
Patching component oracle.ctx, 12.2.0.1.0...
Patching component oracle.xdk, 12.2.0.1.0...
Patching component oracle.nlsrtl.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rsf, 12.2.0.1.0...
Patching component oracle.precomp.lang, 12.2.0.1.0...
Patching component oracle.ldap.client, 12.2.0.1.0...
Patching component oracle.rdbms.util, 12.2.0.1.0...
Patching component oracle.rdbms, 12.2.0.1.0...
Patching component oracle.xdk.parser.java, 12.2.0.1.0...
Patching component oracle.xdk.rsf, 12.2.0.1.0...
Patching component oracle.rdbms.rman, 12.2.0.1.0...
Patching component oracle.oracore.rsf, 12.2.0.1.0...
Patching component oracle.ldap.rsf.ic, 12.2.0.1.0...
Patching component oracle.ons, 12.2.0.1.0...
Patching component oracle.rdbms.lbac, 12.2.0.1.0...
Patching component oracle.rdbms.rsf.ic, 12.2.0.1.0...
Patching component oracle.sdo, 12.2.0.1.0...
Patch 27674384
successfully applied.
Log file location: /u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-06-03_15-55-42PM_1.log
OPatch succeeded.
You can verify applied patch using below procedure.
[oracle@test 27674384]$ opatch lsinventory | grep applied
Patch 27674384 : applied on Sun Jun 03 15:56:50 IST 2018
[oracle@test 27674384]$ opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.13
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home :
/u01/app/oracle/product/12.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from :
/u01/app/oracle/product/12.2.0/dbhome_1/oraInst.loc
OPatch version :
12.2.0.1.13
OUI version :
12.2.0.1.4
Log file location :
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/opatch2018-06-03_15-59-26PM_1.log
Lsinventory Output file location :
/u01/app/oracle/product/12.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2018-06-03_15-59-26PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: test.localdomain
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c
12.2.0.1.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 27674384 : applied on Sun Jun 03 15:56:50 IST 2018
Unique Patch ID:
22098633
Patch description:
"Database Apr 2018 Release Update :
12.2.0.1.180417 (27674384)"
Created on 9 Apr 2018,
00:43:55 hrs PST8PDT
Bugs fixed:
23026585,
24336249, 24929210, 24942749, 25036474, 25110233, 25410877
25417050,
25427662, 25459958, 25547901, 25569149, 25600342, 25600421
25606091,
25655390, 25662088, 24385983, 24923215, 25099758, 25429959
25662101,
25728085, 25823754, 22594071, 23665623, 23749454, 24326846
24334708,
24560906, 24573817, 24578797, 24609996, 24624166, 24668398
24674955,
24744686, 24811725, 24827228, 24831514, 24908321, 24976007
25184555,
25210499, 25211628, 25223839, 25262869, 25316758, 25337332
25455795,
25457409, 25539063, 25546608, 25612095, 25643931, 25410017
22729345,
24485174, 24509056, 24714096, 25329664, 25410180, 25607726
25957038,
25973152, 26024732, 24376878, 24589590, 24676172, 23548817
24796092,
24907917, 25044977, 25736747, 25766822, 25856821, 25051628
24534401,
24835919, 25050160, 25395696, 25430120, 25616359, 25715167
25967985,
26546754, 26546664, 26544823, 26575788, 26271001, 26198926
26025681, 26078437,
25789579, 25034396, 24655717, 25124363, 23527363
25530814,
21981529, 25062592, 25057811, 23179662, 25530080, 25528838
25417056,
25100579, 25739065, 25700654, 25655966, 25631933, 25616645
25616417,
25594901, 25825910, 25789041, 22568728, 21159907, 20736227
19327292,
14690846, 25099497, 24938784, 25257085, 25237577, 25230945
25425760,
25337640, 25263960, 22654475, 21186167, 23491861, 23300142
23234232,
23151677, 22981722, 23733981, 24556967, 24485161, 24457597
24737064, 24578718,
24792678, 20324049, 17533661, 17027695, 22645009
22628825,
23521523, 23499160, 24289874, 24421668, 24332831, 24425998
24555417,
24737403, 25121089, 25192729, 25164293, 25150925, 25579761
25570929,
25980605, 25954022, 25797124, 26308650, 26261327, 26088836
25874050,
25178179, 25176408, 22072543, 23735292, 21985256, 22950945
23746128,
25175723, 25451531, 25575628, 25838361, 25932524, 26479173
26526726,
26609942, 24717183, 26362821, 25397936, 25554787, 26523432
26599395,
26331743, 26476244, 26388538, 25498930, 26421667, 26446098
26108080,
25648731, 25087436, 24812047, 25382812, 25695903, 25797092
22179537,
26111842, 19285025, 25558986, 25551676, 24642495, 25633101
25852885,
25897615, 26486365, 26333141, 26537307, 26444887, 26396790
26358670,
26244115, 25489607, 25947799, 26095405, 26492866, 25248384
26430737,
26187943, 26426526, 22898198, 23581777, 25694206, 26088426
26045732,
24693290, 26153977, 25654936, 25870579, 20003668, 24912588
25638456, 25320555, 25240590, 23599216,
25182817, 24735430, 25872127
25192044,
20620169, 26324769, 24960044, 24677696, 25995938, 23125560
23061453,
25166187, 25722608, 25662524, 25598473, 25774077, 19614243
24664211,
25145215, 25123585, 24968162, 25241625, 25472112, 25463844
25410802,
25383204, 22446455, 23481673, 23055900, 26249718, 25967544
22087683,
23730961, 24376875, 24368004, 25162645, 25029022, 25099339
25093872,
25433696, 25392535, 25357142, 25328518, 25553616, 25970731
25953857,
26169345, 26169341, 26091640, 26032573, 22503297, 24341675
24850622,
25186079, 25602488, 25861398, 25980770, 26096382, 26765212
23035249,
24797119, 25405813, 24443539, 25098160, 25384462, 24593740
25241448,
26751171, 26751106, 26545688, 26367012, 25871639, 25597525
25546580,
25063971, 24654629, 23105538, 24401351, 25764020, 25259611
25244807,
25265499, 26650226, 26330994, 26658759, 26351334, 22347493
25140197,
26659182, 25990907, 25660847, 25411036, 24845157, 25888073
20591151,
25954054, 25822410, 25788879, 25335790, 25199585, 24717859
22564336,
24461826, 24337882, 24010030, 22826067, 26680105, 26626879
26641610,
26189861, 25826740, 25335249, 25335360, 25100063, 21216226
26327624,
25977302, 26597140, 26493289, 26435073, 25895224, 25634317
24617969,
19211433, 25911724, 22599050, 24843188, 24486059, 24922704
18594510,
19649997, 24680959, 25107662, 25964954, 23645516, 26237431
25754606,
23572982, 25045228, 25462714, 25722720, 24848746, 24760407
25203656,
25444961, 21520266, 23600861, 24600330, 24415926, 24423416
17947871,
23066146, 24326444, 24346821, 24623975, 24699619, 24801152
24786669,
24710696, 25065563, 25179774, 25129925, 25417958, 26237773
27087426, 27009164,
26969321, 26366517, 26898563, 26784509, 26522439
23271203,
22364044, 25307368, 26758193, 26542135, 15931756, 26548363
25710420,
26434999, 25207410, 26223039, 25524955, 25579458, 25489367
25313411,
24554533, 20756305, 25478885, 25858672, 26036748, 24966788
24766309,
21178363, 23715460, 23197730, 23602213, 25072986, 25729507
25890056,
25807997, 25206864, 23065002, 24345420, 24303148, 22864303
24435982,
24848923, 24978100, 24953434, 25210268, 25209912, 25981498
25919622,
25871177, 26569225, 26744595, 26908788, 25313154, 27135993
26635897,
26939314, 26983259, 26820076, 25785441, 27142373, 26729494
20532077,
23249829, 27073314, 26629381, 27079140, 26911000, 26944190
25305405,
23741944, 25348956, 25768681, 26794786, 25646373, 24570598
26399626,
25674386, 25225795, 25224242, 25536819, 25296876, 26375250
25963024,
26615690, 26442308, 25476149, 26170715, 25685152, 24307571
19526548,
24468470, 24744383, 25171084, 24713381, 24827654, 24343905
21433452,
24373756, 24923790, 24911709, 26019148, 24940060, 24595699
25691904,
25687460, 25672640, 25874678, 25785331, 22379010, 18521691
8480838,
25159176, 25227381, 25561296, 25440818, 23588722, 24470606
24692973,
24674197, 20118035, 24563422, 24759556, 25201454, 27165231
27052607,
22007324, 26037215, 25830492, 25086233, 26584641, 21147908
26110632,
24403922, 25386748, 24350620, 27305039, 22503283, 22581771
25945130,
26967713, 22367053, 26478970, 19647894, 26149904, 25437699
18774543, 26849779, 26121990, 26374791,
24374976, 25202355, 26608137
27034890,
22970869, 25489342, 25717371, 16727454, 27117822, 25557886
20087519,
25904273, 26637273, 25078611, 26006257, 25803545, 26038086
24689376,
25941836, 23709062, 19072655, 25634348, 25661819, 24486237
25388896,
22104866, 22070853, 25647325, 22504793, 26418088, 25287072
26633355,
26909100, 23080557, 25120284, 26245237, 23126545, 24616637
26256131,
23019710, 24308349, 22700845, 27169796, 25975723, 26797591
26080410,
24923338, 27213224, 27044297, 25813931, 22495673, 24802934
26263328,
25653109, 26840654, 25914276, 25492379, 26822620, 26556014
26198757,
25722055, 25516250, 21479706, 27124624, 26029780, 25760195
25790353,
22843979, 25616268, 26095327, 26775602, 20866970, 25353983
26981902,
25103996, 26740700, 26243698, 26259265, 25555252, 26875822
26452606,
26263721, 25639019, 25635149, 27060167, 24437162, 24589081
26546070,
25775213, 25865785, 24609592, 25943271, 26513709, 27274536
27508985,
27548131, 27611612, 26712331, 27338912, 26090767, 24473736
26444601,
27501373, 16942578, 21320338, 26907327, 26353617, 27329612
27394703,
25832935, 24737581, 25871753, 26091786, 24923080, 25680221
27207110,
24844549, 25784002, 25982666, 26412540, 26201113, 26729611
25226665,
26475419, 24757934, 25654459, 25614866, 27333106, 26637824
26498354,
20976443, 26138085, 27229389, 24793511, 26714910, 25058080
24719799,
23184263, 26802503, 24800423, 25540738, 27367194, 27292213
27138325,
27441326, 27502420
--------------------------------------------------------------------------------
OPatch succeeded.
Step 10: Login to
Oracle database and start the instance and open all PDBs.
[oracle@test 27674384]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Jun 3
16:00:10 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area
566231040 bytes
Fixed Size 8795184 bytes
Variable Size 301992912 bytes
Database Buffers 251658240 bytes
Redo Buffers 3784704 bytes
Database mounted.
Database opened.
SQL> set lines 300 pages 3000
SQL> col name for a34
SQL> select con_id,name,open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
---------- ---------------------------------- ----------
2 PDB$SEED READ ONLY
3 ORCLPDB MOUNTED
SQL> alter pluggable database all open;
Pluggable database altered.
Note: If you missed
to open one of the PDB then below “datapatch -verbose” script will not apply
patch to closed PDB.
SQL> select con_id,name,open_mode from v$pdbs;
CON_ID NAME OPEN_MODE
------- --------- -------------
2 PDB$SEED READ ONLY
3 ORCLPDB READ WRITE
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition
Release 12.2.0.1.0 - 64bit Production
Step 11: Apply
registry fixup using “database -verbose” command.
[oracle@test 27674384]$ cd $ORACLE_HOME/OPatch
[oracle@test OPatch]$
./datapatch -verbose
SQL Patching tool version 12.2.0.1.0 Production on Sun
Jun 3 16:01:47 2018
Copyright (c) 2012, 2018, Oracle. All rights reserved.
Log file for this invocation:
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_18887_2018_06_03_16_01_47/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:
Bundle series DBRU:
ID 180417 in the
binary registry and not installed in any PDB
Adding patches to installation queue and performing prereq
checks...
Installation queue:
For the following
PDBs: CDB$ROOT PDB$SEED ORCLPDB
Nothing to roll
back
The following
patches will be applied:
27674384
(DATABASE APR 2018 RELEASE UPDATE 12.2.0.1.180417)
Installing patches...
Patch installation complete.
Total patches installed: 3
Validating logfiles...
Patch 27674384 apply (pdb
CDB$ROOT): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27674384/22098633/27674384_apply_ORCL_CDBROOT_2018Jun03_16_02_35.log
(no errors)
Patch 27674384 apply (pdb
PDB$SEED): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27674384/22098633/27674384_apply_ORCL_PDBSEED_2018Jun03_16_04_45.log
(no errors)
Patch 27674384 apply (pdb
ORCLPDB): SUCCESS
logfile:
/u01/app/oracle/cfgtoollogs/sqlpatch/27674384/22098633/27674384_apply_ORCL_ORCLPDB_2018Jun03_16_04_45.log
(no errors)
SQL Patching tool complete on Sun Jun 3 16:08:02 2018
Ensure that applied patch details have been reflected in DBA_registry_sqlpatch view.
SQL> select
patch_id,version,action,status,action_time,description from
dba_registry_sqlpatch;
PATCH_ID VERSION ACTION STATUS ACTION_TIME DESCRIPTION
---------- -------------------- ---------------
--------------- ------------------------------------
----------------------------------------------------------------------------------------------------
27674384 12.2.0.1 APPLY SUCCESS 03-JUN-18
04.07.55.791739 PM DATABASE APR 2018 RELEASE UPDATE
12.2.0.1.180417
Step 12: Start
all Oracle Services which you had previously stopped.
[oracle@test OPatch]$ lsnrctl
start
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on
03-JUN-2018 16:11:05
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr:
please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Log messages written to
/u01/app/oracle/diag/tnslsnr/test/listener/alert/log.xml
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.localdomain)(PORT=1521)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.localdomain)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias
LISTENER
Version
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date
03-JUN-2018 16:11:05
Uptime
0 days 0 hr. 0 min. 0 sec
Trace Level off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File
/u01/app/oracle/diag/tnslsnr/test/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@test OPatch]$ lsnrctl
start LISTENER_MANOJ
LSNRCTL for Linux: Version 12.2.0.1.0 - Production on
03-JUN-2018 16:11:11
Copyright (c) 1991, 2016, Oracle. All rights reserved.
Starting /u01/app/oracle/product/12.2.0/dbhome_1/bin/tnslsnr:
please wait...
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
System parameter file is
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Log messages written to
/u01/app/oracle/diag/tnslsnr/test/listener_manoj/alert/log.xml
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.localdomain)(PORT=1522)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test.localdomain)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias
LISTENER_MANOJ
Version
TNSLSNR for Linux: Version 12.2.0.1.0 - Production
Start Date
03-JUN-2018 16:11:11
Uptime
0 days 0 hr. 0 min. 0 sec
Trace Level
off
Security
ON: Local OS Authentication
SNMP
OFF
Listener Parameter File
/u01/app/oracle/product/12.2.0/dbhome_1/network/admin/listener.ora
Listener Log File
/u01/app/oracle/diag/tnslsnr/test/listener_manoj/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=test.localdomain)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
The listener supports no services
The command completed successfully
You have successfully applied latest RU patch 27674384.
Thanks for reading this post ! Please comment if you like this post ! Click on FOLLOW to get next blog updates !
Very good explanation thank you very much
ReplyDeleteSummary
For fresh installation and without pluggable database
stop all services oracle(database, listner,tfs)
cp p6880880_122010_Linux-x86-64.zip $ORACLE_HOME
cd $ORACLE_HOME
mv Opatch OPatch_OLD
cp p27674384_122010_Linux-x86-64.zip /u01/
cd /u01/
unzip p27674384_122010_Linux-x86-64.zip
export PATH=$ORACLE_HOME/OPatch:$PATH
export PATH=$ORACLE_HOME/jdk:$PATH
cd 27674384
opatch prereq CheckConflictAgainstOHWithDetail -ph ./
opatch apply
sqlplus / as sysdba
startup;
exit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
lsnrctl start
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Financials and Oracle Fusion Procurement . Actually I was looking for the same information on internet for Oracle Fusion Manufacturing , Oracle APEX , Oracle Financials Cloud and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can check more aboutOracle Fusion Supply Chain Management Cloud , Oracle HCM Cloud , Oracle Project Portfolio Management (PPM) Cloud , Oracle Cloud Applications to better understand
ReplyDelete