p20299014_10205_Linux-x86-64
Patch 20299014 - Database Patch Set Update 10.2.0.5.19 (Includes CPUJul2015)
p20299014_10205_Linux-x86-64
・ p20299014_10205_Linux-x86-64_README
Record
操作系统版本 : CentOS Linux release 7.9.2009 (Core)
数据库版本 : Oracle 10.2.0.5.0 simple instance
OPatch : p6880880_102000_Linux-x86-64.zip
DB PSU : p20299014_10205_Linux-x86-64.zip
说明：p20299014 补丁包无 CRS 的补丁修复，所以直接打数据库 PSU 即可
-
Update OPatch
[root@centos7 ~]# chmod 775 /soft/p6880880_102000_Linux-x86-64-opatch.zip
[root@centos7 ~]# chown /soft/oracle:oinstall p6880880_102000_Linux-x86-64-opatch.zip
[root@centos7 ~]# su - oracle
[oracle@centos7 ~]$ mv /u01/app/oracle/product/10.2.0/db_1/OPatch /tmp/OPatch_bak
[oracle@centos7 ~]$ unzip /soft/p6880880_102000_Linux-x86-64-opatch.zip -d $ORACLE_HOME
[oracle@centos7 ~]$ $ORACLE_HOME/OPatch/opatch version
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded. -
Patch p20299014
解压补丁包
[root@centos7 ~]# chmod 775 PSU-10.2.0.5.19-p20299014_10205_Linux-x86-64.zip
[root@centos7 ~]# chown oracle:oinstall PSU-10.2.0.5.19-p20299014_10205_Linux-x86-64.zip
[root@centos7 ~]# su - oracle
[oracle@centos7 soft]$ unzip PSU-10.2.0.5.19-p20299014_10205_Linux-x86-64.zip补丁包兼容性检查
[oracle@centos7 soft]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /soft/20299014 -oh $ORACLE_HOME
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2022-02-14_08-50-38AM.log
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.查看该补丁能否采用 rolling 方式升级
[oracle@centos7 ~]$ $ORACLE_HOME/OPatch/opatch query -all /soft/20299014/ | grep rolling
Patch is a rolling patch: true关闭数据库和监听
sqlplus / as sysdba
shutdown immediate
lsnrctl stopPatch Apply
[oracle@centos7 ~]$ $ORACLE_HOME/OPatch/opatch apply /soft/20299014/
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2022-02-14_09-27-57AM.log
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '20299014' to OH '/u01/app/oracle/product/10.2.0/db_1'
Running prerequisite checks...
Patch 20299014: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle .network.cman, 10.2.0.5.0 ] , [ oracle.javavm.companion, 10.2.0.5.0 ] , [ oracle.ordim.companion, 10.2.0.5.0 ] , [ oracle.sqlj, 1 0.2.0.5.0 ] , [ oracle.java.sqlj, 10.2.0.5.0 ]
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.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/10.2.0/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '20299014' for restore. This might take a while...
Backing up files affected by the patch '20299014' for rollback. This might take a while...
Execution of 'sh /soft/20299014/custom/scripts/pre -apply 20299014 ':
Return Code = 0
Patching component oracle.rdbms, 10.2.0.5.0...
...中间过程省略...
ApplySession adding interim patch '20299014' to inventory
Verifying the update...
Inventory check OK: Patch ID 20299014 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 20299014 are present in Oracle Home.
Execution of 'sh /soft/20299014/custom/scripts/post -apply 20299014 ':
Return Code = 0
The local system has been patched and can be restarted.
OPatch succeeded.检查升级情况
[oracle@centos7 ~] ORACLE_HOME/OPatch/opatch lsinv
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2022-02-14_09-36-48AM.log
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2022-02-14_09-36-48AM.txt
---
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4 10.2.0.5.0
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch 20299014 : applied on Mon Feb 14 09:31:13 CST 2022
Unique Patch ID: 19074368
Created on 24 Jun 2015, 02:35:37 hrs PST8PDT
Bugs fixed:
20074391, 13596521, 17088068, 8865718, 17201047, 13489660, 9020537
8664189, 10091698, 14275629, 19909862, 17832122, 17832123, 17832124
17832125, 16619894, 8822531, 10139235, 20299014, 8350262, 7119382
19274521, 13632738, 11724962, 20331945, 19274523, 9320130, 16961614
16961615, 13775862, 16961616, 16961617, 19006757, 16961618, 16961619
18221699, 9399589, 14841459, 9672816, 9499302, 20299021, 9659614, 13632743
9949948, 14220725, 8882576, 7612454, 7111619, 9711859, 9714832, 12780098
13561951, 14665116, 11066597, 16703112, 19231857, 17721717, 9713537
14459552, 19458377, 13737773, 13737775, 16212405, 18096714, 16338983
14390396, 10249537, 19006849, 7115910, 8354642, 7602341, 14076510
12565867, 15987029, 16462834, 18641419, 11693109, 14023636, 9024850
8394351, 8224558, 17082365, 14149782, 9109487, 14841558, 9171933
10173237, 16817117, 10068982, 10306945, 8666117, 11725006, 10214450
14205448, 17082371, 9767674, 16306019, 9323583, 9726739, 16279211
8412426, 10326338, 10165083, 6651220, 9145204, 13554409, 11076894
19854436, 11893577, 17865671, 16746190, 14492313, 14492314, 11814891
14492315, 14492316, 16742123, 21048089, 16864562, 14546638, 12419258
16056270, 10010310, 18139709, 9689310, 9390484, 21048090, 21048091
9963497, 12551700, 16362358, 12551701, 17465584, 12551702, 12551703
12551704, 10076669, 12551705, 16270946, 12551706, 12551707, 6076890
9308296, 12551708, 14258925, 12880299, 17381900, 18641451, 17381901
17381902, 11790175, 12796518, 9772888, 8650138, 17056813, 14469008
12551710, 10092858, 7519406, 9821321, 8771916, 13349665, 7509714
10159846, 13257247, 18031728, 18641461, 16372203, 11792865, 19007266
19309466, 16309604, 16309605, 16309606, 18522511, 8966823, 11674645
17551414, 15877957, 15877958, 7026523, 15877959, 17716305, 13503598
18767250, 9150282, 9448311, 10327179, 14774730, 19153980, 9735237
9952230, 15877960, 15877961, 15877962, 15877963, 8660422, 18221700
18221701, 16279401, 14546673, 14105702, 14105703, 14105704, 13483152
14269955, 17285560, 12925532, 12748240, 9694101, 12862186, 12862187
14727319, 8211733, 9586877, 9548269, 6694396, 7710224, 9337325, 11856395
10157402, 15950541, 19699191, 6402302, 10327190, 10269717, 13015379
10017048, 8546356, 13561750, 8821114, 9770451, 9360157, 8488233, 10132870
4180770, 9532911, 7361418, 6157713, 9184754, 8544696, 17850678, 8277300
13343467, 16382448, 13791364, 12419392, 10208905, 20236416, 20236417
20236418, 20236419, 7450366, 8970313, 6690853, 6011045, 10162036, 10248542
9469117, 13359623, 9952270, 13343471, 9842573, 17381899, 12710774
20558005, 10324526, 9322219, 8636407, 12828105, 19289642, 13736501
9824435, 13736502, 18681879, 13736503, 13736504, 13736505, 13736506
9032322, 13736507, 14035825, 19769505, 11858315, 14040433, 13916709
12827745, 14038805, 19567242, 16721594, 13923855, 19567243, 8528171
9072105, 19567244, 11737047
---
OPatch succeeded. -
升级数据库字典
cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
startup
@catbundle.sql psu apply
-- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU applied since 10.2.0.5.3.
@utlrp.sql升级后检查
set line 200
col ACTION_TIME for a30
col ACTION for a20
col NAMESPACE for a10
col VERSION for a20
col BUNDLE_SERIES for a5
col COMMENTS for a25
select * from dba_registry_history;
---
ACTION_TIME ACTION NAMESPACE VERSION ID BUNDL COMMENTS
------------------------------ -------------------- ---------- -------------------- ---------- ----- -------------------------
14-FEB-22 09.51.58.594897 AM jvmpsu.sql SERVER 10.2.0.5.2OJVMBP 0 RAN jvmpsu.sql
14-FEB-22 09.52.08.639503 AM jvmpsu.sql SERVER 10.2.0.5.2OJVMBP 0 RAN jvmpsu.sql
14-FEB-22 09.55.41.608731 AM APPLY SERVER 10.2.0.5 19 PSU PSU 10.2.0.5.19
3 rows selected.
---
All articles on this blog are licensed under CC BY-NC-SA 4.0 unless otherwise stated.
Related Articles
2023-05-20
p6880880_190000_Linux-x86-64
Patch 6880880 - OPatch for DB 19.0.0.0.0 p6880880_190000_Linux-x86-64 Update OPatch Utility To update Opatch, use the following instructions: Download the OPatch utility to a temporary directory. For each Oracle RAC database home and the GI home that are being patched, run the following commands as the home owner to extract the OPatch utility. ~]$ unzip <OPATCH-ZIP> -d <ORACLE_HOME>~]$ <ORACLE_HOME>/OPatch/opatch version Record 1: Update OPatch utility version to ...
2023-05-20
p34130714_190000_Linux-x86-64
Patch 34130714 - GI Release Update 19.16.0.0.220719 p34130714_190000_Linux-x86-64 ・ p34130714_190000_Linux-x86-64_README Record System Operation: RHEL 8.7 Database Software: 19.3.0.0.0 RAC with 3 nodes Update OPatch utility version to 12.2.0.1.30 or later. Patch 6880880_190000 - record 2 Validation of Oracle Inventory on each node. ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME Download and U...
2024-06-09
p31537677_112040_Linux-x86-64
p31537677_112040_Linux-x86-64 Patch 31537677 - Oracle Database Patch Set Update 11.2.0.4.201020 ・ p31537677_112040_Linux-x86-64_README Record Upgrade the OPatch utility version 11.2.0.3.23 or later to apply this patch. ~]# mv $ORACLE_HOME/OPatch{,.bak.`date +%Y%m%d`}~]# unzip -q -d $ORACLE_HOME /soft/p6880880_112000_Linux-x86-64_11.2.0.3.31.zip~]# chown -R oracle:oinstall $ORACLE_HOME/OPatch~]# su - oracle -c "$ORACLE_HOME/OPatch/opatch version"OPatch Version: 11.2.0.3.31OPatch succeeded....
2023-05-27
p35042068_190000_Linux-x86-64
Patch 35042068 - Database Release Update 19.19.0.0.230418 p35042068_190000_Linux-x86-64 ・ p35042068_190000_Linux-x86-64_README Record
2023-05-20
p32226239_190000_Linux-x86-64
Patch 32226239 - GI Release Update 19.10.0.0.210119 p32226239_190000_Linux-x86-64 ・ p32226239_190000_Linux-x86-64_README Record
2023-05-20
p18370031_112040_Linux-x86-64
p18370031_112040_Linux-x86-64 ・ p18370031_112040_Linux-x86-64_README Record You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. $ <ORACLE_HOME>/OPatch/opatch version if not, patch p6880880. Validation of Oracle Inventory Before beginning patch application, check the consistency of inventory information for GI home and each database home to be patched. Run the following command as respective Oracle home owner to check the consistency. $ <ORACLE_HOME>...