一.环境
1.数据库环境
操作系统版本 : centos 6.7
数据库版本 : 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@CS2-DB1 /]# su - grid
[grid@CS2-DB1 ~]$ cd /u01/app/11.2.0/grid/OPatch/
[grid@CS2-DB1 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/opatch2018-03-27_12-35-12PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-03-27_12-35-12PM.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 = CS2-DB1
Remote node = cs2-db1
Remote node = cs2-db2
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@CS2-DB1 OPatch]$
2、Oracle用户查看版本
[root@CS2-DB1 /]# su - oracle
[oracle@CS2-DB1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@CS2-DB1 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/opatch2018-03-27_12-31-36PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-03-27_12-31-36PM.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 = cs2-db1
Remote node = cs2-db2
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@CS2-DB1 OPatch]$
3、Oracle用户查看数据字典
[root@CS2-DB1 app]# su - oracle
[oracle@CS2-DB1 ~]$ sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 27 14:03:19 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> select * from dba_registry_history;
ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE
------------------------------ ------------------------------
VERSION ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
24-AUG-13 12.03.45.119862 PM
APPLY SERVER
11.2.0.4 0 PSU
Patchset 11.2.0.2.0
ACTION_TIME
---------------------------------------------------------------------------
ACTION NAMESPACE
------------------------------ ------------------------------
VERSION ID BUNDLE_SERIES
------------------------------ ---------- ------------------------------
COMMENTS
--------------------------------------------------------------------------------
10-FEB-18 10.50.40.310095 AM
APPLY SERVER
11.2.0.4 0 PSU
Patchset 11.2.0.2.0
SQL>
三、更新OPatch版本
OPatch下载地址：https://updates.oracle.com/download/6880880.html分别在两个节点更新OPatch版本:
[root@CS2-DB1 /]# cd /u01/app/11.2.0/grid/
[root@CS2-DB1 grid]# mv OPatch OPatch.bak
[root@CS2-DB2 ~]# cd /u01/app/11.2.0/grid/
[root@CS2-DB2 grid]# mv OPatch OPatch.bak
[root@CS2-DB1 grid]# cd /u01/app/oracle/product/11.2.0/db_1/
[root@CS2-DB1 db_1]# mv OPatch OPatch.bak
[root@CS2-DB2 grid]# cd /u01/app/oracle/product/11.2.0/db_1/
[root@CS2-DB2 db_1]# mv OPatch OPatch.bak
[root@CS2-DB1 /]# cd /u01/software/oracle11204/
[root@CS2-DB1 oracle11204]# cp p6880880_112000_Linux-x86-64.zip /u01/app/11.2.0/grid/
[root@CS2-DB1 oracle11204]# cd /u01/app/11.2.0/grid/
[root@CS2-DB1 grid]# unzip p6880880_112000_Linux-x86-64.zip
[root@CS2-DB1 grid]# chown -R grid:oinstall OPatch
[root@CS2-DB2 /]# cd /u01/software/oracle11204/
[root@CS2-DB2 oracle11204]# cp p6880880_112000_Linux-x86-64.zip /u01/app/11.2.0/grid/
[root@CS2-DB2 oracle11204]# cd /u01/app/11.2.0/grid/
[root@CS2-DB2 grid]# unzip p6880880_112000_Linux-x86-64.zip
[root@CS2-DB2 grid]# chown -R grid:oinstall OPatch
[root@CS2-DB1 /]# cd /u01/software/oracle11204/
[root@CS2-DB1 oracle11204]# cp p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0/db_1/
[root@CS2-DB1 oracle11204]# cd /u01/app/oracle/product/11.2.0/db_1/
[root@CS2-DB1 db_1]# unzip p6880880_112000_Linux-x86-64.zip
[root@CS2-DB1 db_1]# chown -R oracle:oinstall OPatch
[root@CS2-DB2 /]# cd /u01/software/oracle11204/
[root@CS2-DB2 oracle11204]# cp p6880880_112000_Linux-x86-64.zip /u01/app/oracle/product/11.2.0/db_1/
[root@CS2-DB2 oracle11204]# cd /u01/app/oracle/product/11.2.0/db_1/
[root@CS2-DB2 db_1]# unzip p6880880_112000_Linux-x86-64.zip
[root@CS2-DB2 db_1]# chown -R oracle:oinstall OPatch
四、将补丁上传到所有节点并解压
[root@CS2-DB1 db_1]# cd /u01/software/oracle11204/
[root@CS2-DB1 oracle11204]# unzip p24436338_112040_Linux-x86-64.zip
[root@CS2-DB1 oracle11204]# chown -R grid:oinstall 24436338
[root@CS2-DB2 db_1]# cd /u01/software/oracle11204/
[root@CS2-DB2 oracle11204]# unzip p24436338_112040_Linux-x86-64.zip
[root@CS2-DB2 oracle11204]# chown -R grid:oinstall 24436338
五、检查需要打的补丁与现有补丁是否冲突
[root@CS2-DB1 oracle11204]# su - grid
[grid@CS2-DB1 ~]$ cd /u01/software/oracle11204/24436338/
[grid@CS2-DB1 24436338]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2018, 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.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-03-28_13-01-18PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[root@CS2-DB2 oracle11204]# su - grid
[grid@CS2-DB2 ~]$ cd /u01/software/oracle11204/24436338/
[grid@CS2-DB2 24436338]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2018, 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.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-03-28_13-04-33PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[grid@CS2-DB2 24436338]$
六.验证Inventory一致性
[grid@CS2-DB1 24436338]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2018, 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.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-03-28_13-06-09PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-03-28_13-06-09PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: CS2-DB1
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 = cs2-db1
Remote node = cs2-db2
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@CS2-DB1 24436338]$
[grid@CS2-DB2 24436338]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2018, 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.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-03-28_13-06-21PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-03-28_13-06-21PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: CS2-DB2
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 = cs2-db2
Remote node = cs2-db1
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@CS2-DB2 24436338]$
七.配置ocm响应文件
[grid@CS2-DB1 24436338]$ exit
logout
[root@CS2-DB1 oracle11204]# cd /u01/app/
[root@CS2-DB1 app]# mkdir PSU
[root@CS2-DB1 app]# chown -R grid:oinstall PSU
[root@CS2-DB1 app]# su - grid
[grid@CS2-DB1 ~]$ cd $ORACLE_HOME/OPatch/ocm/bin
[grid@CS2-DB1 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@CS2-DB1 bin]$ ll
total 16
-rwxr-x--- 1 grid oinstall 9063 Nov 27 2009 emocmrsp
-rw-r--r-- 1 grid oinstall 621 Mar 28 13:43 ocm.rsp
[grid@CS2-DB1 bin]$
[grid@CS2-DB2 24436338]$ exit
logout
[root@CS2-DB2 oracle11204]# cd /u01/app/
[root@CS2-DB2 app]# mkdir PSU
[root@CS2-DB2 app]# chown -R grid:oinstall PSU
[root@CS2-DB2 app]# su - grid
[grid@CS2-DB2 ~]$ cd $ORACLE_HOME/OPatch/ocm/bin
[grid@CS2-DB2 bin]$ ll
total 12
-rwxr-x--- 1 grid oinstall 9063 Nov 27 2009 emocmrsp
[grid@CS2-DB2 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@CS2-DB2 bin]$
八.OPatch apply(所有节点均需执行)(无需关闭任何组件及资源)
可以使用root权限的用户自动为GI和DB打上PSU。必须在每一个节点都要执行，且GI home和DB home不是共享的。而且两个节点不可以并行执行。
[root@CS2-DB1 /]# mkdir /u01/app/11.2.0/grid/.patch_storage
[root@CS2-DB1 /]# chown grid:oinstall /u01/app/11.2.0/grid/.patch_storage
[root@CS2-DB1 /]# chmod 777 /u01/app/11.2.0/grid/.patch_storage
[root@CS2-DB1 /]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/software/oracle11204/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/software/oracle11204 -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/opatchauto2018-03-28_14-19-15.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/opatchauto2018-03-28_14-19-15.report.log
2018-03-28 14:19:15: 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/software/oracle11204/24436338/24006111 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/software/oracle11204/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/software/oracle11204/24436338/24006111 apply successful for home /u01/app/11.2.0/grid
patch /u01/software/oracle11204/24436338/23054319 apply successful for home /u01/app/11.2.0/grid
patch /u01/software/oracle11204/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@CS2-DB1 /]#
[root@CS2-DB2 /]# mkdir /u01/app/11.2.0/grid/.patch_storage
[root@CS2-DB2 /]# chown grid:oinstall /u01/app/11.2.0/grid/.patch_storage
[root@CS2-DB2 /]# chmod 777 /u01/app/11.2.0/grid/.patch_storage
[root@CS2-DB2 /]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/software/oracle11204/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/software/oracle11204 -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/opatchauto2018-03-28_14-39-05.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/opatchauto2018-03-28_14-39-05.report.log
2018-03-28 14:39:05: 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/software/oracle11204/24436338/24006111 apply successful for home /u01/app/oracle/product/11.2.0/db_1
patch /u01/software/oracle11204/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/software/oracle11204/24436338/24006111 apply successful for home /u01/app/11.2.0/grid
patch /u01/software/oracle11204/24436338/23054319 apply successful for home /u01/app/11.2.0/grid
patch /u01/software/oracle11204/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@CS2-DB2 /]#
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@CS2-DB1 /]# su - grid
[grid@CS2-DB1 ~]$ cd /u01/app/11.2.0/grid/OPatch/
[grid@CS2-DB1 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2018, 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.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-03-28_14-58-46PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-03-28_14-58-46PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: CS2-DB1
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 Wed Mar 28 14:33:46 CST 2018
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 Wed Mar 28 14:32:35 CST 2018
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 Wed Mar 28 14:31:20 CST 2018
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:
17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
6599380, 17612828, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
17546761, 18203835, 18964939, 18203838, 18203837, 17313525, 22195457
18139690, 22296366, 14106803, 16837842, 17842825, 22657942, 21352646
20657441, 16360112, 22195441, 17389192, 14565184, 17205719, 14354737
22195448, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436
18673342, 17027426, 19972569, 19972568, 19972566, 17282229, 19972564
16870214, 19615136, 17390431, 18762750, 16613964, 18098207, 17957017
18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719
18317531, 17852463, 17596908, 17655634, 20074391, 16228604, 19972570
18996843, 19854503, 16042673, 17835627, 20334344, 18000422, 20861693
17393683, 17551709, 20506699, 19006849, 18456514, 18277454, 17258090
17174582, 17242746, 16399083, 17824637, 17762296, 17397545, 16450169
12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897
17853456, 18673304, 20004021, 21668627, 16194160, 17477958, 16538760
12982566, 20296213, 18293054, 17610798, 19699191, 18135678, 17311728
16785708, 10136473, 17786518, 18315328, 18334586, 12747740, 19032867
18096714, 17390160, 17232014, 16422541, 18673325, 18155762, 14015842
19827973, 22683225, 17726838, 18554871, 23177648, 18051556, 20803583
18282562, 17922254, 15990359, 21972320, 16855292, 16668584, 21343838
20299015, 17446237, 18093615, 17694209, 17288409, 17274537, 13955826
16934803, 17634921, 17501491, 16315398, 22683212, 17006183, 13829543
18191164, 17655240, 19393542, 18384391, 21538567, 16198143, 21847223
17892268, 20142975, 19584068, 17165204, 18508861, 21756699, 16901385
18554763, 18189036, 17443671, 17385178, 17936109, 14829250, 20925795
17478514, 16850630, 13951456, 16595641, 15861775, 14054676, 16912439
17299889, 17297939, 18619917, 16833527, 17798953, 17816865, 18607546
17571306, 21286665, 17341326, 17851160, 20558005, 17586955, 19049453
21051840, 17587063, 16956380, 18328509, 14133975, 18061914, 21051833
18522509, 18765602, 18199537, 17332800, 13609098, 18384537, 22502493
14338435, 17945983, 21067387, 16392068, 17752995, 21051862, 17237521
16863422, 18244962, 19544839, 24433711, 17156148, 18973907, 17877323
17449815, 18180390, 17088068, 17037130, 20004087, 19466309, 11733603
18084625, 21051858, 18674024, 21051852, 18091059, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 11883252, 21756677, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
17265217, 17071721, 16721594, 21756661, 18262334, 15913355, 17891946
17672719, 17602269, 17239687, 17042658, 17238511, 17811456, 17284817
17752121, 17394950, 16579084, 17011832, 22195465, 14602788, 18325460
24476265, 24476274, 12611721, 16903536, 17006570, 16043574, 18783224
16494615, 21526048, 19197175, 16069901, 17811447, 17308789, 22195477
17865671, 19013183, 17343514, 18316692, 17325413, 16180763, 17348614
14368995, 21983325, 17393915, 16285691, 20331945, 17883081, 24316947
17705023, 17614227, 22195485, 14084247, 13645875, 16777840, 19727057
14852021, 18744139, 18674047, 17716305, 18482502, 19289642, 17622427
22195492, 14458214, 18723434, 17767676, 19258504, 17786278, 17082983
21351877, 13498382, 18331812, 16065166, 18031668, 22893153, 16943711
21517440, 17649265, 13866822, 18094246, 24528741, 14245531, 17783588
17082359, 20448824, 18280813, 23330119, 16268425, 17302277, 18018515
17215560, 19271443, 17016369, 20777150, 23330124, 20441797, 19769489
17545847, 18260550, 13853126, 23536835, 17227277, 9756271, 18868646
17614134, 17546973, 19680952, 18704244, 18828868, 18273830, 17050888
17360606, 16992075, 17375354, 12905058, 18362222, 17571039, 17468141
18436647, 17235750, 21168487, 16220077, 16929165
Rac system comprising of multiple nodes
Local node = cs2-db1
Remote node = cs2-db2
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@CS2-DB1 OPatch]$
[root@CS2-DB2 /]# su - grid
[grid@CS2-DB2 ~]$ cd /u01/app/11.2.0/grid/OPatch/
[grid@CS2-DB2 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.15
Copyright (c) 2018, 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.15
OUI version : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-03-28_15-05-35PM_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-03-28_15-05-35PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: CS2-DB2
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 Wed Mar 28 14:52:36 CST 2018
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 Wed Mar 28 14:51:41 CST 2018
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 Wed Mar 28 14:50:26 CST 2018
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:
17184721, 21538558, 16091637, 18092127, 17381384, 15979965, 18441944
13837378, 16314254, 16731148, 17835048, 13558557, 17201159, 17853498
17246576, 18356166, 18440047, 18681862, 16875449, 19788842, 17296856
21330264, 14010183, 17648596, 17551063, 17025461, 17267114, 22507210
17912217, 17889583, 18202441, 17040764, 16524926, 17478145, 19358317
22148226, 18747196, 18641419, 17036973, 17811789, 14285317, 16542886
18009564, 16618694, 8322815, 16692232, 18247991, 22507234, 17570240
17848897, 17441661, 14034426, 17465741, 16596890, 17437634, 20506706
21343897, 21453153, 18339044, 22321741, 17951233, 18430495, 21787056
22380919, 20506715, 17811429, 19721304, 18230522, 19554106, 19458377
6599380, 17612828, 22092979, 22321756, 17040527, 17811438, 18641461
14657740, 13364795, 21387964, 17346671, 17588480, 18235390, 17889549
19309466, 16472716, 20596234, 18331850, 18641451, 17344412, 21179898
17546761, 18203835, 18964939, 18203838, 18203837, 17313525, 22195457
18139690, 22296366, 14106803, 16837842, 17842825, 22657942, 21352646
20657441, 16360112, 22195441, 17389192, 14565184, 17205719, 14354737
22195448, 14764829, 13944971, 16571443, 21868720, 17186905, 17080436
18673342, 17027426, 19972569, 19972568, 19972566, 17282229, 19972564
16870214, 19615136, 17390431, 18762750, 16613964, 18098207, 17957017
18471685, 19730508, 21538485, 18264060, 17323222, 17754782, 17600719
18317531, 17852463, 17596908, 17655634, 20074391, 16228604, 19972570
18996843, 19854503, 16042673, 17835627, 20334344, 18000422, 20861693
17393683, 17551709, 20506699, 19006849, 18456514, 18277454, 17258090
17174582, 17242746, 16399083, 17824637, 17762296, 17397545, 16450169
12364061, 20067212, 18856999, 19211724, 19463893, 21343775, 19463897
17853456, 18673304, 20004021, 21668627, 16194160, 17477958, 16538760
12982566, 20296213, 18293054, 17610798, 19699191, 18135678, 17311728
16785708, 10136473, 17786518, 18315328, 18334586, 12747740, 19032867
18096714, 17390160, 17232014, 16422541, 18673325, 18155762, 14015842
19827973, 22683225, 17726838, 18554871, 23177648, 18051556, 20803583
18282562, 17922254, 15990359, 21972320, 16855292, 16668584, 21343838
20299015, 17446237, 18093615, 17694209, 17288409, 17274537, 13955826
16934803, 17634921, 17501491, 16315398, 22683212, 17006183, 13829543
18191164, 17655240, 19393542, 18384391, 21538567, 16198143, 21847223
17892268, 20142975, 19584068, 17165204, 18508861, 21756699, 16901385
18554763, 18189036, 17443671, 17385178, 17936109, 14829250, 20925795
17478514, 16850630, 13951456, 16595641, 15861775, 14054676, 16912439
17299889, 17297939, 18619917, 16833527, 17798953, 17816865, 18607546
17571306, 21286665, 17341326, 17851160, 20558005, 17586955, 19049453
21051840, 17587063, 16956380, 18328509, 14133975, 18061914, 21051833
18522509, 18765602, 18199537, 17332800, 13609098, 18384537, 22502493
14338435, 17945983, 21067387, 16392068, 17752995, 21051862, 17237521
16863422, 18244962, 19544839, 24433711, 17156148, 18973907, 17877323
17449815, 18180390, 17088068, 17037130, 20004087, 19466309, 11733603
18084625, 21051858, 18674024, 21051852, 18091059, 16306373, 18306996
19915271, 18193833, 17787259, 20631274, 16344544, 14692762, 18614015
17346091, 18228645, 17721717, 18436307, 11883252, 21756677, 17891943
22353199, 16384983, 19121551, 12816846, 17982555, 17761775, 22243719
17265217, 17071721, 16721594, 21756661, 18262334, 15913355, 17891946
17672719, 17602269, 17239687, 17042658, 17238511, 17811456, 17284817
17752121, 17394950, 16579084, 17011832, 22195465, 14602788, 18325460
24476265, 24476274, 12611721, 16903536, 17006570, 16043574, 18783224
16494615, 21526048, 19197175, 16069901, 17811447, 17308789, 22195477
17865671, 19013183, 17343514, 18316692, 17325413, 16180763, 17348614
14368995, 21983325, 17393915, 16285691, 20331945, 17883081, 24316947
17705023, 17614227, 22195485, 14084247, 13645875, 16777840, 19727057
14852021, 18744139, 18674047, 17716305, 18482502, 19289642, 17622427
22195492, 14458214, 18723434, 17767676, 19258504, 17786278, 17082983
21351877, 13498382, 18331812, 16065166, 18031668, 22893153, 16943711
21517440, 17649265, 13866822, 18094246, 24528741, 14245531, 17783588
17082359, 20448824, 18280813, 23330119, 16268425, 17302277, 18018515
17215560, 19271443, 17016369, 20777150, 23330124, 20441797, 19769489
17545847, 18260550, 13853126, 23536835, 17227277, 9756271, 18868646
17614134, 17546973, 19680952, 18704244, 18828868, 18273830, 17050888
17360606, 16992075, 17375354, 12905058, 18362222, 17571039, 17468141
18436647, 17235750, 21168487, 16220077, 16929165
Rac system comprising of multiple nodes
Local node = cs2-db2
Remote node = cs2-db1
--------------------------------------------------------------------------------
OPatch succeeded.
[grid@CS2-DB2 OPatch]$
九.升级数据字典(只在一个节点运行)
[root@CS2-DB1 /]# su - oracle
[oracle@CS2-DB1 ~]$ cd $ORACLE_HOME/rdbms/admin
[oracle@CS2-DB1 admin]$ sqlplus / as sysdba
SQL> @catbundle.sql psu apply
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2018Mar28_15_23_33.log
SQL> set line 150
SQL> col action_time for a30
SQL> col action for a8
SQL> col namespace for a8
SQL> col version for a10
SQL> col bundle_series for a5
SQL> col comments for a40
SQL> select * from dba_registry_history;
ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- ----------------------------------------
24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
10-FEB-18 10.50.40.310095 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
28-MAR-18 03.24.38.218916 PM APPLY SERVER 11.2.0.4 161018 PSU PSU 11.2.0.4.161018
3 rows selected.
SQL>
458
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
