在线打一个oracle热补丁的例子

最新推荐文章于 2023-06-09 18:43:38 发布

weixin_34092455

最新推荐文章于 2023-06-09 18:43:38 发布

阅读量220

点赞数

文章标签：数据库 java ldap

原文链接：https://my.oschina.net/u/3761438/blog/1829689

版权

2019独角兽企业重金招聘Python工程师标准>>>

1.检查冲突

[oracle@oracleB 18034737]$ $ORACLE_HOME/O

Patch

/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

Oracle 中间补丁程序安装程序版本 11.2.0.3.4

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

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

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

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

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 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 De

configuration

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

SQL

J 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

转载于:https://my.oschina.net/u/3761438/blog/1829689

weixin_34092455

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
在线打一个oracle热补丁的例子

2019独角兽企业重金招聘Python工程师标准>>> ...
复制链接

扫一扫