标签归档:RAC

12.1.0.2 RAC安装GI+DB最新PSU

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文档执行。

闰秒对Oracle RAC的影响

1.什么是闰秒
闰秒是在协调世界时(UTC中增加或减少一秒,使它与平太阳时贴近所做调整。UTC,是透过广播作为民用时的官方时间基础,它使用非常精确的原子钟来维护。要保持UTC与平太阳时的一致性,偶尔需要调整,也就是“跳个”1秒来做调整,就是所谓添加闰秒。闰秒时间现在是由国际地球自转和参考作坐标系统服务(IERS)来确认,而在1988年1月1日之前是由国际时间局(BIH)承担这项职责。
当要增加正闰秒时,这一秒是增加在第二天的00:00:00之前,效果是延缓UTC第二天的开始。当天23:59:59的下一秒被记为23:59:60,然后才是第二天的00:00:00。如果是负闰秒的话,23:59:58的下一秒就是第二天的00:00:00了,但目前还没有负闰秒调整的需求。需要时的日长度必须低于1750-1892年的平均日长度,才会累积足够调整1秒所需要的时间。除了每天4毫秒的波动外,日长度自1700年以来都保持一样[1]。然而,从历史上的日食观测则显示,自公元前700年以来,每个世纪的日长度大约增加1.7毫秒[2]。(来自维基百科)

2.闰秒的出现时间

3.闰秒的影响
从当前所了解的参考资料信息来看,闰秒主要会对Linux和Solaris平台系统存在影响,其主要影响是因为使用NTP的缘故,可能会导致OS CPU使用率100%。对于Oracle Database影响,则主要可能会导致RAC节点重启,EM OMS或Agent所导致的OS CPU使用100%,以及因为执行与时间戳数据类型相关的SQL而导致的ORA-01852错误。
3.1对于Linux影响
内核版本大于2.6.22的都受影响,详见:
http://www-01.ibm.com/support/docview.wss?uid=swg21602521
主要是可能出现CPU使用100%的情况,详见Leap Second Hang – CPU Can Be Seen at 100% (文档 ID 1472421.1),根据该文档描述,主要影响是Linux 4.4 – Linux 6.2的中间版本。该情况所涉及的OS环境版本范围:
Oracle VM – Version 2.1.1 to 3.1.1 [Release OVM211 to OVM31]
Linux OS – Version Oracle Linux 4.4 to Oracle Linux 6.2 with Unbreakable Enterprise Kernel [2.6.39] [Release OL4U4 to OL6U2]
Information in this document applies to any platform.
当ntpd调用adjtimex(2)告知kernel插入a leap second所导致livelock而引发的bug
 解决办法:
# /etc/init.d/ntpd stop
#  date -s “`date`”    (reset the system clock)
# /etc/init.d/ntpd start
Or Reboot the Server.
3.2对于Solaris影响
影响Solaris 8、9、10等几个版本,最新的Solaris 11不受影响,解决办法与3.1类似,重启NTP或系统。
3.3闰秒对Oracle的影响
1)RAC集群节点重启
该情况所涉及的Oracle环境版本范围:
Oracle Server – Enterprise Edition – Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)
Sun Solaris SPARC (64-bit)Sun Solaris x86-64 (64-bit)
Oracle Clusterware and patchsets 10.2.0.1 – 11.1.0.7
Sun Solaris 5.8 – 5.10 adjusting time through NTP daemon (xntpd)
 解决办法:
(1)对于通用平台OS下NTP都应该使用NTP daemon with -x 参数选项,对于Solaris还要进行如下操作来避免集群node reboot:
Configure xntpd Solaris daemon running on the Oracle Clusterware cluster node to 
disable PLL mode and enable slewing

adding to the /etc/inet/ntp.conf file the two lines:  
                   slewalways yes  
                   disable pll  
To restart xntpd the commands are:  
Solaris 10:      svcadm restart ntp  
Solaris 8 and 9: /etc/init.d/xntpd stop ; /etc/init.d/xntpd start
这里还需要注意一点(针对Sun Solaris),如果无法保证NTP server和client时间同步,在重启集群或系统之前一定要先修改ntp.conf文件重启xntpd服务。
2)打Oracle Clusterware patch bundles or a recent MLR (i.e. MLR # 9 or higher) in order to resolve bugs 5015469 and 6022204补丁。针对Sun CR#6595936问题,可以修改cluster oprocd daemon进程的timeout margin>5s解决。
(2)ORA-01852错误
由于闰秒事件导致一分钟>60秒,此时如果恰好在数据库中执行插入带有时间戳的SQL语句时会报ORA-01852错误。
该情况所涉及的Oracle Database环境版本范围:
Oracle Database – Enterprise Edition – Version 8.1.7.4 and later
Oracle Database – Standard Edition – Version 8.1.7.4 and later
Information in this document applies to any platform.
出现该报错的原因是因为Oracle数据库无法存储大于59秒的日期时间戳数据
 解决办法:
创建varchar2数据类型表去存储闰秒的时间戳记录:

SQL> select * from v$version;
 
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
PL/SQL Release 11.2.0.2.0 - Production
CORE    11.2.0.2.0      Production
TNS for Linux: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
 
SQL> create table t_630(a number,b timestamp(8));
 
Table created.
 
SQL> insert into t_630 values(1,to_timestamp('2015-06-10 12:10:10.1','yyyy-mm-dd hh24:mi:ss.ff')); 
 
1 row created.
 
         A B
---------- ---------------------------------------------------------------------------
         1 10-JUN-15 12.10.10.10000000 PM
 
SQL> insert into t_630 values(2,to_timestamp('2015-06-30 23:59:60','yyyy-mm-dd hh24:mi:ss'));
insert into t_630 values(2,to_timestamp('2015-06-30 23:59:60','yyyy-mm-dd hh24:mi:ss'))
                                        *
ERROR at line 1:
ORA-01852: seconds must be between 0 and 59
对于此问题,Oracle建议使用varchar2数据类型来替代timestamp
SQL> drop table t_630 purge;
 
Table dropped.
 
SQL> create table t_630(a number,b varchar2(30));
 
Table created.
 
SQL> insert into t_630 values(1,'2015-06-10 12:10:10');
 
1 row created.
 
SQL> insert into t_630 values(2,'2015-06-30 23:59:60');
 
1 row created.
 
SQL> commit;
 
Commit complete.
 
SQL> select * from t_630;
 
         A B
---------- ------------------------------
         1 2015-06-10 12:10:10
         2 2015-06-30 23:59:60

3)Oracle EM agent或OMS过度Linux OS CPU
该情况所涉及的Oracle EM环境版本范围:
Enterprise Manager Base Platform – Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Enterprise Manager Base Platform – Version 11.1.0.1 to 11.1.0.1 [Release 11.1]
Enterprise Manager Base Platform – Version 12.1.0.1.0 and later
Linux x86
Linux x86-64
该情况在系统层面表现可能如下:
Check top on the system:
$ top – 09:38:24 up 354 days,  5:48,  4 users,  load average: 6.49, 6.34, 6.44
Tasks: 296 total,   4 running, 292 sleeping,   0 stopped,   0 zombie
Cpu(s): 97.2%us,  1.8%sy,  0.0%ni,  0.7%id,  0.1%wa,  0.1%hi,  0.2%si,  0.0%st
Mem:     15991M total,    15937M used,       53M free,      107M buffers
Swap:     8110M total,       72M used,     8038M free,    13614M cached
PID USER      PR    NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
22564 oracle    16   0 1400m 421m 109m S  353  2.6   2225:11 java      <<<<<<< Note: Java PID consuming 353%  CPU
7294 oracle     17   0 3096m 108m 104m S   22  0.7   0:02.61 oracle
Check for  the following message from dmesg:
$ dmesg | grep -i leap
[10703552.860274] Clock: inserting leap second 23:59:60 UTC
 解决办法:
该情况的解决办法与3.1类似,重启NTP或是系统。

4.总结
除了按照上述Oracle建义来应对闰秒事件所造成的结果,同时为了尽可能避免闰秒事件可能导致的影响,最好是在闰秒日调整之前半小时,先将数据库环境下NTP Server和Client时间同步,然后停止服务器NTP,当闰秒调整结束后再开启服务器NTP继续同步。

5.参考文档
Leap seconds (extra second in a year) and impact on the Oracle database. (文档 ID 730795.1)
Enterprise Manager Management Agent or OMS CPU Use Is Excessive near Leap Second Additions on Linux (文档 ID 1472651.1)
Leap Second on Oracle SuperCluster (文档 ID 1991954.1)
NTP leap second event causing Oracle Clusterware node reboot (文档 ID 759143.1)
leap seconds in Oracle Linux (文档 ID 2012659.1)
Insert leap seconds into a timestamp column fails with ORA-01852 (文档 ID 1553906.1)
Leap Second Time Adjustment (e.g. on June 30, 2015 at 23:59:59 UTC) and Its Impact on Exadata Database Machine (文档 ID 1986986.1)
ODA (Oracle Database Appliance): Leap Second adjustment impact (文档 ID 2015972.1)
Related questions with leap second on mysql (文档 ID 1450441.1)
http://www-01.ibm.com/support/docview.wss?uid=swg21602521