Oracle打补丁
一、 环境
1. 数据库环境
- 操作系统版本 : redhat 6.5
- 数据库版本 : Oracle 11.2.0.4 RAC
- Grid : 11.2.0.4
- Oracle database: 11.2.0.4
2. 准备内容
- GI PSU : p24436338_112040_Linux-x86-64.zip
- OPatch : p6880880_112000_Linux-x86-64.zip
二、 升级前确认现在的版本
1. grid用户查看版本
[root@issdb1 ~]# su - grid
[grid@issdb1 ~]$ cd /u01/app/11.2.0/grid/OPatch/
[grid@issdb1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_09-59-29AM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_09-59-29AM.txt
\--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = issdb1
Remote node = issdb2
\--------------------------------------------------------------------------------
OPatch succeeded.
[grid@issdb1 OPatch]$
2. Oracle用户查看版本
[root@issdb1 ~]# su - oracle
[oracle@issdb1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@issdb1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-10-11_10-03-22AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_10-03-22AM.txt
\--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = issdb1
Remote node = issdb2
\--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@issdb1 OPatch]$
3. 查看数据字典
select * from dba_registry_history;
三、 更新OPatch版本
OPatch下载地址：https://updates.oracle.com/download/6880880.html
分别在两个节点更新OPatch版本:
节点1：
[root@issdb1 ~]# cd /u01/app/11.2.0/grid/
[root@issdb1 grid]# mv OPatch OPatch.bak
[root@issdb1 grid]# cd /u01/app/oracle/product/11.2.0/db_1/
[root@issdb1 db_1]# mv OPatch OPatch.bak
[root@issdb1 db_1]# cd /u01/soft/
[root@issdb1 soft]# ls
总用量 746872
drwxr-x--- 2 root 4096 10月 11 10:12 .
drwxr-xr-x 4 root 4096 10月 11 10:08 ..
-rw-rw-r-- 1 iss 712035213 10月 11 10:12 p24436338_112040_Linux-x86-64.zip
-rw-rw-r-- 1 iss 52746672 10月 11 10:11 p6880880_112000_Linux-x86-64.zip
[root@issdb1 soft]# unzip p6880880_112000_Linux-x86-64.zip
[root@issdb1 soft]# mv OPatch/ /u01/app/11.2.0/grid/
[root@issdb1 soft]# unzip p6880880_112000_Linux-x86-64.zip
[root@issdb1 soft]# mv OPatch/ /u01/app/oracle/product/11.2.0/db_1/
[root@issdb1 soft]# chown -R gird:oinstall /u01/app/11.2.0/grid/OPatch
[root@issdb1 soft]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1/OPatch
[root@issdb1 soft]# su - grid
[grid@issdb1 grid]$ opatch version
OPatch Version: 11.2.0.3.11
OPatch succeeded.
[grid@issdb1 grid]$ exit
[root@issdb1 soft]# su – oracle
[oracle@issdb1 ~]$ opatch version
OPatch Version: 11.2.0.3.11
OPatch succeeded.
[oracle@issdb1 ~]$
节点2：
[root@issdb2 ~]# cd /u01/app/11.2.0/grid/
[root@issdb2 grid]# mv OPatch OPatch.bak
[root@issdb2 grid]# cd /u01/app/oracle/product/11.2.0/db_1/
[root@issdb2 db_1]# mv OPatch OPatch.bak
[root@issdb2 db_1]# cd /u01/soft/
[root@issdb2 soft]# ls
总用量 746872
drwxr-x--- 2 root 4096 10月 11 10:12 .
drwxr-xr-x 4 root 4096 10月 11 10:08 ..
-rw-rw-r-- 1 iss 712035213 10月 11 10:12 p24436338_112040_Linux-x86-64.zip
-rw-rw-r-- 1 iss 52746672 10月 11 10:11 p6880880_112000_Linux-x86-64.zip
[root@issdb2 soft]# unzip p6880880_112000_Linux-x86-64.zip
[root@issdb2 soft]# mv OPatch/ /u01/app/11.2.0/grid/
[root@issdb2 soft]# unzip p6880880_112000_Linux-x86-64.zip
[root@issdb2 soft]# mv OPatch/ /u01/app/oracle/product/11.2.0/db_1/
[root@issdb2 soft]# chown -R gird:oinstall /u01/app/11.2.0/grid/OPatch
[root@issdb2 soft]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1/OPatch
[root@issdb2 soft]# su - grid
[grid@issdb2 grid]$ opatch version
OPatch Version: 11.2.0.3.11
OPatch succeeded.
[grid@issdb2 grid]$ exit
[root@issdb2 soft]# su – oracle
[oracle@issdb2 ~]$ opatch version
OPatch Version: 11.2.0.3.11
OPatch succeeded.
[oracle@issdb2 ~]$
四、 将补丁上传到所有节点并解压
节点1：
[root@issdb1 ~]# cd /u01/soft/
[root@issdb1 soft]# unzip p24436338_112040_Linux-x86-64.zip
[root@issdb1 soft]# chown -R grid:oinstall 24436338/
节点2：
[root@issdb2 ~]# cd /u01/soft/
[root@issdb2 soft]# unzip p24436338_112040_Linux-x86-64.zip
[root@issdb2 soft]# chown -R grid:oinstall 24436338/
五、 检查需要打的补丁与现有补丁是否冲突
节点1：
[root@issdb1 soft]# su – grid
[grid@issdb1 ~]$ cd /u01/soft/24436338/
[grid@issdb1 24436338]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_10-44-46AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@issdb1 24436338]$
节点2：
[root@issdb2 soft]# su – grid
[grid@issdb2 ~]$ cd /u01/soft/24436338/
[grid@issdb2 24436338]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_10-45-29AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@issdb2 24436338]$
六、 验证Inventory一致性
节点1：
[grid@issdb1 24436338]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_10-46-53AM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_10-46-53AM.txt
\--------------------------------------------------------------------------------
Local Machine Information::
Hostname: issdb1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (89):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Automatic Storage Management Assistant 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Ready Services Files 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Cluster Verification Utility Files 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Grid Infrastructure 11g 11.2.0.4.0
Oracle Help For Java 4.2.9.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle Quality of Service Management (Server) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
Required Support Files 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
Universal Storage Manager Files 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
There are 89 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = issdb1
Remote node = issdb2
\--------------------------------------------------------------------------------
OPatch succeeded.
节点2：
[grid@issdb2 24436338]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_10-46-57AM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_10-46-57AM.txt
\--------------------------------------------------------------------------------
Local Machine Information::
Hostname: issdb2
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Installed Products (89):
Agent Required Support Files 10.2.0.4.5
Assistant Common Files 11.2.0.4.0
Automatic Storage Management Assistant 11.2.0.4.0
Bali Share 1.1.18.0.0
Buildtools Common Files 11.2.0.4.0
Character Set Migration Utility 11.2.0.4.0
Cluster Ready Services Files 11.2.0.4.0
Cluster Verification Utility Common Files 11.2.0.4.0
Cluster Verification Utility Files 11.2.0.4.0
Database SQL Scripts 11.2.0.4.0
Deinstallation Tool 11.2.0.4.0
Enterprise Manager Common Core Files 10.2.0.4.5
Enterprise Manager Common Files 10.2.0.4.5
Enterprise Manager plugin Common Files 11.2.0.4.0
Expat libraries 2.0.1.0.1
HAS Common Files 11.2.0.4.0
HAS Files for DB 11.2.0.4.0
Installation Common Files 11.2.0.4.0
Installation Plugin Files 11.2.0.4.0
Installer SDK Component 11.2.0.4.0
Java Development Kit 1.5.0.51.10
LDAP Required Support Files 11.2.0.4.0
OLAP SQL Scripts 11.2.0.4.0
Oracle Advanced Security 11.2.0.4.0
Oracle Clusterware RDBMS Files 11.2.0.4.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 11.2.0.4.0
Oracle Core Required Support Files 11.2.0.4.0
Oracle Database 11g 11.2.0.4.0
Oracle Database 11g Multimedia Files 11.2.0.4.0
Oracle Database Deconfiguration 11.2.0.4.0
Oracle Database User Interface 2.2.13.0.0
Oracle Database Utilities 11.2.0.4.0
Oracle DBCA Deconfiguration 11.2.0.4.0
Oracle Extended Windowing Toolkit 3.4.47.0.0
Oracle Globalization Support 11.2.0.4.0
Oracle Globalization Support 11.2.0.4.0
Oracle Grid Infrastructure 11g 11.2.0.4.0
Oracle Help For Java 4.2.9.0.0
Oracle Ice Browser 5.2.3.6.0
Oracle Internet Directory Client 11.2.0.4.0
Oracle Java Client 11.2.0.4.0
Oracle JDBC/OCI Instant Client 11.2.0.4.0
Oracle JDBC/THIN Interfaces 11.2.0.4.0
Oracle JFC Extended Windowing Toolkit 4.2.36.0.0
Oracle JVM 11.2.0.4.0
Oracle LDAP administration 11.2.0.4.0
Oracle Locale Builder 11.2.0.4.0
Oracle Multimedia 11.2.0.4.0
Oracle Multimedia Client Option 11.2.0.4.0
Oracle Multimedia Java Advanced Imaging 11.2.0.4.0
Oracle Multimedia Locator 11.2.0.4.0
Oracle Multimedia Locator RDBMS Files 11.2.0.4.0
Oracle Net 11.2.0.4.0
Oracle Net Listener 11.2.0.4.0
Oracle Net Required Support Files 11.2.0.4.0
Oracle Netca Client 11.2.0.4.0
Oracle Notification Service 11.2.0.3.0
Oracle Notification Service (eONS) 11.2.0.4.0
Oracle One-Off Patch Installer 11.2.0.3.4
Oracle Quality of Service Management (Client) 11.2.0.4.0
Oracle Quality of Service Management (Server) 11.2.0.4.0
Oracle RAC Deconfiguration 11.2.0.4.0
Oracle RAC Required Support Files-HAS 11.2.0.4.0
Oracle Recovery Manager 11.2.0.4.0
Oracle Security Developer Tools 11.2.0.4.0
Oracle Text Required Support Files 11.2.0.4.0
Oracle Universal Installer 11.2.0.4.0
Oracle USM Deconfiguration 11.2.0.4.0
Oracle Wallet Manager 11.2.0.4.0
Parser Generator Required Support Files 11.2.0.4.0
Perl Interpreter 5.10.0.0.2
Perl Modules 5.10.0.0.1
PL/SQL 11.2.0.4.0
PL/SQL Embedded Gateway 11.2.0.4.0
Platform Required Support Files 11.2.0.4.0
Precompiler Required Support Files 11.2.0.4.0
RDBMS Required Support Files 11.2.0.4.0
RDBMS Required Support Files for Instant Client 11.2.0.4.0
RDBMS Required Support Files Runtime 11.2.0.4.0
Required Support Files 11.2.0.4.0
Secure Socket Layer 11.2.0.4.0
SQL*Plus 11.2.0.4.0
SQL*Plus Files for Instant Client 11.2.0.4.0
SQL*Plus Required Support Files 11.2.0.4.0
SSL Required Support Files for InstantClient 11.2.0.4.0
Universal Storage Manager Files 11.2.0.4.0
XDK Required Support Files 11.2.0.4.0
XML Parser for Java 11.2.0.4.0
There are 89 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = issdb2
Remote node = issdb1
\--------------------------------------------------------------------------------
OPatch succeeded.
[grid@issdb2 24436338]$
七、 配置ocm响应文件
节点1：
[root@issdb1 soft]# su - grid
[grid@issdb1 ~]$ cd $ORACLE_HOME/OPatch/ocm/bin
[grid@issdb1 bin]$ ./emocmrsp -no_banner -output /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
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
The OCM configuration response file (/u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp) was successfully created.
[grid@issdb1 bin]$
节点2：
[root@issdb2 soft]# su - grid
[grid@issdb2 ~]$ cd $ORACLE_HOME/OPatch/ocm/bin
[grid@issdb2 bin]$ ./emocmrsp -no_banner -output /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
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
The OCM configuration response file (/u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp) was successfully created.
[grid@issdb2 bin]$
八、 OPatch apply(所有节点均需执行)(无需关闭任何组件及资源)
可以使用root权限的用户自动为GI和DB打上PSU。必须在每一个节点都要执行，且GI home和DB home不是共享的。而且两个节点不可以并行执行。
节点1：
[root@issdb1 soft]# mkdir /u01/app/11.2.0/grid/.patch_storage
[root@issdb1 soft]# chown grid:oinstall /u01/app/11.2.0/grid/.patch_storage
[root@issdb1 soft]# chmod 777 /u01/app/11.2.0/grid/.patch_storage
[root@issdb1 soft]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/soft/24436338/ -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 24436338 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2019-10-11_10-51-57.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2019-10-11_10-51-57.report.log
2019-10-11 10:51:57: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/soft/24436338/24006111 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/soft/24436338/23054319/custom/server/23054319 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /u01/soft/24436338/24006111 apply successful for home /u01/app/11.2.0/grid
patch /u01/soft/24436338/23054319 apply successful for home /u01/app/11.2.0/grid
patch /u01/soft/24436338/22502505 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
[root@issdb1 soft]#
节点2：
[root@issdb2 soft]# mkdir /u01/app/11.2.0/grid/.patch_storage
[root@issdb2 soft]# chown grid:oinstall /u01/app/11.2.0/grid/.patch_storage
[root@issdb2 soft]# chmod 777 /u01/app/11.2.0/grid/.patch_storage
[root@issdb2 soft]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/soft/24436338/ -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/soft -patchn 24436338 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2019-10-11_11-25-26.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2019-10-11_11-25-26.report.log
2019-10-11 11:25:26: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/soft/24436338/24006111 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/soft/24436338/23054319/custom/server/23054319 apply successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /u01/soft/24436338/24006111 apply successful for home /u01/app/11.2.0/grid
patch /u01/soft/24436338/23054319 apply successful for home /u01/app/11.2.0/grid
patch /u01/soft/24436338/22502505 apply successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
[root@issdb2 soft]#
grid用户验证：
su - grid
opatch lsinventory
oracle用户验证：
su - oracle
opatch lsinventory
在这一步可能会遇到问题：一般会报，The opatch minimum version check for patch
可能的原因有：
在/home/grid/目录下没有创建.patch_storage目录
grid用户的$ORACLE_HOME没有写权限
没有在空目录下解压patch
[root@issdb1 ~]# su - grid
[grid@issdb1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_11-56-28AM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_11-56-28AM.txt
\--------------------------------------------------------------------------------
Local Machine Information::
Hostname: issdb1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch 22502505 : applied on Fri Oct 11 11:10:37 CST 2019
Unique Patch ID: 19880366
Patch description: "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)"
Created on 17 Feb 2016, 00:12:23 hrs PST8PDT
Bugs fixed:
21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148
17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796
18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303
18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334
18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946
Patch 23054319 : applied on Fri Oct 11 11:09:30 CST 2019
Unique Patch ID: 20209287
Patch description: "OCW Patch Set Update : 11.2.0.4.160719 (23054319)"
Created on 15 Jul 2016, 14:38:17 hrs PST8PDT
Bugs fixed:
18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458
17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046
17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
17886392, 20995001, 17039197, 16317771, 17947785, 10052729, 20340620
22353346, 16237657, 20317221, 18199185, 15917869, 18399991, 20186278
18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 20552947
18414137, 18882642, 17001914, 17927970, 14378120, 16346413, 15986647
18068871, 21222147, 16206997, 18143836, 21982225, 19168690, 18343490
20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
17500165, 18875012, 14769643, 19558324, 18464784, 18848125, 19241857
17955615, 14851828, 14693336, 20315294, 16284825, 17352230, 20014326
17238586, 17089344, 17405605, 17531342, 21327402, 19398098, 17159489
17640316, 13823394, 16543190, 22024217, 17983675, 20795241, 17481314
18346135, 17598201, 16281493, 15986311, 17208793, 19601468, 18999857
18700935, 14076173, 18428146, 17435488, 18352845, 18352846, 20408163
17592037, 19616601, 17387779, 17391726, 14777968, 15851860, 16206882
20141091, 15832129, 17305100, 20175174, 21113068, 19885321, 16901346
17985714, 18536826, 17780903, 18752378, 18946768, 16876500, 16875342
17769597, 19955755, 16429265, 18336452, 17273003, 17209968, 16988311
19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591
21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052
16798862, 15920201
Patch 24006111 : applied on Fri Oct 11 11:08:15 CST 2019
Unique Patch ID: 20508568
Patch description: "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Created on 26 Aug 2016, 05:54:48 hrs PST8PDT
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17288409, 21051852, 24316947, 17811429, 18607546, 17205719, 20506699
17816865, 17922254, 23330119, 17754782, 16934803, 13364795, 17311728
17441661, 17284817, 16992075, 17446237, 14015842, 19972569, 21756677
17375354, 20925795, 21538558, 17449815, 19463897, 13866822, 17235750
17982555, 17478514, 18317531, 14338435, 18235390, 20803583, 13944971
20142975, 17811789, 16929165, 18704244, 20506706, 17546973, 20334344
14054676, 17088068, 17346091, 18264060, 17343514, 21538567, 19680952
18471685, 19211724, 13951456, 21847223, 16315398, 18744139, 16850630
23177648, 19049453, 18673304, 17883081, 19915271, 18641419, 18262334
17006183, 16065166, 18277454, 16833527, 10136473, 18051556, 17865671
17852463, 18554871, 17853498, 18334586, 17551709, 17588480, 19827973
17344412, 17842825, 18828868, 17025461, 11883252, 13609098, 17239687
17602269, 19197175, 22195457, 18316692, 17313525, 12611721, 19544839
18964939, 17600719, 18191164, 19393542, 17571306, 20777150, 18482502
19466309, 22243719, 17040527, 17165204, 18098207, 16785708, 17465741
17174582, 16180763, 16777840, 12982566, 19463893, 22195465, 22148226
16875449, 12816846, 17237521, 6599380, 19358317, 17811438, 17811447
17945983, 21983325, 18762750, 16912439, 17184721, 18061914, 17282229
18331850, 18202441, 17082359, 18723434, 21972320, 19554106, 14034426
18339044, 19458377, 17752995, 20448824, 17891943, 17258090, 17767676
16668584, 18384391, 17040764, 17381384, 15913355, 18356166, 14084247
20596234, 20506715, 21756661, 13853126, 18203837, 14245531, 16043574
21756699, 22195441, 17848897, 17877323, 21453153, 17468141, 20861693
17786518, 17912217, 17037130, 16956380, 18155762, 17478145, 17394950
18641461, 18189036, 18619917, 17027426, 21352646, 16268425, 24476274
22195492, 19584068, 18436307, 22507210, 17265217, 17634921, 13498382
21526048, 19258504, 20004087, 17443671, 22195485, 18000422, 22321756
20004021, 17571039, 21067387, 16344544, 18009564, 14354737, 21286665
18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109
17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983
20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939
17811456, 22380919, 16731148, 21168487, 14133975, 13829543, 17215560
17694209, 17385178, 18091059, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 22195477, 14368995
22502493, 17346671, 18996843, 17783588, 21343838, 16618694, 17672719
18856999, 18783224, 17851160, 17546761, 17798953, 18273830, 22092979
16596890, 19972566, 16384983, 17726838, 22296366, 17360606, 22321741
13645875, 18199537, 16542886, 21787056, 17889549, 14565184, 17071721
17610798, 20299015, 21343897, 22893153, 20657441, 17397545, 18230522
16360112, 19769489, 12905058, 18641451, 12747740, 18430495, 17016369
17042658, 14602788, 17551063, 19972568, 21517440, 18508861, 19788842
14657740, 17332800, 13837378, 19972564, 17186905, 18315328, 19699191
17437634, 22353199, 18093615, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 17762296, 14692762, 21051840, 17705023, 22507234
19121551, 21330264, 19854503, 21868720, 19309466, 18681862, 20558005
18554763, 17390160, 18456514, 16306373, 13955826, 18139690, 17501491
17752121, 21668627, 17299889, 17889583, 18673325, 19721304, 18293054
17242746, 17951233, 18094246, 17649265, 19615136, 17011832, 16870214
17477958, 18522509, 20631274, 16091637, 17323222, 16595641, 16524926
18228645, 18282562, 17596908, 18031668, 17156148, 16494615, 22683225
17545847, 17655240, 24528741, 17614134, 13558557, 17341326, 17891946
17716305, 22657942, 16392068, 19271443, 21351877, 18092127, 17614227
18440047, 16903536, 14106803, 18973907, 18673342, 19032867, 17389192
17612828, 16194160, 17006570, 17721717, 17390431, 17570240, 16863422
18325460, 19727057, 16422541, 19972570, 17267114, 18244962, 21538485
18765602, 18203838, 16198143, 17246576, 14829250, 17835627, 18247991
14458214, 21051862, 16692232, 17786278, 17227277, 24476265, 16042673
16314254, 16228604, 16837842, 17393683, 23536835, 17787259, 20331945
20074391, 15861775, 16399083, 18018515, 22683212, 18260550, 21051858
17080436, 16613964, 17036973, 16579084, 24433711, 18384537, 18280813
20296213, 16901385, 15979965, 23330124, 18441944, 16450169, 9756271
17892268, 11733603, 16285691, 17587063, 21343775, 18180390, 16538760
18193833, 21387964, 21051833, 17238511, 17824637, 16571443, 18306996
14852021, 17853456, 18674047, 12364061, 22195448
Rac system comprising of multiple nodes
Local node = issdb1
Remote node = issdb2
\--------------------------------------------------------------------------------
OPatch succeeded.
[grid@issdb1 ~]$ exit
logout
[root@issdb1 ~]# su - oracle
[oracle@issdb1 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-10-11_11-56-41AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_11-56-41AM.txt
\--------------------------------------------------------------------------------
Local Machine Information::
Hostname: issdb1
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 23054319 : applied on Fri Oct 11 11:03:54 CST 2019
Unique Patch ID: 20209287
Patch description: "OCW Patch Set Update : 11.2.0.4.160719 (23054319)"
Created on 15 Jul 2016, 14:38:02 hrs PST8PDT
Bugs fixed:
18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458
17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046
17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
17886392, 20995001, 17039197, 16317771, 17947785, 10052729, 20340620
22353346, 16237657, 20317221, 18199185, 15917869, 18399991, 20186278
18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 20552947
18414137, 18882642, 17001914, 17927970, 14378120, 16346413, 15986647
18068871, 21222147, 16206997, 18143836, 21982225, 19168690, 18343490
20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
17500165, 18875012, 14769643, 19558324, 18464784, 18848125, 19241857
17955615, 14851828, 14693336, 20315294, 16284825, 17352230, 20014326
17238586, 17089344, 17405605, 17531342, 21327402, 19398098, 17159489
17640316, 13823394, 16543190, 22024217, 17983675, 20795241, 17481314
18346135, 17598201, 16281493, 15986311, 17208793, 19601468, 18999857
18700935, 14076173, 18428146, 17435488, 18352845, 18352846, 20408163
17592037, 19616601, 17387779, 17391726, 14777968, 15851860, 16206882
20141091, 15832129, 17305100, 20175174, 21113068, 19885321, 16901346
17985714, 18536826, 17780903, 18752378, 18946768, 16876500, 16875342
17769597, 19955755, 16429265, 18336452, 17273003, 17209968, 16988311
19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591
21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052
16798862, 15920201
Patch 24006111 : applied on Fri Oct 11 11:02:44 CST 2019
Unique Patch ID: 20508568
Patch description: "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Created on 26 Aug 2016, 05:54:48 hrs PST8PDT
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17288409, 21051852, 24316947, 17811429, 18607546, 17205719, 20506699
17816865, 17922254, 23330119, 17754782, 16934803, 13364795, 17311728
17441661, 17284817, 16992075, 17446237, 14015842, 19972569, 21756677
17375354, 20925795, 21538558, 17449815, 19463897, 13866822, 17235750
17982555, 17478514, 18317531, 14338435, 18235390, 20803583, 13944971
20142975, 17811789, 16929165, 18704244, 20506706, 17546973, 20334344
14054676, 17088068, 17346091, 18264060, 17343514, 21538567, 19680952
18471685, 19211724, 13951456, 21847223, 16315398, 18744139, 16850630
23177648, 19049453, 18673304, 17883081, 19915271, 18641419, 18262334
17006183, 16065166, 18277454, 16833527, 10136473, 18051556, 17865671
17852463, 18554871, 17853498, 18334586, 17551709, 17588480, 19827973
17344412, 17842825, 18828868, 17025461, 11883252, 13609098, 17239687
17602269, 19197175, 22195457, 18316692, 17313525, 12611721, 19544839
18964939, 17600719, 18191164, 19393542, 17571306, 20777150, 18482502
19466309, 22243719, 17040527, 17165204, 18098207, 16785708, 17465741
17174582, 16180763, 16777840, 12982566, 19463893, 22195465, 22148226
16875449, 12816846, 17237521, 6599380, 19358317, 17811438, 17811447
17945983, 21983325, 18762750, 16912439, 17184721, 18061914, 17282229
18331850, 18202441, 17082359, 18723434, 21972320, 19554106, 14034426
18339044, 19458377, 17752995, 20448824, 17891943, 17258090, 17767676
16668584, 18384391, 17040764, 17381384, 15913355, 18356166, 14084247
20596234, 20506715, 21756661, 13853126, 18203837, 14245531, 16043574
21756699, 22195441, 17848897, 17877323, 21453153, 17468141, 20861693
17786518, 17912217, 17037130, 16956380, 18155762, 17478145, 17394950
18641461, 18189036, 18619917, 17027426, 21352646, 16268425, 24476274
22195492, 19584068, 18436307, 22507210, 17265217, 17634921, 13498382
21526048, 19258504, 20004087, 17443671, 22195485, 18000422, 22321756
20004021, 17571039, 21067387, 16344544, 18009564, 14354737, 21286665
18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109
17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983
20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939
17811456, 22380919, 16731148, 21168487, 14133975, 13829543, 17215560
17694209, 17385178, 18091059, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 22195477, 14368995
22502493, 17346671, 18996843, 17783588, 21343838, 16618694, 17672719
18856999, 18783224, 17851160, 17546761, 17798953, 18273830, 22092979
16596890, 19972566, 16384983, 17726838, 22296366, 17360606, 22321741
13645875, 18199537, 16542886, 21787056, 17889549, 14565184, 17071721
17610798, 20299015, 21343897, 22893153, 20657441, 17397545, 18230522
16360112, 19769489, 12905058, 18641451, 12747740, 18430495, 17016369
17042658, 14602788, 17551063, 19972568, 21517440, 18508861, 19788842
14657740, 17332800, 13837378, 19972564, 17186905, 18315328, 19699191
17437634, 22353199, 18093615, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 17762296, 14692762, 21051840, 17705023, 22507234
19121551, 21330264, 19854503, 21868720, 19309466, 18681862, 20558005
18554763, 17390160, 18456514, 16306373, 13955826, 18139690, 17501491
17752121, 21668627, 17299889, 17889583, 18673325, 19721304, 18293054
17242746, 17951233, 18094246, 17649265, 19615136, 17011832, 16870214
17477958, 18522509, 20631274, 16091637, 17323222, 16595641, 16524926
18228645, 18282562, 17596908, 18031668, 17156148, 16494615, 22683225
17545847, 17655240, 24528741, 17614134, 13558557, 17341326, 17891946
17716305, 22657942, 16392068, 19271443, 21351877, 18092127, 17614227
18440047, 16903536, 14106803, 18973907, 18673342, 19032867, 17389192
17612828, 16194160, 17006570, 17721717, 17390431, 17570240, 16863422
18325460, 19727057, 16422541, 19972570, 17267114, 18244962, 21538485
18765602, 18203838, 16198143, 17246576, 14829250, 17835627, 18247991
14458214, 21051862, 16692232, 17786278, 17227277, 24476265, 16042673
16314254, 16228604, 16837842, 17393683, 23536835, 17787259, 20331945
20074391, 15861775, 16399083, 18018515, 22683212, 18260550, 21051858
17080436, 16613964, 17036973, 16579084, 24433711, 18384537, 18280813
20296213, 16901385, 15979965, 23330124, 18441944, 16450169, 9756271
17892268, 11733603, 16285691, 17587063, 21343775, 18180390, 16538760
18193833, 21387964, 21051833, 17238511, 17824637, 16571443, 18306996
14852021, 17853456, 18674047, 12364061, 22195448
Rac system comprising of multiple nodes
Local node = issdb1
Remote node = issdb2
\--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@issdb1 ~]$
[root@issdb2 soft]# su - grid
[grid@issdb2 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2019-10-11_11-54-24AM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_11-54-24AM.txt
\--------------------------------------------------------------------------------
Local Machine Information::
Hostname: issdb2
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (3) :
Patch 22502505 : applied on Fri Oct 11 11:45:40 CST 2019
Unique Patch ID: 19880366
Patch description: "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)"
Created on 17 Feb 2016, 00:12:23 hrs PST8PDT
Bugs fixed:
21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148
17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796
18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303
18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334
18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946
Patch 23054319 : applied on Fri Oct 11 11:41:56 CST 2019
Unique Patch ID: 20209287
Patch description: "OCW Patch Set Update : 11.2.0.4.160719 (23054319)"
Created on 15 Jul 2016, 14:38:17 hrs PST8PDT
Bugs fixed:
18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458
17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046
17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
17886392, 20995001, 17039197, 16317771, 17947785, 10052729, 20340620
22353346, 16237657, 20317221, 18199185, 15917869, 18399991, 20186278
18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 20552947
18414137, 18882642, 17001914, 17927970, 14378120, 16346413, 15986647
18068871, 21222147, 16206997, 18143836, 21982225, 19168690, 18343490
20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
17500165, 18875012, 14769643, 19558324, 18464784, 18848125, 19241857
17955615, 14851828, 14693336, 20315294, 16284825, 17352230, 20014326
17238586, 17089344, 17405605, 17531342, 21327402, 19398098, 17159489
17640316, 13823394, 16543190, 22024217, 17983675, 20795241, 17481314
18346135, 17598201, 16281493, 15986311, 17208793, 19601468, 18999857
18700935, 14076173, 18428146, 17435488, 18352845, 18352846, 20408163
17592037, 19616601, 17387779, 17391726, 14777968, 15851860, 16206882
20141091, 15832129, 17305100, 20175174, 21113068, 19885321, 16901346
17985714, 18536826, 17780903, 18752378, 18946768, 16876500, 16875342
17769597, 19955755, 16429265, 18336452, 17273003, 17209968, 16988311
19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591
21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052
16798862, 15920201
Patch 24006111 : applied on Fri Oct 11 11:38:40 CST 2019
Unique Patch ID: 20508568
Patch description: "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Created on 26 Aug 2016, 05:54:48 hrs PST8PDT
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17288409, 21051852, 24316947, 17811429, 18607546, 17205719, 20506699
17816865, 17922254, 23330119, 17754782, 16934803, 13364795, 17311728
17441661, 17284817, 16992075, 17446237, 14015842, 19972569, 21756677
17375354, 20925795, 21538558, 17449815, 19463897, 13866822, 17235750
17982555, 17478514, 18317531, 14338435, 18235390, 20803583, 13944971
20142975, 17811789, 16929165, 18704244, 20506706, 17546973, 20334344
14054676, 17088068, 17346091, 18264060, 17343514, 21538567, 19680952
18471685, 19211724, 13951456, 21847223, 16315398, 18744139, 16850630
23177648, 19049453, 18673304, 17883081, 19915271, 18641419, 18262334
17006183, 16065166, 18277454, 16833527, 10136473, 18051556, 17865671
17852463, 18554871, 17853498, 18334586, 17551709, 17588480, 19827973
17344412, 17842825, 18828868, 17025461, 11883252, 13609098, 17239687
17602269, 19197175, 22195457, 18316692, 17313525, 12611721, 19544839
18964939, 17600719, 18191164, 19393542, 17571306, 20777150, 18482502
19466309, 22243719, 17040527, 17165204, 18098207, 16785708, 17465741
17174582, 16180763, 16777840, 12982566, 19463893, 22195465, 22148226
16875449, 12816846, 17237521, 6599380, 19358317, 17811438, 17811447
17945983, 21983325, 18762750, 16912439, 17184721, 18061914, 17282229
18331850, 18202441, 17082359, 18723434, 21972320, 19554106, 14034426
18339044, 19458377, 17752995, 20448824, 17891943, 17258090, 17767676
16668584, 18384391, 17040764, 17381384, 15913355, 18356166, 14084247
20596234, 20506715, 21756661, 13853126, 18203837, 14245531, 16043574
21756699, 22195441, 17848897, 17877323, 21453153, 17468141, 20861693
17786518, 17912217, 17037130, 16956380, 18155762, 17478145, 17394950
18641461, 18189036, 18619917, 17027426, 21352646, 16268425, 24476274
22195492, 19584068, 18436307, 22507210, 17265217, 17634921, 13498382
21526048, 19258504, 20004087, 17443671, 22195485, 18000422, 22321756
20004021, 17571039, 21067387, 16344544, 18009564, 14354737, 21286665
18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109
17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983
20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939
17811456, 22380919, 16731148, 21168487, 14133975, 13829543, 17215560
17694209, 17385178, 18091059, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 22195477, 14368995
22502493, 17346671, 18996843, 17783588, 21343838, 16618694, 17672719
18856999, 18783224, 17851160, 17546761, 17798953, 18273830, 22092979
16596890, 19972566, 16384983, 17726838, 22296366, 17360606, 22321741
13645875, 18199537, 16542886, 21787056, 17889549, 14565184, 17071721
17610798, 20299015, 21343897, 22893153, 20657441, 17397545, 18230522
16360112, 19769489, 12905058, 18641451, 12747740, 18430495, 17016369
17042658, 14602788, 17551063, 19972568, 21517440, 18508861, 19788842
14657740, 17332800, 13837378, 19972564, 17186905, 18315328, 19699191
17437634, 22353199, 18093615, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 17762296, 14692762, 21051840, 17705023, 22507234
19121551, 21330264, 19854503, 21868720, 19309466, 18681862, 20558005
18554763, 17390160, 18456514, 16306373, 13955826, 18139690, 17501491
17752121, 21668627, 17299889, 17889583, 18673325, 19721304, 18293054
17242746, 17951233, 18094246, 17649265, 19615136, 17011832, 16870214
17477958, 18522509, 20631274, 16091637, 17323222, 16595641, 16524926
18228645, 18282562, 17596908, 18031668, 17156148, 16494615, 22683225
17545847, 17655240, 24528741, 17614134, 13558557, 17341326, 17891946
17716305, 22657942, 16392068, 19271443, 21351877, 18092127, 17614227
18440047, 16903536, 14106803, 18973907, 18673342, 19032867, 17389192
17612828, 16194160, 17006570, 17721717, 17390431, 17570240, 16863422
18325460, 19727057, 16422541, 19972570, 17267114, 18244962, 21538485
18765602, 18203838, 16198143, 17246576, 14829250, 17835627, 18247991
14458214, 21051862, 16692232, 17786278, 17227277, 24476265, 16042673
16314254, 16228604, 16837842, 17393683, 23536835, 17787259, 20331945
20074391, 15861775, 16399083, 18018515, 22683212, 18260550, 21051858
17080436, 16613964, 17036973, 16579084, 24433711, 18384537, 18280813
20296213, 16901385, 15979965, 23330124, 18441944, 16450169, 9756271
17892268, 11733603, 16285691, 17587063, 21343775, 18180390, 16538760
18193833, 21387964, 21051833, 17238511, 17824637, 16571443, 18306996
14852021, 17853456, 18674047, 12364061, 22195448
Rac system comprising of multiple nodes
Local node = issdb2
Remote node = issdb1
\--------------------------------------------------------------------------------
OPatch succeeded.
[grid@issdb2 ~]$ exit
logout
[root@issdb2 soft]# su - oracle
[oracle@issdb2 ~]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2019, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-10-11_11-54-34AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-10-11_11-54-34AM.txt
\--------------------------------------------------------------------------------
Local Machine Information::
Hostname: issdb2
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 23054319 : applied on Fri Oct 11 11:32:48 CST 2019
Unique Patch ID: 20209287
Patch description: "OCW Patch Set Update : 11.2.0.4.160719 (23054319)"
Created on 15 Jul 2016, 14:38:02 hrs PST8PDT
Bugs fixed:
18328800, 19270660, 18691572, 18508710, 20038451, 21251192, 22162062
20365005, 21232394, 17387214, 17750548, 17617807, 14497275, 20219458
17733927, 18180541, 23757020, 18962892, 17292250, 17378618, 16759171
20110156, 17843489, 17065496, 13991403, 21694632, 17273020, 22762046
17155238, 18261183, 18053580, 20012766, 21245437, 20218012, 17013634
17886392, 20995001, 17039197, 16317771, 17947785, 10052729, 20340620
22353346, 16237657, 20317221, 18199185, 15917869, 18399991, 20186278
18024089, 17374271, 16849642, 20246071, 20746251, 14270845, 20552947
18414137, 18882642, 17001914, 17927970, 14378120, 16346413, 15986647
18068871, 21222147, 16206997, 18143836, 21982225, 19168690, 18343490
20235511, 21875360, 16613232, 19276791, 17722664, 20440643, 12928658
18226143, 18520351, 16249829, 18952577, 17172091, 18229842, 16076412
18265482, 20676340, 17818075, 20091753, 18231837, 14373486, 17483479
20136892, 20551654, 18120545, 18729166, 13843841, 17405302, 21225209
18709496, 18330979, 18744838, 14525998, 18187697, 17087371, 20531190
20598625, 14385860, 18348155, 19479503, 12928592, 17516024, 18370031
17764053, 19272663, 17551223, 14671408, 18272135, 14207615, 21255373
17500165, 18875012, 14769643, 19558324, 18464784, 18848125, 19241857
17955615, 14851828, 14693336, 20315294, 16284825, 17352230, 20014326
17238586, 17089344, 17405605, 17531342, 21327402, 19398098, 17159489
17640316, 13823394, 16543190, 22024217, 17983675, 20795241, 17481314
18346135, 17598201, 16281493, 15986311, 17208793, 19601468, 18999857
18700935, 14076173, 18428146, 17435488, 18352845, 18352846, 20408163
17592037, 19616601, 17387779, 17391726, 14777968, 15851860, 16206882
20141091, 15832129, 17305100, 20175174, 21113068, 19885321, 16901346
17985714, 18536826, 17780903, 18752378, 18946768, 16876500, 16875342
17769597, 19955755, 16429265, 18336452, 17273003, 17209968, 16988311
19319357, 20094984, 17046460, 17059927, 18053631, 16867761, 18774591
21442094, 20235486, 19359787, 15869775, 17447588, 19642566, 21152052
16798862, 15920201
Patch 24006111 : applied on Fri Oct 11 11:30:54 CST 2019
Unique Patch ID: 20508568
Patch description: "Database Patch Set Update : 11.2.0.4.161018 (24006111)"
Created on 26 Aug 2016, 05:54:48 hrs PST8PDT
Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"
Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"
Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"
Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)"
Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)"
Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)"
Bugs fixed:
17288409, 21051852, 24316947, 17811429, 18607546, 17205719, 20506699
17816865, 17922254, 23330119, 17754782, 16934803, 13364795, 17311728
17441661, 17284817, 16992075, 17446237, 14015842, 19972569, 21756677
17375354, 20925795, 21538558, 17449815, 19463897, 13866822, 17235750
17982555, 17478514, 18317531, 14338435, 18235390, 20803583, 13944971
20142975, 17811789, 16929165, 18704244, 20506706, 17546973, 20334344
14054676, 17088068, 17346091, 18264060, 17343514, 21538567, 19680952
18471685, 19211724, 13951456, 21847223, 16315398, 18744139, 16850630
23177648, 19049453, 18673304, 17883081, 19915271, 18641419, 18262334
17006183, 16065166, 18277454, 16833527, 10136473, 18051556, 17865671
17852463, 18554871, 17853498, 18334586, 17551709, 17588480, 19827973
17344412, 17842825, 18828868, 17025461, 11883252, 13609098, 17239687
17602269, 19197175, 22195457, 18316692, 17313525, 12611721, 19544839
18964939, 17600719, 18191164, 19393542, 17571306, 20777150, 18482502
19466309, 22243719, 17040527, 17165204, 18098207, 16785708, 17465741
17174582, 16180763, 16777840, 12982566, 19463893, 22195465, 22148226
16875449, 12816846, 17237521, 6599380, 19358317, 17811438, 17811447
17945983, 21983325, 18762750, 16912439, 17184721, 18061914, 17282229
18331850, 18202441, 17082359, 18723434, 21972320, 19554106, 14034426
18339044, 19458377, 17752995, 20448824, 17891943, 17258090, 17767676
16668584, 18384391, 17040764, 17381384, 15913355, 18356166, 14084247
20596234, 20506715, 21756661, 13853126, 18203837, 14245531, 16043574
21756699, 22195441, 17848897, 17877323, 21453153, 17468141, 20861693
17786518, 17912217, 17037130, 16956380, 18155762, 17478145, 17394950
18641461, 18189036, 18619917, 17027426, 21352646, 16268425, 24476274
22195492, 19584068, 18436307, 22507210, 17265217, 17634921, 13498382
21526048, 19258504, 20004087, 17443671, 22195485, 18000422, 22321756
20004021, 17571039, 21067387, 16344544, 18009564, 14354737, 21286665
18135678, 18614015, 20441797, 18362222, 17835048, 16472716, 17936109
17050888, 17325413, 14010183, 18747196, 17761775, 16721594, 17082983
20067212, 21179898, 17302277, 18084625, 15990359, 18203835, 17297939
17811456, 22380919, 16731148, 21168487, 14133975, 13829543, 17215560
17694209, 17385178, 18091059, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 22195477, 14368995
22502493, 17346671, 18996843, 17783588, 21343838, 16618694, 17672719
18856999, 18783224, 17851160, 17546761, 17798953, 18273830, 22092979
16596890, 19972566, 16384983, 17726838, 22296366, 17360606, 22321741
13645875, 18199537, 16542886, 21787056, 17889549, 14565184, 17071721
17610798, 20299015, 21343897, 22893153, 20657441, 17397545, 18230522
16360112, 19769489, 12905058, 18641451, 12747740, 18430495, 17016369
17042658, 14602788, 17551063, 19972568, 21517440, 18508861, 19788842
14657740, 17332800, 13837378, 19972564, 17186905, 18315328, 19699191
17437634, 22353199, 18093615, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 17762296, 14692762, 21051840, 17705023, 22507234
19121551, 21330264, 19854503, 21868720, 19309466, 18681862, 20558005
18554763, 17390160, 18456514, 16306373, 13955826, 18139690, 17501491
17752121, 21668627, 17299889, 17889583, 18673325, 19721304, 18293054
17242746, 17951233, 18094246, 17649265, 19615136, 17011832, 16870214
17477958, 18522509, 20631274, 16091637, 17323222, 16595641, 16524926
18228645, 18282562, 17596908, 18031668, 17156148, 16494615, 22683225
17545847, 17655240, 24528741, 17614134, 13558557, 17341326, 17891946
17716305, 22657942, 16392068, 19271443, 21351877, 18092127, 17614227
18440047, 16903536, 14106803, 18973907, 18673342, 19032867, 17389192
17612828, 16194160, 17006570, 17721717, 17390431, 17570240, 16863422
18325460, 19727057, 16422541, 19972570, 17267114, 18244962, 21538485
18765602, 18203838, 16198143, 17246576, 14829250, 17835627, 18247991
14458214, 21051862, 16692232, 17786278, 17227277, 24476265, 16042673
16314254, 16228604, 16837842, 17393683, 23536835, 17787259, 20331945
20074391, 15861775, 16399083, 18018515, 22683212, 18260550, 21051858
17080436, 16613964, 17036973, 16579084, 24433711, 18384537, 18280813
20296213, 16901385, 15979965, 23330124, 18441944, 16450169, 9756271
17892268, 11733603, 16285691, 17587063, 21343775, 18180390, 16538760
18193833, 21387964, 21051833, 17238511, 17824637, 16571443, 18306996
14852021, 17853456, 18674047, 12364061, 22195448
Rac system comprising of multiple nodes
Local node = issdb2
Remote node = issdb1
\--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@issdb2 ~]$
九、 升级数据字典(只在一个节点运行)
[root@issdb1 ~]# su - oracle
[oracle@issdb1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Oct 11 11:58:03 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @?/rdbms/admin/catbundle.sql psu apply
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ISSDB_APPLY_2019Oct11_11_58_31.log
SQL>
十、 单实例打补丁
oracle用户下执行：
sqlplus / as sysdba
shutdown immediate
lsnrctl stop
emctl stop dbconsole
cd /home/oracle/psu/24006111
opatch apply
sqlplus / as sysdba
startup
@?/rdbms/admin/catbundle.sql psu apply
报错：UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed. 说明有应该是有活动的文件进程导致打patch不能进行。
解决办法：
1.停止数据库和监听
2.kill掉所有与oracle相关的进程
日志：
[oracle@ustc-250 24006111]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Nov 9 01:02:33 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ustc-250 24006111]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-NOV-2019 01:02:55
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ustc-250)(PORT=1521)))
The command completed successfully
[oracle@ustc-250 24006111]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.4.0
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
https://ustc-250:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
... Stopped.
[oracle@ustc-250 24006111]$ opatch apply
Oracle 中间补丁程序安装程序版本 11.2.0.3.11
版权所有 (c) 2019, Oracle Corporation。保留所有权利。
Oracle Home : /oracle/product/11.2.0/db
Central Inventory : /oracle/oraInventory
from : /oracle/product/11.2.0/db/oraInst.loc
OPatch version : 11.2.0.3.11
OUI version : 11.2.0.4.0
Log file location : /oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2019-11-09_01-04-26上午_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 21948347 22502456 23054359 24006111
是否继续? [y|n]
y
User Responded with: Y
All checks passed.
提供电子邮件地址以用于接收有关安全问题的通知, 安装 Oracle Configuration Manager 并启动它。如果您使用 My Oracle
Support 电子邮件地址/用户名, 操作将更简单。
有关详细信息, 请访问 http://www.oracle.com/support/policies.html。
电子邮件地址/用户名:
尚未提供电子邮件地址以接收有关安全问题的通知。
是否不希望收到有关安全问题 (是 [Y], 否 [N]) [N] 的通知: y
请关闭本地系统上在此 ORACLE_HOME 之外运行的 Oracle 实例。
(Oracle 主目录 = '/oracle/product/11.2.0/db')
本地系统是否已准备打补丁? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '17478514' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sdo, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.sdo.locator, 11.2.0.4.0 打补丁...
正在为组件 oracle.nlsrtl.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '18031668' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.crs, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.ldap.rsf.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '18522509' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '19121551' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.client, 11.2.0.4.0 打补丁...
正在为组件 oracle.ordim.jai, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '19769489' to OH '/oracle/product/11.2.0/db'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.sysman.agent, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.ovm, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.util, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.oraolap, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '20299013' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.rdbms.dv, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.oci, 11.2.0.4.0 打补丁...
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.common, 10.2.0.4.5 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.common.core, 10.2.0.4.5 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.deconfig, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '20760982' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '21352635' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '21948347' to OH '/oracle/product/11.2.0/db'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.tfa, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.sysman.agent, 10.2.0.4.5 打补丁...
正在为组件 oracle.ovm, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.nlsrtl.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.parser.java, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.console.db, 11.2.0.4.0 打补丁...
正在为组件 oracle.xdk.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.sysman.oms.core, 10.2.0.4.5 打补丁...
Verifying the update...
Applying sub-patch '22502456' to OH '/oracle/product/11.2.0/db'
ApplySession: Oracle 主目录中不存在可选组件 [ oracle.tfa, 11.2.0.4.0 ] , 或找到更高版本。
正在为组件 oracle.precomp.common, 11.2.0.4.0 打补丁...
正在为组件 oracle.oraolap.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.olap, 11.2.0.4.0 打补丁...
正在为组件 oracle.oraolap, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rman, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '23054359' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.rdbms.dv, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
Verifying the update...
Applying sub-patch '24006111' to OH '/oracle/product/11.2.0/db'
正在为组件 oracle.sqlplus.ic, 11.2.0.4.0 打补丁...
正在为组件 oracle.sqlplus, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.rsf, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在为组件 oracle.rdbms.dbscripts, 11.2.0.4.0 打补丁...
Verifying the update...
OPatch 在 make 命令的 stderr 中发现单词 "warning"。
请查看此 stderr。可以重新运行此 make 命令。
Stderr output:
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
OPatch 在 make 命令的 stderr 中发现单词 "warning"。
请查看此 stderr。可以重新运行此 make 命令。
Stderr output:
/bin/ld: warning: -z lazyload ignored.
/bin/ld: warning: -z nolazyload ignored.
Composite patch 24006111 successfully applied.
OPatch 会话已完成, 但出现警告。
Log file location: /oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2019-11-09_01-04-26上午_1.log
