Oracle 12cR2 (12.2.0.1) grid ve db home’una ilk yayınlanan RU (Release Update) patch’lerini platformunuza göre metalinkten indirip aşağıdaki gibi geçebilirsiniz. Öncesinde conflict check yapmayı unutmayın.

Patch 26133434 – Grid Infrastructure Jul2017 Release Update 12.2.0.1.170718 -> p26133434_122010_Linux-x86-64.zip

OPatch patch of version 12.2.0.1.9 for Oracle software releases 12.1.0.x (installer) and 12.2.0.x (MAY 2017) ->  p6880880_122010_Linux-x86-64.zip

ORACLE_HOME=/oracle/app/oracle/product/12.2.0.1/dbhome_1
GRID_HOME=/oracle/app/grid

mv /oracle/app/grid/OPatch /oracle/app/grid/OPatch_10082017
mv /oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch /oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch_10082017

cp -R /backup/SETUP/OPatch/OPatch   /oracle/app/grid
cp -R /backup/SETUP/OPatch/OPatch   /oracle/app/oracle/product/12.2.0.1/dbhome_1
cd /oracle/app/grid
chown -R oracle:oinstall OPatch
chmod 755 OPatch
ls -la
cd /oracle/app/oracle/product/12.2.0.1/dbhome_1
chown -R oracle:oinstall OPatch
chmod 755 OPatch
ls -la

[oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.9

OPatch succeeded.
[oracle@testdb01 ~]$

 

[oracle@testdb01 psu_for_12cr2]$ ls -la
total 953420
drwxr-xr-x 2 oracle oinstall 4096 Aug 15 11:27 .
drwxrwxrwx. 9 oracle oinstall 4096 Aug 10 15:07 ..
-rwxr-xr-x 1 oracle oinstall 976259134 Aug 10 14:52 p26133434_122010_Linux-x86-64.zip
[oracle@testdb01 psu_for_12cr2]$ unzip p26133434_122010_Linux-x86-64.zip

–for grid home as oracle user;

/oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26123830
/oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26002778
/oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/25586399

–for db home as oracle user;

/oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26123830
/oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26002778

[oracle@testdb01 psu_for_12cr2]$ /oracle/app/grid/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /backup/SETUP/psu_for_12cr2/26133434/26123830
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /oracle/app/oracle/product/12.2.0.1/dbhome_1
Central Inventory : /oracle/app/oraInventory
 from : /oracle/app/oracle/product/12.2.0.1/dbhome_1/oraInst.loc
OPatch version : 12.2.0.1.9
OUI version : 12.2.0.1.4
Log file location : /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatch/opatch2017-08-15_11-30-59AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
[oracle@testdb01 psu_for_12cr2]$

 

--patch for grid and db home;


[root@testdb01 ~]# export PATH=$PATH:/oracle/app/grid/OPatch
[root@testdb01 ~]# cd /oracle/app/grid/OPatch
[root@testdb01 OPatch]# opatchauto apply /backup/SETUP/psu_for_12cr2/26133434

OPatchauto session is initiated at Tue Aug 15 11:45:26 2017

System initialization log file is /oracle/app/grid/cfgtoollogs/opatchautodb/systemconfig2017-08-15_11-45-29AM.log.

Session log file is /oracle/app/grid/cfgtoollogs/opatchauto/opatchauto2017-08-15_11-45-36AM.log
The id for this session is ADRE

Executing OPatch prereq operations to verify patch applicability on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
Patch applicability verified successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

Verifying SQL patch applicability on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
SQL patch applicability verified successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

Executing OPatch prereq operations to verify patch applicability on home /oracle/app/grid
Patch applicability verified successfully on home /oracle/app/grid

Preparing to bring down database service on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
Successfully prepared home /oracle/app/oracle/product/12.2.0.1/dbhome_1 to bring down database service

Bringing down database service on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
Following database has been stopped and will be restarted later during the session: fbcmsprd
Database service successfully brought down on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

Bringing down CRS service on home /oracle/app/grid
Prepatch operation log file location: /oracle/app/oracle/crsdata/testdb01/crsconfig/hapatch_2017-08-15_11-48-40AM.log
CRS service brought down successfully on home /oracle/app/grid

Start applying binary patch on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
Binary patch applied successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

Start applying binary patch on home /oracle/app/grid
Binary patch applied successfully on home /oracle/app/grid

Starting CRS service on home /oracle/app/grid
Postpatch operation log file location: /oracle/app/oracle/crsdata/testdb01/crsconfig/hapatch_2017-08-15_11-58-19AM.log
CRS service started successfully on home /oracle/app/grid

Starting database service on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
Database service successfully started on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

Preparing home /oracle/app/oracle/product/12.2.0.1/dbhome_1 after database service restarted
No step execution required.........
Prepared home /oracle/app/oracle/product/12.2.0.1/dbhome_1 successfully after database service restarted

Trying to apply SQL patch on home /oracle/app/oracle/product/12.2.0.1/dbhome_1
SQL patch applied successfully on home /oracle/app/oracle/product/12.2.0.1/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:testdb01
SIDB Home:/oracle/app/oracle/product/12.2.0.1/dbhome_1
Summary:

==Following patches were SKIPPED:

Patch: /backup/SETUP/psu_for_12cr2/26133434/25586399
Reason: This patch is not applicable to this specified target type - "oracle_database"

==Following patches were SUCCESSFULLY applied:

Patch: /backup/SETUP/psu_for_12cr2/26133434/26002778
Log: /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-49-22AM_1.log

Patch: /backup/SETUP/psu_for_12cr2/26133434/26123830
Log: /oracle/app/oracle/product/12.2.0.1/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-49-22AM_1.log

Host:testdb01
SIHA Home:/oracle/app/grid
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /backup/SETUP/psu_for_12cr2/26133434/26002778
Log: /oracle/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-52-04AM_1.log

Patch: /backup/SETUP/psu_for_12cr2/26133434/25586399
Log: /oracle/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-52-04AM_1.log

Patch: /backup/SETUP/psu_for_12cr2/26133434/26123830
Log: /oracle/app/grid/cfgtoollogs/opatchauto/core/opatch/opatch2017-08-15_11-52-04AM_1.log

OPatchauto session completed at Tue Aug 15 12:06:51 2017
Time taken to complete the session 21 minutes, 26 seconds
[root@testdb01 OPatch]#

 

[oracle@testdb01 ~]$ echo $ORACLE_HOME
/oracle/app/grid/
[oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
26123830;DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)
25586399;ACFS Patch Set Update : 12.2.0.1.170718 (25586399)
26002778;OCW Patch Set Update : 12.2.0.1.170718 (26002778)

OPatch succeeded.
[oracle@testdb01 ~]$ 
[oracle@testdb01 ~]$ export ORACLE_HOME=/oracle/app/oracle/product/12.2.0.1/dbhome_1
[oracle@testdb01 ~]$ 
[oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch lspatches
26123830;DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)
26002778;OCW Patch Set Update : 12.2.0.1.170718 (26002778)

OPatch succeeded.
[oracle@testdb01 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.9

OPatch succeeded.
[oracle@testdb01 ~]$



[oracle@testdb01 ~]$ /oracle/app/grid/OPatch/opatch lsinventory -detail -oh /oracle/app/grid/
Oracle Interim Patch Installer version 12.2.0.1.9
Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home : /oracle/app/grid
Central Inventory : /oracle/app/oraInventory
 from : /oracle/app/grid//oraInst.loc
OPatch version : 12.2.0.1.9
OUI version : 12.2.0.1.4
Log file location : /oracle/app/grid/cfgtoollogs/opatch/opatch2017-08-15_12-25-04PM_1.log

Lsinventory Output file location : /oracle/app/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-08-15_12-25-04PM.txt

Installed Top-level Products (1):

Oracle Grid Infrastructure 12c 12.2.0.1.0
There are 1 products installed in this Oracle Home.

Installed Products (99): 
...
...
There are 99 products installed in this Oracle Home.

Interim patches (3) :

Patch 26123830 : applied on Tue Aug 15 11:57:35 EEST 2017
Unique Patch ID: 21405588
Patch description: "DATABASE RELEASE UPDATE: 12.2.0.1.170718 (26123830)"
 Created on 7 Jul 2017, 00:33:59 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
 Files Touched:
 /lpu.o --> ORACLE_HOME/lib/libcore12.a
 libcell12.so --> ORACLE_HOME/lib/libcell12.so
 ins_rdbms.mk --> ORACLE_HOME/rdbms/lib/libasmclntsh12.ohso
 ...
 ...

   Patch Location in Inventory:   Patch Location in Inventory:     /oracle/app/grid/inventory/oneoffs/26123830   Patch Location in Storage area:     /oracle/app/grid/.patch_storage/26123830_Jul_7_2017_00_33_59
Patch  25586399     : applied on Tue Aug 15 11:56:55 EEST 2017Unique Patch ID:  21306685Patch description:  "ACFS Patch Set Update : 12.2.0.1.170718 (25586399)"   Created on 16 Jun 2017, 00:35:19 hrs PST8PDT   Bugs fixed:     24679041, 24964969, 25098392, 25078431, 25491831   Files Touched:     ... ...     oracle_version.h --> ORACLE_HOME/usm/public/oracle_version.h     security.xsd --> ORACLE_HOME/usm/xml/schema/security.xsd   Patch Location in Inventory:     /oracle/app/grid/inventory/oneoffs/25586399   Patch Location in Storage area:     /oracle/app/grid/.patch_storage/25586399_Jun_16_2017_00_35_19

Patch  26002778     : applied on Tue Aug 15 11:53:57 EEST 2017 Patch  26002778     : applied on Tue Aug 15 11:53:57 EEST 2017Unique Patch ID:  21306682Patch description:  "OCW Patch Set Update : 12.2.0.1.170718 (26002778)"   Created on 3 Jul 2017, 03:26:30 hrs PST8PDT   Bugs fixed:     26144044, 25541343, 25715179, 25493588, 24932026, 24801915, 25832375     25728787, 25825732, 24578464, 25832312, 25742471, 25790699, 25655495     25307145, 25485737, 25505841, 25697364, 24663993, 25026470, 25591658     25537905, 24451580, 25409838, 25371632, 25569634, 25245759, 24665035     25646592, 25025157, 24732650, 24664849, 24584419, 24423011, 24831158     25037836, 25556203, 24464953, 24657753, 25197670, 24796183, 20559126     25197395, 24808260   Files Touched:     ... ...   Patch Location in Inventory:     /oracle/app/grid/inventory/oneoffs/26002778   Patch Location in Storage area:     /oracle/app/grid/.patch_storage/26002778_Jul_3_2017_03_26_30

--------------------------------------------------------------------------------
OPatch succeeded.[oracle@testdb01 ~]$

 

/oracle/app/oracle/product/12.2.0.1/dbhome_1/OPatch/opatch lsinventory -detail -oh /oracle/app/oracle/product/12.2.0.1/dbhome_1/

Release Schedule of Current Database Releases (Doc ID 742060.1)
Release Update and Release Update Revisions for Database Proactive Patch Program (Doc ID 2285040.1)

Reklamlar