Liu_Maclean blogged about it:
http://www.oracledatabase12g.com ... patch-on-11gr2.html
You can query a patch to see if it's online patchable:
$ opatch query -is_online_patch 9974223
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version: 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2011-12-31_20-45-19PM.log
--------------------------------------------------------------------------------
Patch is an online patch: false
OPatch succeeded.
I think currently almost all patches are still offline (old, non-online) patches. But the technology is already there. The first time I heard of it was at an IBM AIX seminar where they showed hot patching of part of the AIX operating system. The concept is great and may not be that difficult to implement.
Yong Huang
本帖最后由 huanhuanlove 于 2012-2-27 10:55 编辑
RDBMS Online Patching Aka Hot Patching [ID 761111.1]非常详细
Currently Supported Platforms
Online patching is currently supported on these platforms/systems:
?HP-UX Itanium
?IBM AIX on POWER Systems (64-bit), in particular: AIX 6.1 + TL-02 + SP-01 onwards
?IBM: Linux on POWER Systems
?IBM: Linux on System z
?Linux Itanium
?Linux x86
?Linux x86-64
?Microsoft Windows (32-bit)
?Microsoft Windows x64 (64-bit)
?Oracle Solaris on SPARC (64-bit)
?Oracle Solaris on x86-64 (64-bit)
本帖最后由 Yong Huang 于 2012-2-27 09:01 编辑
> RDBMS Online Patching Aka Hot Patching [ID 761111.1]非常详细
Thank you. Document 761111.1 is a good one!
But this statement:
"Online patches should be used when the patch needs to be applied urgently and a downtime cannot be scheduled. IMPORTANT: It is strongly recommended to rollback all online patches and replace them with regular (offline) patches on next instance shutdown"
makes me feel that online patching is not as useful as I thought.
Yong Huang