ITPub博客

首页 > 数据库 > Oracle > Oracle 11GR2(11.0.2.4.0) Combo OJVM PSU+GI PSU (11.2.0.4.180116)打补丁

Oracle 11GR2(11.0.2.4.0) Combo OJVM PSU+GI PSU (11.2.0.4.180116)打补丁

原创 Oracle 作者:jieyu119 时间:2018-01-31 17:20:25 0 删除 编辑
Patch 27282436 Combo OJVM PSU 11.2.0.4.180116 and GI PSU 11.2.0.4.180116

<一> Patch 27107360  GI PSU
     Oracle Grid Infrastructure Patch Set Update 11.2.0.4.180116 (Includes Database PSU 11.2.0.4.180116)

1. RAC生产库打补丁前,请做好DB RMAN全库备份.

2. oracle与grid家目录备份,可做恢复.

3. OPatch Utility Information
    You must use the OPatch utility version 11.2.0.3.6 or later to apply this patch. 
    oracle与grid下OPatch Utility更新.

3.1. oracle用户下OPatch Utility更新

节点1:

[oracle@newrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1
[oracle@newrac1 db_1]$ mv OPatch/ OPatch_bak20180130
[oracle@newrac1 patch]$ unzip p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
[oracle@newrac1 db_1]$ chmod 755 OPatch
[oracle@newrac1 db_1]$ cd OPatch
[oracle@newrac1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.

节点2:

[oracle@newrac2 ~]$ cd /u01/app/oracle/product/11.2.0/db_1
[oracle@newrac2 db_1]$ mv OPatch/ OPatch_bak20180130
[oracle@newrac2 patch]$ unzip p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0/db_1
[oracle@newrac2 db_1]$ chmod 755 OPatch 
[oracle@newrac2 db_1]$ cd OPatch
[oracle@newrac2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.


3.2. grid用户下OPatch Utility更新

节点1:

[root@newrac1 ~]# cd /u01/app/11.2.0/grid
[root@newrac1 grid]# mv OPatch/ OPatch_bak20180130
[grid@newrac1 patch]$ unzip p6880880_112000_Linux-x86-64.zip 
[grid@newrac1 patch]$ echo $ORACLE_HOME 
/u01/app/11.2.0/grid
[root@newrac1 patch]# mv OPatch/ /u01/app/11.2.0/grid
[grid@newrac1 grid]$ chmod 755 OPatch
[grid@newrac1 grid]$ cd OPatch
[grid@newrac1 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.

节点2:

[root@newrac2 ~]# cd /u01/app/11.2.0/grid
[root@newrac2 grid]# mv OPatch/ OPatch_bak20180130
[grid@newrac2 patch]$ unzip p6880880_112000_Linux-x86-64.zip 
[root@newrac2 patch]# mv OPatch/ /u01/app/11.2.0/grid
[grid@newrac2 grid]$ chmod 755 OPatch
[grid@newrac2 grid]$ cd OPatch
[grid@newrac2 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.17
OPatch succeeded.

4. OCM Configuration

节点1:

[grid@newrac1 ~]$ cd /u01/app/11.2.0/grid/OPatch/ocm/bin/
[grid@newrac1 bin]$ ll -athr
总用量 20K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp

[grid@newrac1 bin]$ ./emocmrsp 
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates.  All rights reserved.
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 (ocm.rsp) was successfully created.
[grid@newrac1 bin]$ 
[grid@newrac1 bin]$ ll -athr
总用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月  31 11:29 .
-rw-r--r-- 1 grid oinstall  621 1月  31 11:29 ocm.rsp
[grid@newrac1 bin]$ 
[grid@newrac1 bin]$ chmod 775 ocm.rsp 
[grid@newrac1 bin]$ 
[grid@newrac1 bin]$ ll -athr
总用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月  31 11:29 .
-rwxrwxr-x 1 grid oinstall  621 1月  31 11:29 ocm.rsp

节点2:

[grid@newrac2 ~]$ cd /u01/app/11.2.0/grid/OPatch/ocm/bin/
[grid@newrac2 bin]$ ./emocmrsp 
OCM Installation Response Generator 10.3.7.0.0 - Production
Copyright (c) 2005, 2012, Oracle and/or its affiliates.  All rights reserved.
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 (ocm.rsp) was successfully created.
[grid@newrac2 bin]$ 
[grid@newrac2 bin]$ ll -athr
总用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月  31 11:40 .
-rw-r--r-- 1 grid oinstall  621 1月  31 11:40 ocm.rsp
[grid@newrac2 bin]$ 
[grid@newrac2 bin]$ chmod 775 ocm.rsp 
[grid@newrac2 bin]$ ll -athr
总用量 24K
-rwxr-x--- 1 grid oinstall 8.9K 11月 27 2009 emocmrsp
drwxr-x--- 5 grid oinstall 4.0K 10月 11 02:16 ..
drwxr-x--- 2 grid oinstall 4.0K 1月  31 11:40 .
-rwxrwxr-x 1 grid oinstall  621 1月  31 11:40 ocm.rsp

5. Validation of Oracle Inventory

节点1:

grid用户下:

$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid

[grid@newrac1 ~]$ 
[grid@newrac1 ~]$ cd /u01/app/11.2.0/grid/OPatch
[grid@newrac1 OPatch]$ 
[grid@newrac1 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid

Oracle 中间补丁程序安装程序版本 11.2.0.3.17
版权所有 (c) 2018, Oracle Corporation。保留所有权利。
Oracle Home       : /u01/app/11.2.0/grid
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.17
OUI version       : 11.2.0.4.0
Log file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch2018-01-31_11-42-02上午_1.log
Lsinventory Output file location : /u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2018-01-31_11-42-02上午.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: newrac1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Grid Infrastructure 11g                                       11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
已安装的产品 (89):
Agent Required Support Files                                         10.2.0.4.5
Assistant Common Files                                               11.2.0.4.0
Automatic Storage Management Assistant                               11.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.4.0
Character Set Migration Utility                                      11.2.0.4.0
Cluster Ready Services Files                                         11.2.0.4.0
Cluster Verification Utility Common Files                            11.2.0.4.0
Cluster Verification Utility Files                                   11.2.0.4.0
Database SQL Scripts                                                 11.2.0.4.0
Deinstallation Tool                                                  11.2.0.4.0
Enterprise Manager Common Core Files                                 10.2.0.4.5
Enterprise Manager Common Files                                      10.2.0.4.5
Enterprise Manager plugin Common Files                               11.2.0.4.0
Expat libraries                                                       2.0.1.0.1
HAS Common Files                                                     11.2.0.4.0
HAS Files for DB                                                     11.2.0.4.0
Installation Common Files                                            11.2.0.4.0
Installation Plugin Files                                            11.2.0.4.0
Installer SDK Component                                              11.2.0.4.0
Java Development Kit                                                1.5.0.51.10
LDAP Required Support Files                                          11.2.0.4.0
OLAP SQL Scripts                                                     11.2.0.4.0
Oracle Advanced Security                                             11.2.0.4.0
Oracle Clusterware RDBMS Files                                       11.2.0.4.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           11.2.0.4.0
Oracle Core Required Support Files                                   11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Multimedia Files                                 11.2.0.4.0
Oracle Database Deconfiguration                                      11.2.0.4.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            11.2.0.4.0
Oracle DBCA Deconfiguration                                          11.2.0.4.0
Oracle Extended Windowing Toolkit                                    3.4.47.0.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Grid Infrastructure 11g                                       11.2.0.4.0
Oracle Help For Java                                                  4.2.9.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle Internet Directory Client                                     11.2.0.4.0
Oracle Java Client                                                   11.2.0.4.0
Oracle JDBC/OCI Instant Client                                       11.2.0.4.0
Oracle JDBC/THIN Interfaces                                          11.2.0.4.0
Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0
Oracle JVM                                                           11.2.0.4.0
Oracle LDAP administration                                           11.2.0.4.0
Oracle Locale Builder                                                11.2.0.4.0
Oracle Multimedia                                                    11.2.0.4.0
Oracle Multimedia Client Option                                      11.2.0.4.0
Oracle Multimedia Java Advanced Imaging                              11.2.0.4.0
Oracle Multimedia Locator                                            11.2.0.4.0
Oracle Multimedia Locator RDBMS Files                                11.2.0.4.0
Oracle Net                                                           11.2.0.4.0
Oracle Net Listener                                                  11.2.0.4.0
Oracle Net Required Support Files                                    11.2.0.4.0
Oracle Netca Client                                                  11.2.0.4.0
Oracle Notification Service                                          11.2.0.3.0
Oracle Notification Service (eONS)                                   11.2.0.4.0
Oracle One-Off Patch Installer                                       11.2.0.3.4
Oracle Quality of Service Management (Client)                        11.2.0.4.0
Oracle Quality of Service Management (Server)                        11.2.0.4.0
Oracle RAC Deconfiguration                                           11.2.0.4.0
Oracle RAC Required Support Files-HAS                                11.2.0.4.0
Oracle Recovery Manager                                              11.2.0.4.0
Oracle Security Developer Tools                                      11.2.0.4.0
Oracle Text Required Support Files                                   11.2.0.4.0
Oracle Universal Installer                                           11.2.0.4.0
Oracle USM Deconfiguration                                           11.2.0.4.0
Oracle Wallet Manager                                                11.2.0.4.0
Parser Generator Required Support Files                              11.2.0.4.0
Perl Interpreter                                                     5.10.0.0.2
Perl Modules                                                         5.10.0.0.1
PL/SQL                                                               11.2.0.4.0
PL/SQL Embedded Gateway                                              11.2.0.4.0
Platform Required Support Files                                      11.2.0.4.0
Precompiler Required Support Files                                   11.2.0.4.0
RDBMS Required Support Files                                         11.2.0.4.0
RDBMS Required Support Files for Instant Client                      11.2.0.4.0
RDBMS Required Support Files Runtime                                 11.2.0.4.0
Required Support Files                                               11.2.0.4.0
Secure Socket Layer                                                  11.2.0.4.0
SQL*Plus                                                             11.2.0.4.0
SQL*Plus Files for Instant Client                                    11.2.0.4.0
SQL*Plus Required Support Files                                      11.2.0.4.0
SSL Required Support Files for InstantClient                         11.2.0.4.0
Universal Storage Manager Files                                      11.2.0.4.0
XDK Required Support Files                                           11.2.0.4.0
XML Parser for Java                                                  11.2.0.4.0
此 Oracle 主目录中已安装 89 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
--------------------------------------------------------------------------------

OPatch succeeded.


oracle用户下:

[oracle@newrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@newrac1 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/db_1

Oracle 中间补丁程序安装程序版本 11.2.0.3.17
版权所有 (c) 2018, Oracle Corporation。保留所有权利。
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.17
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-31_11-45-16上午_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2018-01-31_11-45-16上午.txt
--------------------------------------------------------------------------------
Local Machine Information::
Hostname: newrac1
ARU platform id: 226
ARU platform description:: Linux x86-64
已安装的顶级产品 (1):
Oracle Database 11g                                                  11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。
已安装的产品 (136):
Agent Required Support Files                                         10.2.0.4.5
Assistant Common Files                                               11.2.0.4.0
Bali Share                                                           1.1.18.0.0
Buildtools Common Files                                              11.2.0.4.0
Character Set Migration Utility                                      11.2.0.4.0
Cluster Verification Utility Common Files                            11.2.0.4.0
Database Configuration and Upgrade Assistants                        11.2.0.4.0
Database SQL Scripts                                                 11.2.0.4.0
Database Workspace Manager                                           11.2.0.4.0
Deinstallation Tool                                                  11.2.0.4.0
Enterprise Edition Options                                           11.2.0.4.0
Enterprise Manager Agent                                             10.2.0.4.5
Enterprise Manager Agent Core Files                                  10.2.0.4.5
Enterprise Manager Common Core Files                                 10.2.0.4.5
Enterprise Manager Common Files                                      10.2.0.4.5
Enterprise Manager Database Plugin -- Agent Support                  11.2.0.4.0
Enterprise Manager Database Plugin -- Repository Support             11.2.0.4.0
Enterprise Manager Grid Control Core Files                           10.2.0.4.5
Enterprise Manager plugin Common Files                               11.2.0.4.0
Enterprise Manager Repository Core Files                             10.2.0.4.5
Exadata Storage Server                                               11.2.0.1.0
Expat libraries                                                       2.0.1.0.1
Generic Connectivity Common Files                                    11.2.0.4.0
HAS Common Files                                                     11.2.0.4.0
HAS Files for DB                                                     11.2.0.4.0
Installation Common Files                                            11.2.0.4.0
Installation Plugin Files                                            11.2.0.4.0
Installer SDK Component                                              11.2.0.4.0
JAccelerator (COMPANION)                                             11.2.0.4.0
Java Development Kit                                                1.5.0.51.10
LDAP Required Support Files                                          11.2.0.4.0
OLAP SQL Scripts                                                     11.2.0.4.0
Oracle 11g Warehouse Builder Required Files                          11.2.0.4.0
Oracle Advanced Security                                             11.2.0.4.0
Oracle Application Express                                           11.2.0.4.0
Oracle Call Interface (OCI)                                          11.2.0.4.0
Oracle Clusterware RDBMS Files                                       11.2.0.4.0
Oracle Code Editor                                                   1.2.1.0.0I
Oracle Configuration Manager                                         10.3.8.1.0
Oracle Configuration Manager Client                                  10.3.2.1.0
Oracle Configuration Manager Deconfiguration                         10.3.1.0.0
Oracle Containers for Java                                           11.2.0.4.0
Oracle Core Required Support Files                                   11.2.0.4.0
Oracle Data Mining RDBMS Files                                       11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g                                                  11.2.0.4.0
Oracle Database 11g Multimedia Files                                 11.2.0.4.0
Oracle Database Deconfiguration                                      11.2.0.4.0
Oracle Database Gateway for ODBC                                     11.2.0.4.0
Oracle Database User Interface                                       2.2.13.0.0
Oracle Database Utilities                                            11.2.0.4.0
Oracle Database Vault J2EE Application                               11.2.0.4.0
Oracle Database Vault option                                         11.2.0.4.0
Oracle DBCA Deconfiguration                                          11.2.0.4.0
Oracle Display Fonts                                                  9.0.2.0.0
Oracle Enterprise Manager Console DB                                 11.2.0.4.0
Oracle Extended Windowing Toolkit                                    3.4.47.0.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Globalization Support                                         11.2.0.4.0
Oracle Help For Java                                                  4.2.9.0.0
Oracle Help for the  Web                                             2.0.14.0.0
Oracle Ice Browser                                                    5.2.3.6.0
Oracle Internet Directory Client                                     11.2.0.4.0
Oracle Java Client                                                   11.2.0.4.0
Oracle JDBC Server Support Package                                   11.2.0.4.0
Oracle JDBC/OCI Instant Client                                       11.2.0.4.0
Oracle JDBC/THIN Interfaces                                          11.2.0.4.0
Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0
Oracle JVM                                                           11.2.0.4.0
Oracle Label Security                                                11.2.0.4.0
Oracle LDAP administration                                           11.2.0.4.0
Oracle Locale Builder                                                11.2.0.4.0
Oracle Message Gateway Common Files                                  11.2.0.4.0
Oracle Multimedia                                                    11.2.0.4.0
Oracle Multimedia Annotator                                          11.2.0.4.0
Oracle Multimedia Client Option                                      11.2.0.4.0
Oracle Multimedia Java Advanced Imaging                              11.2.0.4.0
Oracle Multimedia Locator                                            11.2.0.4.0
Oracle Multimedia Locator RDBMS Files                                11.2.0.4.0
Oracle Net                                                           11.2.0.4.0
Oracle Net Listener                                                  11.2.0.4.0
Oracle Net Required Support Files                                    11.2.0.4.0
Oracle Net Services                                                  11.2.0.4.0
Oracle Netca Client                                                  11.2.0.4.0
Oracle Notification Service                                          11.2.0.3.0
Oracle Notification Service (eONS)                                   11.2.0.4.0
Oracle ODBC Driver                                                   11.2.0.4.0
Oracle ODBC Driverfor Instant Client                                 11.2.0.4.0
Oracle OLAP                                                          11.2.0.4.0
Oracle OLAP API                                                      11.2.0.4.0
Oracle OLAP RDBMS Files                                              11.2.0.4.0
Oracle One-Off Patch Installer                                       11.2.0.3.4
Oracle Partitioning                                                  11.2.0.4.0
Oracle Programmer                                                    11.2.0.4.0
Oracle Quality of Service Management (Client)                        11.2.0.4.0
Oracle RAC Deconfiguration                                           11.2.0.4.0
Oracle RAC Required Support Files-HAS                                11.2.0.4.0
Oracle Real Application Testing                                      11.2.0.4.0
Oracle Recovery Manager                                              11.2.0.4.0
Oracle Security Developer Tools                                      11.2.0.4.0
Oracle Spatial                                                       11.2.0.4.0
Oracle SQL Developer                                                 11.2.0.4.0
Oracle Starter Database                                              11.2.0.4.0
Oracle Text                                                          11.2.0.4.0
Oracle Text Required Support Files                                   11.2.0.4.0
Oracle UIX                                                           2.2.24.6.0
Oracle Universal Connection Pool                                     11.2.0.4.0
Oracle Universal Installer                                           11.2.0.4.0
Oracle USM Deconfiguration                                           11.2.0.4.0
Oracle Wallet Manager                                                11.2.0.4.0
Oracle XML Development Kit                                           11.2.0.4.0
Oracle XML Query                                                     11.2.0.4.0
Parser Generator Required Support Files                              11.2.0.4.0
Perl Interpreter                                                     5.10.0.0.2
Perl Modules                                                         5.10.0.0.1
PL/SQL                                                               11.2.0.4.0
PL/SQL Embedded Gateway                                              11.2.0.4.0
Platform Required Support Files                                      11.2.0.4.0
Precompiler Common Files                                             11.2.0.4.0
Precompiler Required Support Files                                   11.2.0.4.0
Provisioning Advisor Framework                                       10.2.0.4.3
RDBMS Required Support Files                                         11.2.0.4.0
RDBMS Required Support Files for Instant Client                      11.2.0.4.0
RDBMS Required Support Files Runtime                                 11.2.0.4.0
regexp                                                                2.1.9.0.0
Required Support Files                                               11.2.0.4.0
Sample Schema Data                                                   11.2.0.4.0
Secure Socket Layer                                                  11.2.0.4.0
SQL*Plus                                                             11.2.0.4.0
SQL*Plus Files for Instant Client                                    11.2.0.4.0
SQL*Plus Required Support Files                                      11.2.0.4.0
SQLJ Runtime                                                         11.2.0.4.0
SSL Required Support Files for InstantClient                         11.2.0.4.0
XDK Required Support Files                                           11.2.0.4.0
XML Parser for Java                                                  11.2.0.4.0
XML Parser for Oracle JVM                                            11.2.0.4.0
此 Oracle 主目录中已安装 136 个产品。
此 Oracle 主目录中未安装任何中间补丁程序。
--------------------------------------------------------------------------------

OPatch succeeded.


节点2:

grid用户

[grid@newrac2 ~]$ cd /u01/app/11.2.0/grid/OPatch
[grid@newrac2 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/11.2.0/grid


oracle用户

[oracle@newrac2 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/OPatch
[oracle@newrac2 OPatch]$ ./opatch lsinventory -detail -oh /u01/app/oracle/product/11.2.0/db_1


6. Unzip the patch as grid home owner

节点1:

[grid@newrac1 patch]$ unzip p27282436_112040_Linux-x86-64.zip 

节点2:

[grid@newrac2 patch]$ unzip p27282436_112040_Linux-x86-64.zip 


7.  emctl stop dbconsole

8. OPatch auto for GI
   As root user, execute the following command on each node of the cluster:
   
节点1: root用户下

    8.1. 关闭打补丁节点的实例与监听

[oracle@newrac1 ~]$ srvctl stop instance -d newrac -n newrac1
[oracle@newrac1 ~]$ 
[oracle@newrac1 ~]$ srvctl stop listener -n newrac1

ps -ef |grep ora 
kill oracle进程


   8.2. 查询当前系统LANG变量为中文
# echo $LANG 
en_US.UTF-8

设置系统变量为英文
# export LANG=en_US

oracle与grid用户环境变量先设置 
$ export LANG=en_US


   8.3. OPatch auto

[root@newrac1 ~]# echo $LANG 
zh_CN.UTF-8
[root@newrac1 ~]# 
[root@newrac1 ~]# export LANG=en_US

把LANG=en_US 变量加入grid与oracle  .bash_profile中
[root@newrac1 ~]# vim /home/grid/.bash_profile 
[root@newrac1 ~]# vim /home/oracle/.bash_profile

[root@newrac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360/ -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/install/patch/27282436 -patchn 27107360 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-01-31_14-39-30.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-01-31_14-39-30.report.log
2018-01-31 14:39:30: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch /u01/install/patch/27282436/27107360/26925576  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
patch /u01/install/patch/27282436/27107360/26609929/custom/server/26609929  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
Stopping CRS...
Stopped CRS successfully
patch /u01/install/patch/27282436/27107360/26925576  apply successful for home  /u01/app/11.2.0/grid 
patch /u01/install/patch/27282436/27107360/26609929  apply successful for home  /u01/app/11.2.0/grid 
patch /u01/install/patch/27282436/27107360/22502505  apply successful for home  /u01/app/11.2.0/grid 
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

节点2:

root@newrac2 ~]# export LANG=en_US
把LANG=en_US 变量加入grid与oracle  .bash_profile中
[root@newrac2 ~]# vim /home/grid/.bash_profile 
[root@newrac2 ~]# vim /home/oracle/.bash_profile

[root@newrac2 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp 
[root@newrac2 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp 
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/install/patch/27282436 -patchn 27107360 -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-01-31_17-47-28.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-01-31_17-47-28.report.log
2018-01-31 17:47:28: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully

patch /u01/install/patch/27282436/27107360/26925576  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
patch /u01/install/patch/27282436/27107360/26609929/custom/server/26609929  apply successful for home  /u01/app/oracle/product/11.2.0/db_1 
Stopping CRS...
Stopped CRS successfully
patch /u01/install/patch/27282436/27107360/26925576  apply successful for home  /u01/app/11.2.0/grid 
patch /u01/install/patch/27282436/27107360/26609929  apply successful for home  /u01/app/11.2.0/grid 
patch /u01/install/patch/27282436/27107360/22502505  apply successful for home  /u01/app/11.2.0/grid 
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.

9. Loading Modified SQL Files into the Database
      perform these steps on only one node.
 
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

dba_registry_history


cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql


Patch Deinstallation-
  如遇异常可按照如下步骤回滚

    As root user, execute the following command on each node of the cluster.

[root@newrac1 ~]# export LANG=en_US
[root@newrac1 ~]# /u01/app/11.2.0/grid/OPatch/opatch auto /u01/install/patch/27282436/27107360  -rollback -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /u01/install/patch/27282436 -patchn 27107360 -rollback -ocmrf /u01/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-01-31_15-39-27.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2018-01-31_15-39-27.report.log
2018-01-31 15:39:27: Starting Clusterware Patch Setup
Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully
patch 26925576  rollback successful for home /u01/app/oracle/product/11.2.0/db_1
patch 26609929  rollback successful for home /u01/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch 26925576  rollback successful for home /u01/app/11.2.0/grid
patch 26609929  rollback successful for home /u01/app/11.2.0/grid
patch 22502505  rollback successful for home /u01/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...
Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully

opatch auto succeeded.



<二>Patch 26925532 OJVM补丁
       Oracle JavaVM Component 11.2.0.4.180116 Database PSU
  
节点1:

[root@newrac1 27282436]# pwd
/u01/install/patch/27282436
[root@newrac1 27282436]# 
[root@newrac1 27282436]# ll -athr
总用量 44K
drwxr-xr-x 4 grid   oinstall 4.0K 1月  12 13:06 26925532
drwxr-xr-x 5 grid   oinstall 4.0K 1月  12 14:03 27107360
-rw-r--r-- 1 grid   oinstall   21 1月  12 14:09 README.txt
drwxr-xr-x 4 grid   oinstall 4.0K 1月  12 14:09 .
-rw-rw-r-- 1 grid   oinstall  21K 1月  23 15:15 README.html
drwxr-xr-x 3 grid   oinstall 4.0K 1月  31 13:18 ..   
[root@newrac1 27282436]# chown -R oracle:oinstall 26925532/
[root@newrac1 27282436]# ll -athr
总用量 44K
drwxr-xr-x 4 oracle oinstall 4.0K 1月  12 13:06 26925532
drwxr-xr-x 5 grid   oinstall 4.0K 1月  12 14:03 27107360   

节点2:

[root@newrac2 27282436]# pwd
/u01/install/patch/27282436
[root@newrac2 27282436]# 
[root@newrac2 27282436]# ll -athr
总用量 44K
drwxr-xr-x 4 grid   oinstall 4.0K 1月  12 13:06 26925532
drwxr-xr-x 5 grid   oinstall 4.0K 1月  12 14:03 27107360
-rw-r--r-- 1 grid   oinstall   21 1月  12 14:09 README.txt
drwxr-xr-x 4 grid   oinstall 4.0K 1月  12 14:09 .
-rw-rw-r-- 1 grid   oinstall  21K 1月  23 15:15 README.html
drwxr-xr-x 3 grid   oinstall 4.0K 1月  31 13:18 ..   
[root@newrac2 27282436]# chown -R oracle:oinstall 26925532/
[root@newrac2 27282436]# ll -athr
总用量 44K
drwxr-xr-x 4 oracle oinstall 4.0K 1月  12 13:06 26925532
drwxr-xr-x 5 grid   oinstall 4.0K 1月  12 14:03 27107360   
  
Prerequisites

1. Ensure that the following Oct2014 or greater to be already installed prior to installing this patch:
Database PSU 11.2.0.4.4 (Oct2014) (Patch number: 19121551)
Database SPU 11.2.0.4 (CPUOct2014)
Database patch for Exadata 11.2.0.4.12 (Oct2014)

2. You must use the OPatch utility version 11.2.0.3.5 or later to apply this patch.

3. Ensure that the $PATH definition has the following executables: make, ar, ld and nm

节点1:

[oracle@newrac1 ~]$ which make ar ld nm
/usr/bin/make
/usr/bin/ar
/usr/bin/ld
/usr/bin/nm

节点2:

[oracle@newrac2 ~]$ which make ar ld nm
/usr/bin/make
/usr/bin/ar
/usr/bin/ld
/usr/bin/nm

4. opatch lsinventory

5. verify conflict with this patch 26925532

每个节点上操作.

$ cd 26925532
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./


节点1:

[oracle@newrac1 ~]$ cd /u01/install/patch/27282436/26925532/
[oracle@newrac1 26925532]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.17
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-01-31_23-10-02PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.


节点2:

oracle@newrac2 ~]$ cd /u01/install/patch/27282436/26925532/ 
[oracle@newrac2 26925532]$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.17
Copyright (c) 2018, Oracle Corporation.  All rights reserved.
PREREQ session
Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.2.0.3.17
OUI version       : 11.2.0.4.0
Log file location : /u01/app/oracle/pr

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28569596/viewspace-2150716/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-04-12

  • 博文量
    30
  • 访问量
    157585