0.环境描述
两节点12.1.0.2.0 RAC
RedHat Linux 6.6 x86-64
GI和DB均为非共享模式安装
安装12.1.0.2最新PSU GI-12.1.0.2.160719--->23273629
PSU GI-12.1.0.2.160719包含DB对应的PSU--->23054246
$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dbtest3 STABLE
ONLINE ONLINE dbtest4 STABLE
ora.FFRA.dg
ONLINE ONLINE dbtest3 STABLE
ONLINE ONLINE dbtest4 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE dbtest3 STABLE
ONLINE ONLINE dbtest4 STABLE
ora.VOTE.dg
ONLINE ONLINE dbtest3 STABLE
ONLINE ONLINE dbtest4 STABLE
ora.asm
ONLINE ONLINE dbtest3 Started,STABLE
ONLINE ONLINE dbtest4 Started,STABLE
ora.net1.network
ONLINE ONLINE dbtest3 STABLE
ONLINE ONLINE dbtest4 STABLE
ora.ons
ONLINE ONLINE dbtest3 STABLE
ONLINE ONLINE dbtest4 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE dbtest4 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE dbtest3 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE dbtest3 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE dbtest3 169.254.11.173 10.10
.10.4,STABLE
ora.cvu
1 ONLINE ONLINE dbtest3 STABLE
ora.db12c.db
1 ONLINE ONLINE dbtest3 Open,STABLE
2 ONLINE ONLINE dbtest4 Open,STABLE
ora.dbtest3.vip
1 ONLINE ONLINE dbtest3 STABLE
ora.dbtest4.vip
1 ONLINE ONLINE dbtest4 STABLE
ora.mgmtdb
1 ONLINE ONLINE dbtest3 Open,STABLE
ora.oc4j
1 ONLINE ONLINE dbtest3 STABLE
ora.scan1.vip
1 ONLINE ONLINE dbtest4 STABLE
ora.scan2.vip
1 ONLINE ONLINE dbtest3 STABLE
ora.scan3.vip
1 ONLINE ONLINE dbtest3 STABLE
--------------------------------------------------------------------------------
1.更新OPatch
安装12.1.0.2最新PSU 12.1.0.2.160719需要opatch工具版本至少在12.1.0.1.7及以上
使用下面命令检查opatch工具版本是否满足要求【每个节点GRID和DB的home均需要检查opatch版本】
$GRID_HOME/OPatch/opatch version
$ORACLE_HOME/OPatch/opatch version
如果opatch工具版本在12.1.0.1.7以下则更新每个节点GRID和DB的opatch工具
$ unzip /soft/gi/p6880880_121010_Linux-x86-64.zip -d $GRID_HOME
$ unzip /soft/gi/p6880880_121010_Linux-x86-64.zip -d $ORACLE_HOME
再次检查每个节点GRID和DB的home均需要检查opatch版本
[grid@dbtest3 ~]$ $GRID_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.5
OPatch succeeded.
[oracle@dbtest3 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.5
OPatch succeeded.
[grid@dbtest4 gi]$ $GRID_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.5
OPatch succeeded.
[oracle@dbtest4 ~]$ $ORACLE_HOME/OPatch/opatch version
OPatch Version: 12.2.0.1.5
OPatch succeeded.
2.配置OCM文件
RAC两节点使用grid用户生成opatchauto需要的OCM响应文件【这里使用grid用户生成OCM配置文件是因为最终安装的PSU为GI】
[grid@dbtest3 ~]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/grid/file.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 (/home/grid/file.rsp) was successfully created.
[grid@dbtest4 ~]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/grid/file.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 (/home/grid/file.rsp) was successfully created.
3.校验Oracle Inventory
RAC两节点分别执行校验GIRD和DB的Inventory【节点2执行校验输出结果略】
[grid@dbtest3 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME
Oracle Interim Patch Installer version 12.2.0.1.5
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.5
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2016-08-08_12-48-05PM_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2016-08-08_12-48-05PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: dbtest3
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Installed Products (101):
Assistant Common Files 12.1.0.2.0
Automatic Storage Management Assistant 12.1.0.2.0
Buildtools Common Files 12.1.0.2.0
Cluster Ready Services Files 12.1.0.2.0
Cluster Verification Utility Common Files 12.1.0.2.0
Cluster Verification Utility Files 12.1.0.2.0
Database Configuration and Upgrade Assistants 12.1.0.2.0
Database Migration Assistant for Unicode 12.1.0.2.0
Database SQL Scripts 12.1.0.2.0
DB TOOLS Listener 12.1.0.2.0
Deinstallation Tool 12.1.0.2.0
Expat libraries 2.0.1.0.2
Hadoopcore Component 12.1.0.2.0
HAS Common Files 12.1.0.2.0
HAS Files for DB 12.1.0.2.0
Installation Common Files 12.1.0.2.0
Installation Plugin Files 12.1.0.2.0
Installer SDK Component 12.1.0.2.0
Java Development Kit 1.6.0.75.0
LDAP Required Support Files 12.1.0.2.0
OLAP SQL Scripts 12.1.0.2.0
Oracle Advanced Security 12.1.0.2.0
Oracle Bali Share 11.1.1.6.0
Oracle Clusterware RDBMS Files 12.1.0.2.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.2.0
Oracle Core Required Support Files 12.1.0.2.0
Oracle Core Required Support Files for Core DB 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c Multimedia Files 12.1.0.2.0
Oracle Database Deconfiguration 12.1.0.2.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.2.0
Oracle DBCA Deconfiguration 12.1.0.2.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support For Core 12.1.0.2.0
Oracle Grid Infrastructure 12c 12.1.0.2.0
Oracle Grid Infrastructure Bundled Agents 12.1.0.2.0
Oracle Grid Management Database 12.1.0.2.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 12.1.0.2.0
Oracle Java Client 12.1.0.2.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC/OCI Instant Client 12.1.0.2.0
Oracle JDBC/THIN Interfaces 12.1.0.2.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.2.0
Oracle JVM For Core 12.1.0.2.0
Oracle LDAP administration 12.1.0.2.0
Oracle Locale Builder 12.1.0.2.0
Oracle Multimedia 12.1.0.2.0
Oracle Multimedia Client Option 12.1.0.2.0
Oracle Multimedia Java Advanced Imaging 12.1.0.2.0
Oracle Multimedia Locator 12.1.0.2.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0
Oracle Multimedia Locator RDBMS Files 12.1.0.2.0
Oracle Net 12.1.0.2.0
Oracle Net Java Required Support Files 12.1.0.2.0
Oracle Net Listener 12.1.0.2.0
Oracle Net Required Support Files 12.1.0.2.0
Oracle Netca Client 12.1.0.2.0
Oracle Notification Service 12.1.0.2.0
Oracle Notification Service (eONS) 12.1.0.2.0
Oracle Notification Service for Instant Client 12.1.0.2.0
Oracle One-Off Patch Installer 12.1.0.1.2
Oracle Quality of Service Management (Client) 12.1.0.2.0
Oracle Quality of Service Management (Server) 12.1.0.2.0
Oracle RAC Deconfiguration 12.1.0.2.0
Oracle RAC Required Support Files-HAS 12.1.0.2.0
Oracle Recovery Manager 12.1.0.2.0
Oracle Security Developer Tools 12.1.0.2.0
Oracle Text Required Support Files 12.1.0.2.0
Oracle Universal Connection Pool 12.1.0.2.0
Oracle Universal Installer 12.1.0.2.0
Oracle USM Deconfiguration 12.1.0.2.0
Oracle Wallet Manager 12.1.0.2.0
oracle.swd.oui.core.min 12.1.0.2.0
Parser Generator Required Support Files 12.1.0.2.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.2.0
PL/SQL Embedded Gateway 12.1.0.2.0
Platform Required Support Files 12.1.0.2.0
Precompiler Required Support Files 12.1.0.2.0
RDBMS Required Support Files 12.1.0.2.0
RDBMS Required Support Files for Instant Client 12.1.0.2.0
RDBMS Required Support Files Runtime 12.1.0.2.0
Required Support Files 12.1.0.2.0
Secure Socket Layer 12.1.0.2.0
SQL*Plus 12.1.0.2.0
SQL*Plus Files for Instant Client 12.1.0.2.0
SQL*Plus Required Support Files 12.1.0.2.0
SSL Required Support Files for InstantClient 12.1.0.2.0
Tracle File Analyzer 12.1.0.2.0
Universal Storage Manager Files 12.1.0.2.0
XDK Required Support Files 12.1.0.2.0
XML Parser for Java 12.1.0.2.0
There are 101 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
0 dbtest3,dbtest4
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@dbtest3 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
Oracle Interim Patch Installer version 12.2.0.1.5
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.5
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-08-08_12-48-10PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-08-08_12-48-10PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: dbtest3
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Installed Products (135):
Assistant Common Files 12.1.0.2.0
Buildtools Common Files 12.1.0.2.0
Cluster Verification Utility Common Files 12.1.0.2.0
Database Configuration and Upgrade Assistants 12.1.0.2.0
Database Migration Assistant for Unicode 12.1.0.2.0
Database SQL Scripts 12.1.0.2.0
Database Workspace Manager 12.1.0.2.0
DB TOOLS Listener 12.1.0.2.0
Deinstallation Tool 12.1.0.2.0
Enterprise Edition Options 12.1.0.2.0
Expat libraries 2.0.1.0.2
Generic Connectivity Common Files 12.1.0.2.0
Hadoopcore Component 12.1.0.2.0
HAS Common Files 12.1.0.2.0
HAS Files for DB 12.1.0.2.0
Installation Common Files 12.1.0.2.0
Installation Plugin Files 12.1.0.2.0
Installer SDK Component 12.1.0.2.0
JAccelerator (COMPANION) 12.1.0.2.0
Java Development Kit 1.6.0.75.0
LDAP Required Support Files 12.1.0.2.0
OLAP SQL Scripts 12.1.0.2.0
Oracle Advanced Security 12.1.0.2.0
Oracle Application Express 12.1.0.2.0
Oracle Bali Share 11.1.1.6.0
Oracle Call Interface (OCI) 12.1.0.2.0
Oracle Clusterware RDBMS Files 12.1.0.2.0
Oracle Configuration Manager 10.3.8.1.1
Oracle Configuration Manager Client 10.3.2.1.0
Oracle Configuration Manager Deconfiguration 10.3.1.0.0
Oracle Containers for Java 12.1.0.2.0
Oracle Context Companion 12.1.0.2.0
Oracle Core Required Support Files 12.1.0.2.0
Oracle Core Required Support Files for Core DB 12.1.0.2.0
Oracle Core XML Development Kit 12.1.0.2.0
Oracle Data Mining RDBMS Files 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c 12.1.0.2.0
Oracle Database 12c Multimedia Files 12.1.0.2.0
Oracle Database Deconfiguration 12.1.0.2.0
Oracle Database Gateway for ODBC 12.1.0.2.0
Oracle Database Plugin for Oracle Virtual Assembly Builder 12.1.0.2.0
Oracle Database User Interface 11.0.0.0.0
Oracle Database Utilities 12.1.0.2.0
Oracle Database Vault option 12.1.0.2.0
Oracle DBCA Deconfiguration 12.1.0.2.0
Oracle Extended Windowing Toolkit 11.1.1.6.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support 12.1.0.2.0
Oracle Globalization Support For Core 12.1.0.2.0
Oracle Help for Java 11.1.1.7.0
Oracle Help Share Library 11.1.1.7.0
Oracle Ice Browser 11.1.1.7.0
Oracle Internet Directory Client 12.1.0.2.0
Oracle Java Client 12.1.0.2.0
Oracle Java Layout Engine 11.0.0.0.0
Oracle JDBC Server Support Package 12.1.0.2.0
Oracle JDBC/OCI Instant Client 12.1.0.2.0
Oracle JDBC/THIN Interfaces 12.1.0.2.0
Oracle JFC Extended Windowing Toolkit 11.1.1.6.0
Oracle JVM 12.1.0.2.0
Oracle JVM For Core 12.1.0.2.0
Oracle Label Security 12.1.0.2.0
Oracle LDAP administration 12.1.0.2.0
Oracle Locale Builder 12.1.0.2.0
Oracle Message Gateway Common Files 12.1.0.2.0
Oracle Multimedia 12.1.0.2.0
Oracle Multimedia Client Option 12.1.0.2.0
Oracle Multimedia Java Advanced Imaging 12.1.0.2.0
Oracle Multimedia Locator 12.1.0.2.0
Oracle Multimedia Locator Java Required Support Files 12.1.0.2.0
Oracle Multimedia Locator RDBMS Files 12.1.0.2.0
Oracle Net 12.1.0.2.0
Oracle Net Java Required Support Files 12.1.0.2.0
Oracle Net Listener 12.1.0.2.0
Oracle Net Required Support Files 12.1.0.2.0
Oracle Net Services 12.1.0.2.0
Oracle Netca Client 12.1.0.2.0
Oracle Notification Service 12.1.0.2.0
Oracle Notification Service (eONS) 12.1.0.2.0
Oracle Notification Service for Instant Client 12.1.0.2.0
Oracle ODBC Driver 12.1.0.2.0
Oracle ODBC Driverfor Instant Client 12.1.0.2.0
Oracle OLAP 12.1.0.2.0
Oracle OLAP API 12.1.0.2.0
Oracle OLAP RDBMS Files 12.1.0.2.0
Oracle One-Off Patch Installer 12.1.0.1.2
Oracle Partitioning 12.1.0.2.0
Oracle Programmer 12.1.0.2.0
Oracle Quality of Service Management (Client) 12.1.0.2.0
Oracle R Enterprise Server Files 12.1.0.2.0
Oracle RAC Deconfiguration 12.1.0.2.0
Oracle RAC Required Support Files-HAS 12.1.0.2.0
Oracle Real Application Testing 12.1.0.2.0
Oracle Recovery Manager 12.1.0.2.0
Oracle Security Developer Tools 12.1.0.2.0
Oracle Spatial and Graph 12.1.0.2.0
Oracle SQL Developer 12.1.0.2.0
Oracle Starter Database 12.1.0.2.0
Oracle Text 12.1.0.2.0
Oracle Text ATG Language Support Files 12.1.0.2.0
Oracle Text for Core 12.1.0.2.0
Oracle Text Required Support Files 12.1.0.2.0
Oracle Universal Connection Pool 12.1.0.2.0
Oracle Universal Installer 12.1.0.2.0
Oracle USM Deconfiguration 12.1.0.2.0
Oracle Wallet Manager 12.1.0.2.0
Oracle XML Development Kit 12.1.0.2.0
Oracle XML Query 12.1.0.2.0
oracle.swd.oui.core.min 12.1.0.2.0
Parser Generator Required Support Files 12.1.0.2.0
Perl Interpreter 5.14.1.0.0
Perl Modules 5.14.1.0.0
PL/SQL 12.1.0.2.0
PL/SQL Embedded Gateway 12.1.0.2.0
Platform Required Support Files 12.1.0.2.0
Precompiler Common Files 12.1.0.2.0
Precompiler Common Files for Core 12.1.0.2.0
Precompiler Required Support Files 12.1.0.2.0
Precompilers 12.1.0.2.0
RDBMS Required Support Files 12.1.0.2.0
RDBMS Required Support Files for Instant Client 12.1.0.2.0
RDBMS Required Support Files Runtime 12.1.0.2.0
Required Support Files 12.1.0.2.0
Sample Schema Data 12.1.0.2.0
Secure Socket Layer 12.1.0.2.0
SQL*Plus 12.1.0.2.0
SQL*Plus Files for Instant Client 12.1.0.2.0
SQL*Plus Required Support Files 12.1.0.2.0
SQLJ Runtime 12.1.0.2.0
SSL Required Support Files for InstantClient 12.1.0.2.0
Tracle File Analyzer 12.1.0.2.0
XDK Required Support Files 12.1.0.2.0
XML Parser for Java 12.1.0.2.0
XML Parser for Oracle JVM 12.1.0.2.0
There are 135 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = dbtest3
Remote node = dbtest4
--------------------------------------------------------------------------------
OPatch succeeded.
4.RAC两节点下载解压GI PSU补丁包
[grid@dbtest3 gi]$ pwd
/soft/gi
[grid@dbtest3 gi]$ unzip p23273629_121020_Linux-x86-64.zip
[grid@dbtest3 gi]$ scp p23273629_121020_Linux-x86-64.zip dbtest4:/soft/gi/
p23273629_121020_Linux-x86-64.zip 100% 1353MB 58.8MB/s 00:23
[grid@dbtest4 gi]$ pwd
/soft/gi
[grid@dbtest4 gi]$ unzip p23273629_121020_Linux-x86-64.zip
5.RAC两节点PSU补丁包冲突检测
[root@dbtest3 ~]# $GRID_HOME/OPatch/opatchauto apply /soft/gi/23273629 -analyze -ocmrf /home/grid/file.rsp
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-08-08_01-04-32PM.log.
Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-08-08_01-05-06PM.log
WARNING: the option -ocmrf is deprecated and no longer needed. OPatch no longer checks for OCM configuration. It will be removed in a future release.
The id for this session is T8GT
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/12.1.0/grid
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing OPatch prereq operations to verify patch applicability on CRS Home........
Executing OPatch prereq operations to verify patch applicability on RAC Home........
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] Executing GIRACPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
[init:init] Executing GIRACPrereqAction action on home /u01/app/12.1.0/grid
Executing prereq operations before applying on CRS Home........
Executing prereq operations before applying on RAC Home........
[init:init] GIRACPrereqAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] GIRACPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] Executing RACDBPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing prereq operations before applying on RAC Home........
[init:init] RACDBPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:dbtest3
CRS Home:/u01/app/12.1.0/grid
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /soft/gi/23273629/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-05-28PM_1.log
Patch: /soft/gi/23273629/23054246
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-05-28PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-05-28PM_1.log
Patch: /soft/gi/23273629/23054341
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-05-28PM_1.log
Host:dbtest3
RAC Home:/u01/app/oracle/product/12.1.0/db_1
==Following patches were SKIPPED:
Patch: /soft/gi/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/gi/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /soft/gi/23273629/23054246
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-05-34PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-05-34PM_1.log
[root@dbtest4 gi]# $GRID_HOME/OPatch/opatchauto apply /soft/gi/23273629 -analyze -ocmrf /home/grid/file.rsp
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-08-08_01-15-20PM.log.
Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-08-08_01-15-51PM.log
WARNING: the option -ocmrf is deprecated and no longer needed. OPatch no longer checks for OCM configuration. It will be removed in a future release.
The id for this session is 2CI6
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/12.1.0/db_1
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/12.1.0/grid
Executing OPatch prereq operations to verify patch applicability on CRS Home........
Executing OPatch prereq operations to verify patch applicability on RAC Home........
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] Executing GIRACPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
[init:init] Executing GIRACPrereqAction action on home /u01/app/12.1.0/grid
Executing prereq operations before applying on CRS Home........
Executing prereq operations before applying on RAC Home........
[init:init] GIRACPrereqAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] GIRACPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] Executing RACDBPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing prereq operations before applying on RAC Home........
[init:init] RACDBPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
OPatchAuto successful.
--------------------------------Summary--------------------------------
Analysis for applying patches has completed successfully:
Host:dbtest4
CRS Home:/u01/app/12.1.0/grid
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /soft/gi/23273629/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-16-10PM_1.log
Patch: /soft/gi/23273629/23054246
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-16-10PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-16-10PM_1.log
Patch: /soft/gi/23273629/23054341
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-16-10PM_1.log
Host:dbtest4
RAC Home:/u01/app/oracle/product/12.1.0/db_1
==Following patches were SKIPPED:
Patch: /soft/gi/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/gi/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY analyzed to be applied:
Patch: /soft/gi/23273629/23054246
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-16-15PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-16-15PM_1.log
6.以auto方式打一次性打GI和DB PSU补丁
因为GI PSU包含DB的PSU而auto方式可以一次性将GI和DB PSU打上
两个节点分别打各自的PSU补丁需要以root用户执行
[root@dbtest3 ~]# $GRID_HOME/OPatch/opatchauto apply /soft/gi/23273629 -ocmrf /home/grid/file.rsp
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-08-08_01-25-06PM.log.
Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-08-08_01-25-38PM.log
WARNING: the option -ocmrf is deprecated and no longer needed. OPatch no longer checks for OCM configuration. It will be removed in a future release.
The id for this session is JIKY
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/12.1.0/grid
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing OPatch prereq operations to verify patch applicability on RAC Home........
Executing OPatch prereq operations to verify patch applicability on CRS Home........
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] Executing GIRACPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
[init:init] Executing GIRACPrereqAction action on home /u01/app/12.1.0/grid
Executing prereq operations before applying on CRS Home........
Executing prereq operations before applying on RAC Home........
[init:init] GIRACPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] GIRACPrereqAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] Executing RACDBPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing prereq operations before applying on RAC Home........
[init:init] RACDBPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[shutdown:prepare-shutdown] Executing RACPrepareShutDownAction action on home /u01/app/oracle/product/12.1.0/db_1
Preparing RAC Home to bring down database service........
[shutdown:prepare-shutdown] RACPrepareShutDownAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[shutdown:shutdown] Executing GIShutDownAction action on home /u01/app/12.1.0/grid
Performing prepatch operations on CRS Home........
Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_dbtest3_2016-08-08_01-29-38PM.log
[shutdown:shutdown] GIShutDownAction action completed on home /u01/app/12.1.0/grid successfully
[offline:prepare] Executing RACPatchingAction action on home /u01/app/oracle/product/12.1.0/db_1
Performing prepatch operation on RAC Home........
[offline:prepare] RACPatchingAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/12.1.0/db_1
Start applying binary patches on RAC Home........
[offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[offline:finalize] Executing RACPatchingAction action on home /u01/app/oracle/product/12.1.0/db_1
Performing postpatch operation on RAC Home........
[offline:finalize] RACPatchingAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/app/12.1.0/grid
Start applying binary patches on CRS Home........
[offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/app/12.1.0/grid successfully
[startup:startup] Executing GIStartupAction action on home /u01/app/12.1.0/grid
Performing postpatch operations on CRS Home........
Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_dbtest3_2016-08-08_01-41-29PM.log
[startup:startup] GIStartupAction action completed on home /u01/app/12.1.0/grid successfully
[startup:finalize] Executing RACFinalizeStartAction action on home /u01/app/oracle/product/12.1.0/db_1
No step execution required.........
[startup:finalize] RACFinalizeStartAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[online:product-patching] Executing RACOnlineAction action on home /u01/app/oracle/product/12.1.0/db_1
Trying to apply SQL patches on RAC Home.
[online:product-patching] RACOnlineAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/app/12.1.0/grid
Verifying patches applied on CRS Home.
[finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/app/12.1.0/grid successfully
[finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/app/oracle/product/12.1.0/db_1
Verifying patches applied on RAC Home.
[finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:dbtest3
RAC Home:/u01/app/oracle/product/12.1.0/db_1
Summary:
==Following patches were SKIPPED:
Patch: /soft/gi/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/gi/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /soft/gi/23273629/23054246
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-31-19PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-31-19PM_1.log
Host:dbtest3
CRS Home:/u01/app/12.1.0/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /soft/gi/23273629/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-35-05PM_1.log
Patch: /soft/gi/23273629/23054246
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-35-05PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-35-05PM_1.log
Patch: /soft/gi/23273629/23054341
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_13-35-05PM_1.log
[root@dbtest4 gi]# $GRID_HOME/OPatch/opatchauto apply /soft/gi/23273629 -ocmrf /home/grid/file.rsp
System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2016-08-08_02-02-33PM.log.
Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2016-08-08_02-03-02PM.log
WARNING: the option -ocmrf is deprecated and no longer needed. OPatch no longer checks for OCM configuration. It will be removed in a future release.
The id for this session is 7ZH1
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/12.1.0/grid
[init:init] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing OPatch prereq operations to verify patch applicability on CRS Home........
Executing OPatch prereq operations to verify patch applicability on RAC Home........
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] Executing GIRACPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
[init:init] Executing GIRACPrereqAction action on home /u01/app/12.1.0/grid
Executing prereq operations before applying on CRS Home........
Executing prereq operations before applying on RAC Home........
[init:init] GIRACPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[init:init] GIRACPrereqAction action completed on home /u01/app/12.1.0/grid successfully
[init:init] Executing RACDBPrereqAction action on home /u01/app/oracle/product/12.1.0/db_1
Executing prereq operations before applying on RAC Home........
[init:init] RACDBPrereqAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[shutdown:prepare-shutdown] Executing RACPrepareShutDownAction action on home /u01/app/oracle/product/12.1.0/db_1
Preparing RAC Home to bring down database service........
[shutdown:prepare-shutdown] RACPrepareShutDownAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[shutdown:shutdown] Executing GIShutDownAction action on home /u01/app/12.1.0/grid
Performing prepatch operations on CRS Home........
Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_dbtest4_2016-08-08_02-08-20PM.log
[shutdown:shutdown] GIShutDownAction action completed on home /u01/app/12.1.0/grid successfully
[offline:prepare] Executing RACPatchingAction action on home /u01/app/oracle/product/12.1.0/db_1
Performing prepatch operation on RAC Home........
[offline:prepare] RACPatchingAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/app/oracle/product/12.1.0/db_1
Start applying binary patches on RAC Home........
[offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[offline:finalize] Executing RACPatchingAction action on home /u01/app/oracle/product/12.1.0/db_1
Performing postpatch operation on RAC Home........
[offline:finalize] RACPatchingAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[offline:binary-patching] Executing OPatchAutoBinaryAction action on home /u01/app/12.1.0/grid
Start applying binary patches on CRS Home........
[offline:binary-patching] OPatchAutoBinaryAction action completed on home /u01/app/12.1.0/grid successfully
[startup:startup] Executing GIStartupAction action on home /u01/app/12.1.0/grid
Performing postpatch operations on CRS Home........
Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_dbtest4_2016-08-08_02-19-55PM.log
[startup:startup] GIStartupAction action completed on home /u01/app/12.1.0/grid successfully
[startup:finalize] Executing RACFinalizeStartAction action on home /u01/app/oracle/product/12.1.0/db_1
No step execution required.........
[startup:finalize] RACFinalizeStartAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[online:product-patching] Executing RACOnlineAction action on home /u01/app/oracle/product/12.1.0/db_1
Trying to apply SQL patches on RAC Home.
[online:product-patching] RACOnlineAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
[finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/app/12.1.0/grid
Verifying patches applied on CRS Home.
[finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/app/12.1.0/grid successfully
[finalize:finalize] Executing OracleHomeLSInventoryGrepAction action on home /u01/app/oracle/product/12.1.0/db_1
Verifying patches applied on RAC Home.
[finalize:finalize] OracleHomeLSInventoryGrepAction action completed on home /u01/app/oracle/product/12.1.0/db_1 successfully
OPatchAuto successful.
--------------------------------Summary--------------------------------
Patching is completed successfully. Please find the summary as follows:
Host:dbtest4
RAC Home:/u01/app/oracle/product/12.1.0/db_1
Summary:
==Following patches were SKIPPED:
Patch: /soft/gi/23273629/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"
Patch: /soft/gi/23273629/23054341
Reason: This patch is not applicable to this specified target type - "rac_database"
==Following patches were SUCCESSFULLY applied:
Patch: /soft/gi/23273629/23054246
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_14-09-37PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_14-09-37PM_1.log
Host:dbtest4
CRS Home:/u01/app/12.1.0/grid
Summary:
==Following patches were SUCCESSFULLY applied:
Patch: /soft/gi/23273629/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_14-13-24PM_1.log
Patch: /soft/gi/23273629/23054246
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_14-13-24PM_1.log
Patch: /soft/gi/23273629/23054327
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_14-13-24PM_1.log
Patch: /soft/gi/23273629/23054341
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2016-08-08_14-13-24PM_1.log
7.检查PSU是否更新成功
SQL> select patch_id, patch_uid, version, status, description
2 from dba_registry_sqlpatch
3 where bundle_series = 'PSU';
PATCH_ID PATCH_UID VERSION STATUS DESCRIPTION
---------- ---------- -------------------- --------------- ----------------------------------------------------------------------
23054246 20213895 12.1.0.2 SUCCESS Database Patch Set Update : 12.1.0.2.160719 (23054246)
也可以使用opatch lsinventory检查
$GRID_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.5
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/12.1.0/grid
Central Inventory : /u01/app/oraInventory
from : /u01/app/12.1.0/grid/oraInst.loc
OPatch version : 12.2.0.1.5
OUI version : 12.1.0.2.0
Log file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/opatch2016-08-08_17-12-05PM_1.log
Lsinventory Output file location : /u01/app/12.1.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2016-08-08_17-12-05PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: dbtest4
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Grid Infrastructure 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (4) :
Patch 23054341 : applied on Mon Aug 08 14:19:49 CST 2016
Unique Patch ID: 20208719
Patch description: "ACFS Patch Set Update : 12.1.0.2.160719 (23054341)"
Created on 13 Jun 2016, 03:33:03 hrs PST8PDT
Bugs fixed:
19452723, 18900953, 21208140, 19844362, 18951113, 19526234, 18899600
22810422, 20923224, 19517835, 18185024, 19013966, 19195735, 19001684
19509898, 19053182, 22087780, 20438706, 19593769, 19610001, 19475588
19811784, 18957085, 19279106, 19184398, 20098064, 22222222, 22198405
20140148, 21519796, 19450090, 19502657, 19859183, 18877486, 18915417
21231953, 19060056, 18955907, 19078259, 19919907, 19127216, 20010980
18934139, 22689989, 19335268, 21555038, 20681968, 18851012, 19149476
20952520, 19526283, 19428756, 19183802, 19051391, 22846612, 19690653
19355146, 20314907, 20402287, 22661787, 19644505, 22198176, 19353057
19270227, 19201087, 21233961, 21124596, 19901825, 19610022, 19446719
19649858, 18321597, 19557156, 19469788, 21076821, 22319558, 18510745
19528981, 21369858, 19134464
Patch 23054327 : applied on Mon Aug 08 14:17:54 CST 2016
Unique Patch ID: 20208671
Patch description: "OCW Patch Set Update : 12.1.0.2.160719 (23054327)"
Created on 16 Jul 2016, 06:57:02 hrs PST8PDT
Bugs fixed:
21339083, 19701617, 18589889, 20768643, 19139608, 19280860, 19061429
21453435, 19133945, 19341538, 19521169, 20011424, 18946768, 19135521
18604143, 19361757, 19187207, 19302350, 19627476, 19130141, 19530755
20568884, 20317221, 19699720, 20177779, 19620918, 19168690, 19266658
18899171, 19244316, 19653795, 18330979, 19027351, 18634372, 19471722
21227730, 18707416, 19536337, 19184188, 19131709, 21113068, 20235486
19925992, 20160490, 20006646, 20995001, 18991776, 18439295, 15922206
21131037, 19380733, 21245437, 18943696, 20552947, 19591984, 19550195
19163425, 18135723, 20014326, 19524857, 18849021, 18890943, 18861196
19154753, 17940721, 18524834, 18748932, 18835283, 19522313, 19184765
19499021, 21639478, 19046190, 20923930, 14851828, 20028666, 19051385
19050688, 19682695, 19831611, 20598625, 19226141, 21607972, 19053891
18871287, 18998228, 18922918, 18980002, 21087799, 18956780, 19683886
19325604, 19682778, 23757020, 19026993, 18777835, 20110156, 17338864
21269977, 18261648, 18362971, 19558324, 22651583, 18945906, 19513650
20185476, 18952577, 19702758, 18882642, 19478119, 19414274, 17447588
19262534, 20752167, 19147513, 21242118, 19514085, 19473088, 20758997
19178517, 18729269, 19529729, 19659885, 19455563, 19319904, 20877072
18703978, 18536826, 20340620, 19700256, 19703246, 19292605, 20467806
22264951, 19192901, 21527118, 20920711, 20660273, 20011635, 17592037
22989069, 19479503, 19147751, 19029647, 19179158, 22302421, 18901356
19140712, 20012766, 21232394, 18964974, 22162062, 18835366, 19184276
19013789, 19207286, 20001507, 20510208, 18950232, 22583325, 19259765
19148791, 19680763, 20079414, 19556820, 16505171, 22135419, 19449737
18962892, 21646169, 19187515, 19513888, 19230771, 14661880, 21519340
20218012, 21222147, 20795241, 19453778, 19853036, 19551830, 19068333
21616278, 18843572, 18520351, 18945435, 19185148, 19232454, 20775015
21220597, 18541110, 19319192, 18834955, 19204743, 19178629, 20839581
19304104, 21694237, 19140891, 18747335, 19284357, 20676340, 19270660
19457575, 20725084, 21297657, 19021575, 19069755, 18715884, 18798573
19584688, 19018001, 19812592, 19325701, 19270956, 19292272, 21967791
20877003, 21794779, 18700893, 19222693, 19662663, 21276514, 18406774
19684131, 20607821, 19010177, 21082737, 19272663, 18910576, 18907170
21694632, 19426384, 9372680, 20115586, 20883009, 19700294, 19164099
20289828, 19331454, 18283792, 20278216, 20827053, 19155350, 20119857
19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
18798432, 19146822, 19589221, 21123424, 18952857, 19471836, 19537762
20936562, 21152052, 16286734, 18750781, 20669114, 18762843, 18945249
19045143, 19146980, 22483804, 19184799, 19205086, 19601003, 20099624
19351363, 21378016, 20091753, 18862203, 19281106, 19537547, 19031737
19079087, 19148367, 18968981, 19150517, 20231741, 19954372, 19217019
18730096, 18235274, 18975620, 19205617, 19513351, 18843054, 19150313
20219458, 18708349, 19332386, 18953639, 19067804, 21423055, 21259359
19371270, 19203996, 19054979, 19209951, 19318983, 18747382, 20038431
19154673, 18752378, 22905714, 19150088, 19370846, 19013444, 19234177
21053036, 18998379, 20157569, 21357522, 18999857, 19273577, 19075747
19367276, 19632437, 18990354, 19288396, 19874047, 19612597, 19557558
20620581, 19427050, 19127078, 18910443, 20900588, 22088198, 20053557
20033787, 19315567, 19444471, 19148982, 20953798, 18290252, 18813323
19915945, 19777496, 19500293, 20730170, 18643483, 19277814, 19134098
18523468, 20562133, 19071526, 21420753, 18965694, 19226858, 18850051
20433932, 19602208, 19591356, 22884308, 20061168, 18417590, 19370739
18920408, 20822591, 18636884, 19609388, 20136892, 18776786, 18989446
22289350, 19148793, 19043795, 19585454, 20746507, 18260170, 18317489
19955755, 18919682, 19059053, 19807548, 19124972, 18678829, 19147509
18849896, 19617592, 18910748, 18953878, 19273758, 19319357, 19076165
18999195, 19498411, 19704993, 18759724, 21294273, 19459023, 20634511
21474380, 19066844, 21484367, 20276459, 17208793, 19234907, 20290467
13843841, 19538714, 19649640, 19383028, 19062675, 21924910, 19513969
22195657, 18859710, 20862812, 19504641, 19341481, 18304090, 20293730
19986391, 19343245, 19314048, 18834934, 19473851, 19241655, 19458082
18242738, 19470791, 18894342, 20649573, 18372060, 19522067, 18953889
18827679, 19259290, 19023430, 19140711, 19045388, 20186278, 19241857
19522571, 19076778, 18875012, 19709663, 18861564, 19066699, 19273760
19225265, 15885689, 20853464, 18819158, 21696068, 19068003, 18937186
20267877, 19049721, 21394146, 19916737, 19368917, 22393909, 21255373
19635215, 18868829, 19613533, 20579351, 20408163, 20350915, 21327402
21057239, 22024217, 20783416, 19315522, 19141785, 23101338, 19163887
19885321, 19820247, 18715868, 18852058, 20363708, 19538241, 19804032
Patch 23054246 : applied on Mon Aug 08 14:15:26 CST 2016
Unique Patch ID: 20213895
Patch description: "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Created on 5 Jul 2016, 07:07:59 hrs PST8PDT
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19189525, 21847223, 21099555, 21649497, 19075256, 19141838, 22762046
22075064, 20117253, 19865345, 19791273, 18845653, 19280225, 19248799
19243521, 20951038, 18988834, 21756699, 21281532, 19238590, 21184223
18921743, 20245930, 18799063, 19134173, 20373598, 19571367, 20476175
20925795, 19018206, 20509482, 20711718, 20387265, 20588502, 19149990
21263635, 18849537, 18886413, 17551063, 22507210, 19183343, 19366375
19703301, 21917884, 19001390, 18202441, 19189317, 20267166, 19644859
19390567, 19358317, 19279273, 19706965, 18549238, 16863642, 19068970
22528741, 18797519, 20825533, 19619732, 18607546, 20348653, 19649152
19670108, 18940497, 18948177, 19315691, 19676905, 18964978, 19176326
20165574, 19035573, 20413820, 17867700, 20558005, 19176223, 19532017
20904530, 20134339, 19450314, 19074147, 22353346, 20868862, 18411216
22507234, 20361671, 20425790, 18966843, 20009833, 22366558, 21329301
20294666, 18191823, 19333670, 19195895, 19371175, 19307662, 19154375
20043616, 20124446, 18914624, 19468991, 19883092, 21291274, 19382851
19520602, 19174521, 21875360, 19676012, 19326908, 19658708, 19591608
19402853, 20093776, 20618595, 21787056, 22380919, 21246723, 17835294
19721304, 19068610, 19791377, 21665897, 22178855, 22173980, 20048359
20746251, 19143550, 20898391, 19185876, 19627012, 20281121, 19577410
22092979, 19001359, 14283239, 19518079, 18610915, 19490948, 17532734
18674024, 18306996, 19309466, 19081128, 19524158, 19915271, 20122715
21188532, 18791688, 20284155, 20890311, 21442094, 20596234, 18973548
21296029, 19303936, 19597439, 20936905, 20235511, 21220620, 20880215
18964939, 21756677, 19888853, 19534363, 19430401, 19354335, 19044962
19639483, 22296366, 22353199, 21153266, 19409212, 19879746, 20657441
19684504, 20528052, 19024808, 20977794, 20378086, 18799993, 21756661
21260431, 18740837, 22923409, 19028800, 20877664, 20228093, 20879889
19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 17722075
19308965, 18288842, 19048007, 19689979, 20446883, 18952989, 16870214
19928926, 19835133, 21629064, 21526048, 19197175, 19180770, 20466628
19902195, 19931709, 20318889, 19013183, 19730508, 19012119, 19067244
20074391, 20356733, 14643995, 19512341, 19841800, 20331945, 19587324
19065677, 19547370, 19578350, 21225209, 19637186, 20397490, 18967382
19174430, 21241829, 19054077, 18674047, 20898997, 19708632, 19536415
21091431, 19289642, 20869721, 22168163, 19335438, 19258504, 20447445
17365043, 18856999, 19468347, 19869255, 20471920, 21373473, 21620471
16359751, 18990693, 17890099, 19769480, 19439759, 19272708, 18990023
19978542, 19329654, 20101006, 21300341, 20402832, 19873610, 20848335
23229229, 21744290, 21668627, 21517440, 13542050, 19304354, 19052488
20794034, 19291380, 21915719, 23260854, 18681056, 20952966, 19896336
19076343, 19561643, 18618122, 19990037, 20440930, 18456643, 19699191
19201867, 19487147, 18909599, 20831538, 19016730, 18250893, 20798891
18743542, 20347562, 16619249, 18354830, 22551446, 19777862, 19687159
21373076, 19174942, 20424899, 21188584, 19989009, 17414008, 20688221
21899588, 20441797, 19157754, 19058490, 19032777, 22815955, 19399918
18885870, 19434529, 21273804, 19018447, 21450666, 18893947, 18851894
16923858, 18417036, 20919320, 19022470, 19284031, 20474192, 20173897
22046677, 22062026, 19501299, 19385656, 20920911, 17274537, 20899461
21315084, 19440586, 16887946, 22374754, 17319928, 19606174, 20708701
18436647, 17655240, 19023822, 19124589, 19178851, 16439813, 19805359
19597583, 18499088, 19155797, 19050649, 19393542
Patch 21436941 : applied on Mon Aug 08 14:13:46 CST 2016
Unique Patch ID: 19245012
Patch description: "WLM Patch Set Update: 12.1.0.2.5 (21436941)"
Created on 13 Aug 2015, 04:00:40 hrs PST8PDT
Bugs fixed:
20075154, 20641027, 20548410, 19016964, 19582630
Patch level status of Cluster nodes :
Patching Level Nodes
-------------- -----
3696455212 dbtest3,dbtest4
--------------------------------------------------------------------------------
$ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 12.2.0.1.5
Copyright (c) 2016, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/12.1.0/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/12.1.0/db_1/oraInst.loc
OPatch version : 12.2.0.1.5
OUI version : 12.1.0.2.0
Log file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/opatch2016-08-08_17-11-12PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/12.1.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-08-08_17-11-12PM.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: dbtest4
ARU platform id: 226
ARU platform description:: Linux x86-64
Installed Top-level Products (1):
Oracle Database 12c 12.1.0.2.0
There are 1 products installed in this Oracle Home.
Interim patches (2) :
Patch 23054327 : applied on Mon Aug 08 14:13:14 CST 2016
Unique Patch ID: 20208671
Patch description: "OCW Patch Set Update : 12.1.0.2.160719 (23054327)"
Created on 16 Jul 2016, 06:57:02 hrs PST8PDT
Bugs fixed:
21339083, 19701617, 18589889, 20768643, 19139608, 19280860, 19061429
21453435, 19133945, 19341538, 19521169, 20011424, 18946768, 19135521
18604143, 19361757, 19187207, 19302350, 19627476, 19130141, 19530755
20568884, 20317221, 19699720, 20177779, 19620918, 19168690, 19266658
18899171, 19244316, 19653795, 18330979, 19027351, 18634372, 19471722
21227730, 18707416, 19536337, 19184188, 19131709, 21113068, 20235486
19925992, 20160490, 20006646, 20995001, 18991776, 18439295, 15922206
21131037, 19380733, 21245437, 18943696, 20552947, 19591984, 19550195
19163425, 18135723, 20014326, 19524857, 18849021, 18890943, 18861196
19154753, 17940721, 18524834, 18748932, 18835283, 19522313, 19184765
19499021, 21639478, 19046190, 20923930, 14851828, 20028666, 19051385
19050688, 19682695, 19831611, 20598625, 19226141, 21607972, 19053891
18871287, 18998228, 18922918, 18980002, 21087799, 18956780, 19683886
19325604, 19682778, 23757020, 19026993, 18777835, 20110156, 17338864
21269977, 18261648, 18362971, 19558324, 22651583, 18945906, 19513650
20185476, 18952577, 19702758, 18882642, 19478119, 19414274, 17447588
19262534, 20752167, 19147513, 21242118, 19514085, 19473088, 20758997
19178517, 18729269, 19529729, 19659885, 19455563, 19319904, 20877072
18703978, 18536826, 20340620, 19700256, 19703246, 19292605, 20467806
22264951, 19192901, 21527118, 20920711, 20660273, 20011635, 17592037
22989069, 19479503, 19147751, 19029647, 19179158, 22302421, 18901356
19140712, 20012766, 21232394, 18964974, 22162062, 18835366, 19184276
19013789, 19207286, 20001507, 20510208, 18950232, 22583325, 19259765
19148791, 19680763, 20079414, 19556820, 16505171, 22135419, 19449737
18962892, 21646169, 19187515, 19513888, 19230771, 14661880, 21519340
20218012, 21222147, 20795241, 19453778, 19853036, 19551830, 19068333
21616278, 18843572, 18520351, 18945435, 19185148, 19232454, 20775015
21220597, 18541110, 19319192, 18834955, 19204743, 19178629, 20839581
19304104, 21694237, 19140891, 18747335, 19284357, 20676340, 19270660
19457575, 20725084, 21297657, 19021575, 19069755, 18715884, 18798573
19584688, 19018001, 19812592, 19325701, 19270956, 19292272, 21967791
20877003, 21794779, 18700893, 19222693, 19662663, 21276514, 18406774
19684131, 20607821, 19010177, 21082737, 19272663, 18910576, 18907170
21694632, 19426384, 9372680, 20115586, 20883009, 19700294, 19164099
20289828, 19331454, 18283792, 20278216, 20827053, 19155350, 20119857
19703199, 22456393, 20588164, 18955644, 20991879, 18508710, 19908346
18798432, 19146822, 19589221, 21123424, 18952857, 19471836, 19537762
20936562, 21152052, 16286734, 18750781, 20669114, 18762843, 18945249
19045143, 19146980, 22483804, 19184799, 19205086, 19601003, 20099624
19351363, 21378016, 20091753, 18862203, 19281106, 19537547, 19031737
19079087, 19148367, 18968981, 19150517, 20231741, 19954372, 19217019
18730096, 18235274, 18975620, 19205617, 19513351, 18843054, 19150313
20219458, 18708349, 19332386, 18953639, 19067804, 21423055, 21259359
19371270, 19203996, 19054979, 19209951, 19318983, 18747382, 20038431
19154673, 18752378, 22905714, 19150088, 19370846, 19013444, 19234177
21053036, 18998379, 20157569, 21357522, 18999857, 19273577, 19075747
19367276, 19632437, 18990354, 19288396, 19874047, 19612597, 19557558
20620581, 19427050, 19127078, 18910443, 20900588, 22088198, 20053557
20033787, 19315567, 19444471, 19148982, 20953798, 18290252, 18813323
19915945, 19777496, 19500293, 20730170, 18643483, 19277814, 19134098
18523468, 20562133, 19071526, 21420753, 18965694, 19226858, 18850051
20433932, 19602208, 19591356, 22884308, 20061168, 18417590, 19370739
18920408, 20822591, 18636884, 19609388, 20136892, 18776786, 18989446
22289350, 19148793, 19043795, 19585454, 20746507, 18260170, 18317489
19955755, 18919682, 19059053, 19807548, 19124972, 18678829, 19147509
18849896, 19617592, 18910748, 18953878, 19273758, 19319357, 19076165
18999195, 19498411, 19704993, 18759724, 21294273, 19459023, 20634511
21474380, 19066844, 21484367, 20276459, 17208793, 19234907, 20290467
13843841, 19538714, 19649640, 19383028, 19062675, 21924910, 19513969
22195657, 18859710, 20862812, 19504641, 19341481, 18304090, 20293730
19986391, 19343245, 19314048, 18834934, 19473851, 19241655, 19458082
18242738, 19470791, 18894342, 20649573, 18372060, 19522067, 18953889
18827679, 19259290, 19023430, 19140711, 19045388, 20186278, 19241857
19522571, 19076778, 18875012, 19709663, 18861564, 19066699, 19273760
19225265, 15885689, 20853464, 18819158, 21696068, 19068003, 18937186
20267877, 19049721, 21394146, 19916737, 19368917, 22393909, 21255373
19635215, 18868829, 19613533, 20579351, 20408163, 20350915, 21327402
21057239, 22024217, 20783416, 19315522, 19141785, 23101338, 19163887
19885321, 19820247, 18715868, 18852058, 20363708, 19538241, 19804032
Patch 23054246 : applied on Mon Aug 08 14:11:40 CST 2016
Unique Patch ID: 20213895
Patch description: "Database Patch Set Update : 12.1.0.2.160719 (23054246)"
Created on 5 Jul 2016, 07:07:59 hrs PST8PDT
Sub-patch 22291127; "Database Patch Set Update : 12.1.0.2.160419 (22291127)"
Sub-patch 21948354; "Database Patch Set Update : 12.1.0.2.160119 (21948354)"
Sub-patch 21359755; "Database Patch Set Update : 12.1.0.2.5 (21359755)"
Sub-patch 20831110; "Database Patch Set Update : 12.1.0.2.4 (20831110)"
Sub-patch 20299023; "Database Patch Set Update : 12.1.0.2.3 (20299023)"
Sub-patch 19769480; "Database Patch Set Update : 12.1.0.2.2 (19769480)"
Bugs fixed:
19189525, 21847223, 21099555, 21649497, 19075256, 19141838, 22762046
22075064, 20117253, 19865345, 19791273, 18845653, 19280225, 19248799
19243521, 20951038, 18988834, 21756699, 21281532, 19238590, 21184223
18921743, 20245930, 18799063, 19134173, 20373598, 19571367, 20476175
20925795, 19018206, 20509482, 20711718, 20387265, 20588502, 19149990
21263635, 18849537, 18886413, 17551063, 22507210, 19183343, 19366375
19703301, 21917884, 19001390, 18202441, 19189317, 20267166, 19644859
19390567, 19358317, 19279273, 19706965, 18549238, 16863642, 19068970
22528741, 18797519, 20825533, 19619732, 18607546, 20348653, 19649152
19670108, 18940497, 18948177, 19315691, 19676905, 18964978, 19176326
20165574, 19035573, 20413820, 17867700, 20558005, 19176223, 19532017
20904530, 20134339, 19450314, 19074147, 22353346, 20868862, 18411216
22507234, 20361671, 20425790, 18966843, 20009833, 22366558, 21329301
20294666, 18191823, 19333670, 19195895, 19371175, 19307662, 19154375
20043616, 20124446, 18914624, 19468991, 19883092, 21291274, 19382851
19520602, 19174521, 21875360, 19676012, 19326908, 19658708, 19591608
19402853, 20093776, 20618595, 21787056, 22380919, 21246723, 17835294
19721304, 19068610, 19791377, 21665897, 22178855, 22173980, 20048359
20746251, 19143550, 20898391, 19185876, 19627012, 20281121, 19577410
22092979, 19001359, 14283239, 19518079, 18610915, 19490948, 17532734
18674024, 18306996, 19309466, 19081128, 19524158, 19915271, 20122715
21188532, 18791688, 20284155, 20890311, 21442094, 20596234, 18973548
21296029, 19303936, 19597439, 20936905, 20235511, 21220620, 20880215
18964939, 21756677, 19888853, 19534363, 19430401, 19354335, 19044962
19639483, 22296366, 22353199, 21153266, 19409212, 19879746, 20657441
19684504, 20528052, 19024808, 20977794, 20378086, 18799993, 21756661
21260431, 18740837, 22923409, 19028800, 20877664, 20228093, 20879889
19065556, 19723336, 19077215, 19604659, 21421886, 19524384, 17722075
19308965, 18288842, 19048007, 19689979, 20446883, 18952989, 16870214
19928926, 19835133, 21629064, 21526048, 19197175, 19180770, 20466628
19902195, 19931709, 20318889, 19013183, 19730508, 19012119, 19067244
20074391, 20356733, 14643995, 19512341, 19841800, 20331945, 19587324
19065677, 19547370, 19578350, 21225209, 19637186, 20397490, 18967382
19174430, 21241829, 19054077, 18674047, 20898997, 19708632, 19536415
21091431, 19289642, 20869721, 22168163, 19335438, 19258504, 20447445
17365043, 18856999, 19468347, 19869255, 20471920, 21373473, 21620471
16359751, 18990693, 17890099, 19769480, 19439759, 19272708, 18990023
19978542, 19329654, 20101006, 21300341, 20402832, 19873610, 20848335
23229229, 21744290, 21668627, 21517440, 13542050, 19304354, 19052488
20794034, 19291380, 21915719, 23260854, 18681056, 20952966, 19896336
19076343, 19561643, 18618122, 19990037, 20440930, 18456643, 19699191
19201867, 19487147, 18909599, 20831538, 19016730, 18250893, 20798891
18743542, 20347562, 16619249, 18354830, 22551446, 19777862, 19687159
21373076, 19174942, 20424899, 21188584, 19989009, 17414008, 20688221
21899588, 20441797, 19157754, 19058490, 19032777, 22815955, 19399918
18885870, 19434529, 21273804, 19018447, 21450666, 18893947, 18851894
16923858, 18417036, 20919320, 19022470, 19284031, 20474192, 20173897
22046677, 22062026, 19501299, 19385656, 20920911, 17274537, 20899461
21315084, 19440586, 16887946, 22374754, 17319928, 19606174, 20708701
18436647, 17655240, 19023822, 19124589, 19178851, 16439813, 19805359
19597583, 18499088, 19155797, 19050649, 19393542
Rac system comprising of multiple nodes
Local node = dbtest4
Remote node = dbtest3
--------------------------------------------------------------------------------
OPatch succeeded.
该PSU更新过程步骤参照GI PSU补丁包read me文档执行。
12.1.0.2 RAC安装GI+DB最新PSU
发表回复