重庆思庄Oracle、Redhat认证学习论坛

标题: 在线打一个oracle热补丁的例子 [打印本页]

作者: 郑全 时间: 2016-1-14 12:36
标题: 在线打一个oracle热补丁的例子
1.检查冲突

[oracle@oracleB 18034737]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle 中间补丁程序安装程序版本 11.2.0.3.4
版权所有 (c) 2012, Oracle Corporation。保留所有权利。
PREREQ session
Oracle Home    : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from          : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version    : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-01-14_12-32-11下午_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

2.打在线补丁

[oracle@oracleB 18034737]$ $ORACLE_HOME/OPatch/opatch apply online -connectString orcl
Oracle 中间补丁程序安装程序版本 11.2.0.3.4
版权所有 (c) 2012, Oracle Corporation。保留所有权利。

Oracle Home    : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from          : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version    : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/18034737_Jan_14_2016_12_33_31/apply2016-01-14_12-33-31下午_1.log

补丁程序只应在 '-all_nodes' 模式下应用/回退。
将 RAC 模式转换为 '-all_nodes' 模式。
Applying interim patch '18034737' to OH '/oracle/app/oracle/product/11.2.0/db_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...
正在为组件 oracle.rdbms, 11.2.0.4.0 打补丁...
正在数据库 'orcl' 上安装和启用联机补丁程序 'bug18034737.pch'。

Verifying the update...
Patch 18034737 successfully applied
Log file location: /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/18034737_Jan_14_2016_12_33_31/apply2016-01-14_12-33-31下午_1.log
OPatch succeeded.

3、检查在线补丁安装情况

[oracle@oracleB 18034737]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle 中间补丁程序安装程序版本 11.2.0.3.4
版权所有 (c) 2012, Oracle Corporation。保留所有权利。

Oracle Home    : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from          : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version    : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-01-14_12-34-11下午_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-01-14_12-34-11下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (1):
Oracle Database 11g                                                 11.2.0.4.0
此 Oracle 主目录中已安装 1 个产品。

中间补丁程序 (1) :
Patch (online) 18034737: applied on Thu Jan 14 12:33:37 CST 2016
Unique Patch ID:  17703617
Created on 5 Jun 2014, 20:41:01 hrs PST8PDT
Bugs fixed:
   18034737

--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@oracleB 18034737]$

4.安装位置

[oracle@oracleB 18034737]$ $ORACLE_HOME/OPatch/opatch lsinventory -details
Oracle 中间补丁程序安装程序版本 11.2.0.3.4
版权所有 (c) 2012, Oracle Corporation。保留所有权利。

Oracle Home    : /oracle/app/oracle/product/11.2.0/db_1
Central Inventory : /oracle/app/oraInventory
from          : /oracle/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version    : 11.2.0.4.0
Log file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2016-01-14_12-37-57下午_1.log
Lsinventory Output file location : /oracle/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2016-01-14_12-37-57下午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (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 个产品。

中间补丁程序 (1) :
Patch (online) 18034737: applied on Thu Jan 14 12:33:37 CST 2016
Unique Patch ID:  17703617
Created on 5 Jun 2014, 20:41:01 hrs PST8PDT
Bugs fixed:
   18034737
Files Touched:
   bug18034737.pch --> ORACLE_HOME/hpatch/bug18034737.pch
Instances Patched:
   orcl
Patch Location in Inventory:
   /oracle/app/oracle/product/11.2.0/db_1/inventory/oneoffs/18034737
Patch Location in Storage area:
   /oracle/app/oracle/product/11.2.0/db_1/.patch_storage/18034737_Jun_5_2014_20_41_01

--------------------------------------------------------------------------------
OPatch succeeded.

5、打了补丁后，会在alert文件中写入状态记录

[oracle@oracleB trace]$ tail -10 alert_orcl.log
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=::1)(PORT=26439))
WARNING: inbound connection timed out (ORA-3136)
Thu Jan 14 12:33:35 2016
Patch file bug18034737.pch is out of sync with oracle binary; performing fixup
Patch file bug18034737.pch has been synced with oracle binary
Patch bug18034737.pch Installed - Update #1
Patch bug18034737.pch Enabled - Update #2
Thu Jan 14 12:33:37 2016
Online patch bug18034737.pch has been installed
Online patch bug18034737.pch has been enabled

作者: 郑全 时间: 2017-4-28 11:14
打补丁的语法格式为:
opatch apply online -connectString <SID>:<USERNAME>:<PASSWORD>:

<USERNAME>:<PASSWORD> 之间是冒号(:),不是斜杠(/)

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)