oracle升级包安装,ORACLE在线安装小补丁

ORACLE11.2.0.2在线安装小补丁

在补丁中的README文件中显示可以在线安装：

=========================================================================

Interim Patch for Base Bug: 9746210

=========================================================================

Date: Wed Dec8 18:03:13 2010

-------------------------------------------------------------------------

Platform. Patch for: Linux-x86-64

Product Patched: ORACLE DATABASE

Product Version #: 11.2.0.2.0

RAC Rolling Installable: YES

Online Installable: YES

Data Guard Rolling Installable : YES

1.进入补丁目录

[oracle@localhost ~]$ cd /oracle/9746210/

2.使用opatch命令在线安装补丁

[oracle@localhost 9746210]$ /oracle/product/11.2.0/OPatch/opatch apply online -c

onnectString xuhm:sys:oracle

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Copyright (c) 2009, Oracle Corporation.All rights reserved.

Oracle Home: /oracle/product/11.2.0

Central Inventory : /oracle/oraInventory

from: /etc/oraInst.loc

OPatch version: 11.2.0.1.1

OUI version: 11.2.0.2.0

OUI location: /oracle/product/11.2.0/oui

Log file location : /oracle/product/11.2.0/cfgtoollogs/opatch/opatch2013-01-13_17-16-04PM.log

Patch history file: /oracle/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt

The patch should be applied/rolled back in '-all_nodes' mode only.

Converting the RAC mode to '-all_nodes' mode.

ApplySession applying interim patch '9746210' to OH '/oracle/product/11.2.0'

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Backing up files and inventory (not for auto-rollback) for the Oracle Home

Backing up files affected by the patch '9746210' for restore. This might take a while...

Backing up files affected by the patch '9746210' for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.2.0...

The patch will be installed on active database instances.

Installing and enabling the online patch 'bug9746210.pch', on database 'xuhm'.

ApplySession adding interim patch '9746210' to inventory

Verifying the update...

Inventory check OK: Patch ID 9746210 is registered in Oracle Home inventory with proper meta-data.

Files check OK: Files from Patch ID 9746210 are present in Oracle Home.

OPatch succeeded.

3.检查补丁是否已安装Bug: 9746210

[oracle@localhost OPatch]$ /oracle/product/11.2.0/OPatch/opatch lsinventory

Invoking OPatch 11.2.0.1.1

Oracle Interim Patch Installer version 11.2.0.1.1

Copyright (c) 2009, Oracle Corporation.All rights reserved.

Oracle Home: /oracle/product/11.2.0

Central Inventory : /oracle/oraInventory

from: /etc/oraInst.loc

OPatch version: 11.2.0.1.1

OUI version: 11.2.0.2.0

OUI location: /oracle/product/11.2.0/oui

Log file location : /oracle/product/11.2.0/cfgtoollogs/opatch/opatch2013-01-13_17-24-10PM.log

Patch history file: /oracle/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt

Lsinventory Output file location : /oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2013-01-13_17-24-10PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 11g11.2.0.2.0

There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch (online) 9746210: applied on Sun Jan 13 17:16:21 CST 2013

Unique Patch ID:13226248

Created on 8 Dec 2010, 18:09:58 hrs PST8PDT

Bugs fixed:

9746210

--------------------------------------------------------------------------------

OPatch succeeded.