opatch安装卸载
基础知识详解:https://www.cnblogs.com/zfox2017/p/6809376.html
本案例以oracle 10.2.0.5.0 打补丁过程进行详解。
参考oracle README文档 Patch 14275629 - 10.2.0.5.9 Patch Set Update
需要注意的两点:
1.补丁集更新(PSU)补丁是累积性的。也就是说,所有以前的PSU的内容都包含在最新的PSU修补程序中。
2.必须使用OPatch 10.2 10.2.0.5.0或更高版本来应用此补丁。
1. opatch 安装
1.1 检查Opatch软件及数据库版本信息
检查opatch版本:
[oracle@ZHUANHU ~]$ cd /u01/app/oracle/product/10.0.1/db_1/OPatch/
[oracle@ZHUANHU OPatch]$ ./opatch version
Invoking OPatch 10.2.0.4.9
OPatch Version: 10.2.0.4.9
OPatch succeeded.
检查数据库版本
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
用inventory 命令查看已经安装的patch:
[oracle@ZHUANHU ~]$ opatch lsinventory
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.0.1/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.9
OUI version : 10.2.0.5.0
OUI location : /u01/app/oracle/product/10.0.1/db_1/oui
Log file location : /u01/app/oracle/product/10.0.1/db_1/cfgtoollogs/opatch/opatch2020-05-22_09-50-17AM.log
Patch history file: /u01/app/oracle/product/10.0.1/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /u01/app/oracle/product/10.0.1/db_1/cfgtoollogs/opatch/lsinv/lsinventory2020-05-22_09-50-17AM.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.
There are no Interim patches installed in this Oracle Home.
--------------------------