Oracle 11.2.0.4在线（Online mode）打补丁14084247解决WRH$_ACTIVE_SESSION_HISTORY不会自动切割的问题
安装了Oracle Database Release 11.2.0.4之后，发现WRH$_ACTIVE_SESSION_HISTORY始终不会自动分割删除，
后来才发现需要应用补丁：14084247
The following are the bugs fixed by this patch: 14084247: STBH: ORA-01555 DUE TO WRH$_ACTIVE_SESSION_HISTORY NOT PURGED
之前有个doc WRH$_ACTIVE_SESSION_HISTORY Does Not Get Purged Based Upon the Retention Policy (Doc ID 387914.1)
教我们使用alter session set "_swrf_test_action" = 72;的方法手动分割，但这个方法仍然无法使WRH$_ACTIVE_SESSION_HISTORY自动去分割，实际上这是11.2.0.4的bug
Online打补丁的方法如下：
(2.2) Installing in Online Mode ----------------------------------- To install the patch in online mode, follow these steps: 1. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands: $ cd <PATCH_TOP_DIR>/14084247 2. Install the patch by running the following command: - For Non-RAC Environments (Standalone Databases): $ opatch apply online -connectString <SID>:<USERNAME>:<PASSWORD>: - For RAC Environments: $ opatch apply online -connectString <SID_Node1>:<Username_Node1>:<Password_Node1>:<Node1_Name>,<SID_Node2>:<Username_Node2>:<Password_Node2>:<Node2_Name>,<SID_NodeN>:<Username_NodeN>:<Password_NodeN>:<NodeN_Name> Note: - Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NodeN refers to the different nodes of the Oracle RAC system. Once the patch is applied on the first node, OPatch automatically moves over and patches the next node you have specified in the comamnd.
RAC环境，只需要在一个节点执行，自动的应用到其他节点
如下是在RAC Online mode下直接应用该补丁的详细过程
1.oracle用户下解压缩patch
oracle@phars1: /dmp> unzip p14084247_112040_Linux-x86-64.zip
Archive: p14084247_112040_Linux-x86-64.zip
creating: 14084247/
creating: 14084247/etc/
creating: 14084247/etc/config/
inflating: 14084247/etc/config/inventory.xml
inflating: 14084247/etc/config/actions.xml
inflating: 14084247/etc/config/deploy.xml
creating: 14084247/etc/xml/
inflating: 14084247/etc/xml/GenericActions.xml
inflating: 14084247/etc/xml/ShiphomeDirectoryStructure.xml
creating: 14084247/files/
creating: 14084247/files/lib/
creating: 14084247/files/lib/libserver11.a/
inflating: 14084247/files/lib/libserver11.a/kewr.o
creating: 14084247/online/
creating: 14084247/online/files/
creating: 14084247/online/files/hpatch/
inflating: 14084247/online/files/hpatch/bug14084247.pch
creating: 14084247/online/etc/
creating: 14084247/online/etc/xml/
inflating: 14084247/online/etc/xml/GenericActions.xml
inflating: 14084247/online/etc/xml/ShiphomeDirectoryStructure.xml
creating: 14084247/online/etc/config/
inflating: 14084247/online/etc/config/inventory.xml
inflating: 14084247/online/etc/config/actions.xml
inflating: 14084247/online/etc/config/deploy.xml
inflating: 14084247/README.txt
inflating: PatchSearch.xml
2.cd到解压后的patch目录
oracle@phars1: /dmp> cd 14084247/
3.检查OPatch版本，并查看当前已经运用的补丁
oracle@phars1: /dmp/14084247> opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0
Central Inventory : /grid/oraInventory
from : /oracle/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /oracle/product/11.2.0/cfgtoollogs/opatch/opatch2017-02-22_14-14-35PM_1.log
Lsinventory Output file location : /oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2017-02-22_14-14-35PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
Rac system comprising of multiple nodes
Local node = phars1
Remote node = phars2
--------------------------------------------------------------------------------
OPatch succeeded.
4.开始应用patch
oracle@phars1: /dmp/14084247> opatch apply online -connectString phars1:system:******:phars1,phars2:system:******:phars2
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0
Central Inventory : /grid/oraInventory
from : /oracle/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /oracle/product/11.2.0/cfgtoollogs/opatch/14084247_Feb_22_2017_14_17_56/apply2017-02-22_14-17-56PM_1.log
The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '14084247' to OH '/oracle/product/11.2.0'
Verifying environment and performing prerequisite checks...
All checks passed.
Backing up files...
Patching component oracle.rdbms, 11.2.0.4.0...
Installing and enabling the online patch 'bug14084247.pch', on database 'phars1'.
Verifying the update...
Patching in all-node mode.
Updating nodes 'phars2'
Apply-related files are:
FP = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt"
DP = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt"
MP = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/make_cmds.txt"
RC = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/remote_cmds.txt"
Instantiating the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt" with actual path.
Propagating files to remote nodes...
Instantiating the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt" with actual path.
Propagating directories to remote nodes...
Installing and enabling the online patch 'bug14084247.pch', on database 'phars2' on node 'phars2'.
Patch 14084247 successfully applied
Log file location: /oracle/product/11.2.0/cfgtoollogs/opatch/14084247_Feb_22_2017_14_17_56/apply2017-02-22_14-17-56PM_1.log
OPatch succeeded.
oracle@phars1: /dmp/14084247> opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0
Central Inventory : /grid/oraInventory
from : /oracle/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
Log file location : /oracle/product/11.2.0/cfgtoollogs/opatch/opatch2017-02-22_14-18-19PM_1.log
Lsinventory Output file location : /oracle/product/11.2.0/cfgtoollogs/opatch/lsinv/lsinventory2017-02-22_14-18-19PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch (online) 14084247: applied on Wed Feb 22 14:18:01 CST 2017
Unique Patch ID: 17159649
Created on 5 Feb 2014, 05:35:15 hrs
Bugs fixed:
14084247
Rac system comprising of multiple nodes
Local node = phars1
Remote node = phars2
--------------------------------------------------------------------------------
OPatch succeeded.
5.查看patch日志
oracle@phars1: /dmp/14084247> more /oracle/product/11.2.0/cfgtoollogs/opatch/14084247_Feb_22_2017_14_17_56/apply2017-02-22_14-17-56PM_1.log
[Feb 22, 2017 2:17:57 PM] OPatch invoked as follows: 'apply online -connectString ***** -invPtrLoc /oracle/product/11.2.0/oraInst.loc '
[Feb 22, 2017 2:17:57 PM] OUI-67077:
Oracle Home : /oracle/product/11.2.0
Central Inventory : /grid/oraInventory
from : /oracle/product/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.4
OUI version : 11.2.0.4.0
OUI location : /oracle/product/11.2.0/oui
Log file location : /oracle/product/11.2.0/cfgtoollogs/opatch/14084247_Feb_22_2017_14_17_56/apply2017-02-22_14-17-56PM_1.log
[Feb 22, 2017 2:17:57 PM] Patch history file: /oracle/product/11.2.0/cfgtoollogs/opatch/opatch_history.txt
[Feb 22, 2017 2:17:57 PM] Starting ApplySession at Wed Feb 22 14:17:57 CST 2017
[Feb 22, 2017 2:17:57 PM] Starting Apply Session at Wed Feb 22 14:17:57 CST 2017
[Feb 22, 2017 2:17:57 PM] OPatch will do the following:
[Oracle Home discovery] : Configure and Validate Oracle Home info.
[Prerequisite for apply] : Invoke prerequisites to see if patch can be applied.
[Patch conflict detection for apply patch] : Check if any conflict with already installed patches in Oracle Home.
[Feb 22, 2017 2:17:57 PM] --------------------- Oracle Home discovery ---------------------
[Feb 22, 2017 2:17:57 PM] The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
[Feb 22, 2017 2:17:57 PM] OUI-67086:ApplySession applying interim patch '14084247' to OH '/oracle/product/11.2.0'
[Feb 22, 2017 2:17:57 PM] Applying interim patch '14084247' to OH '/oracle/product/11.2.0'
[Feb 22, 2017 2:17:57 PM] Starting to apply patch to local system at Wed Feb 22 14:17:57 CST 2017
[Feb 22, 2017 2:17:57 PM] Verifying environment and performing prerequisite checks...
[Feb 22, 2017 2:18:00 PM] Start the Apply initScript at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] Finish the Apply initScript at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] --------------------- Prerequisite for apply ---------------------
[Feb 22, 2017 2:18:00 PM] Running prerequisite checks...
[Feb 22, 2017 2:18:00 PM] Patch "14084247" is ignored as it is not a "Fusion Applications patch".
[Feb 22, 2017 2:18:00 PM] Check if patch "14084247" is a no-op patch.
[Feb 22, 2017 2:18:00 PM] None of the selected patches are no-op. patches..
[Feb 22, 2017 2:18:00 PM] [Rac: [RacType: typeDesc= MULTIPLE_NODE, detail= Rac system comprising of multiple nodes ], should propagate file= true, local node="phars1", remote nodes=""ph
ars2" , racTypeDetail="Rac system comprising of multiple nodes", racDiagMsg="
OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.
]
[Feb 22, 2017 2:18:00 PM] DB Instance "phars1" is up.
[Feb 22, 2017 2:18:00 PM] Space Needed : 1.107MB
[Feb 22, 2017 2:18:00 PM] [hotpatchAction: Name="14084247", path="hpatch", fileName= "hpatch/bug14084247.pch", mkpatch params="", lineNumer="3", parentPath="%ORACLE_HOME%/hpatch/bug1408
4247.pch", filesTouched="lib/libserver11.a/kewr.o", "", modifiedFunctions="kewrfsc_flush_snapshot_c", "kewrasad_auto_split_all_dbids", "kewrsgp_split_glob_partn", "kewrspbs_split_partn_bys
id", "kewrist_is_split_time", "kewrcfp_create_first_partition", "" rawCopyAction=" <hotpatch name="14084247" object_name="lib/libserver11.a/kewr.o" modified_function="kewrfsc_flush_snapsho
t_c,kewrasad_auto_split_all_dbids,kewrsgp_split_glob_partn,kewrspbs_split_partn_bysid,kewrist_is_split_time,kewrcfp_create_first_partition" filename="hpatch/bug14084247.pch" path="%ORACLE_
HOME%/hpatch" mkpatch_param="" />"]
[Feb 22, 2017 2:18:00 PM] Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 14084247
[Feb 22, 2017 2:18:00 PM] --------------------- Patch conflict detection for apply patch ---------------------
[Feb 22, 2017 2:18:00 PM] Patch 14084247 is not subset of any other patch processed till now
[Feb 22, 2017 2:18:00 PM] Patch ID 14084247
[Feb 22, 2017 2:18:00 PM] Patches that conflict: [ ]
[Feb 22, 2017 2:18:00 PM] Checking conflicts for patch: 14084247
[Feb 22, 2017 2:18:00 PM] Checking conflicts/supersets for patch: 14084247 with patch:14084247
[Feb 22, 2017 2:18:00 PM] Patch 14084247 is not subset of any other patch processed till now
[Feb 22, 2017 2:18:00 PM] Patch ID 14084247
[Feb 22, 2017 2:18:00 PM] Patches that conflict: [ ]
[Feb 22, 2017 2:18:00 PM] Checking conflicts for patch: 14084247
[Feb 22, 2017 2:18:00 PM] Checking conflicts/supersets for patch: 14084247 with patch:14084247
[Feb 22, 2017 2:18:00 PM] To continue, OPatch will do the following:
[Back up for restore] : Back up 2 files for Oracle Home restore in case of patching error.
[Back up for rollback] : Back up 0 files for future patch rollback.
[Patch Oracle Home for apply] : .
[Update inventory for apply] : Modify the inventory to record patch [14084247].
[RAC propagation] :
[Feb 22, 2017 2:18:00 PM] All checks passed.
[Feb 22, 2017 2:18:00 PM] Need to look only in the OUI based Oracle Home to configure OCM
[Feb 22, 2017 2:18:00 PM] Current working directory is : /oracle/product/11.2.0/OPatch
[Feb 22, 2017 2:18:00 PM] OPatch is generic, it is not bundled with OCM.
[Feb 22, 2017 2:18:00 PM] OPatch detected the node list and the local node from the inventory. OPatch will patch the local system then propagate the patch to the remote nodes.
[Feb 22, 2017 2:18:00 PM] Start saving patch at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] Finish saving patch at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] --------------------- Back up for restore ---------------------
[Feb 22, 2017 2:18:00 PM] Backing up files...
[Feb 22, 2017 2:18:00 PM] Start backing up system for restore at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] OUI-67116:Backing up files and inventory (not for auto-rollback) for the Oracle Home
[Feb 22, 2017 2:18:00 PM] OUI-67117:Backing up files affected by the patch '14084247' for restore. This might take a while...
[Feb 22, 2017 2:18:00 PM] Finish backing up system for restore at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] ******* create file /oracle/product/11.2.0/.patch_storage/interim_inventory.txt
[Feb 22, 2017 2:18:00 PM] --------------------- Back up for rollback ---------------------
[Feb 22, 2017 2:18:00 PM] Start backing up system for rollback at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] OUI-67161:Backing up files affected by the patch '14084247' for rollback. This might take a while...
[Feb 22, 2017 2:18:00 PM] Finish backing up system for rollback at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] --------------------- Patch Oracle Home for apply ---------------------
[Feb 22, 2017 2:18:00 PM] Start modifying the system at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] Patching component oracle.rdbms, 11.2.0.4.0...
[Feb 22, 2017 2:18:00 PM] OUI-67124:The patch will be installed on active database instances.
[Feb 22, 2017 2:18:00 PM] [hotpatchAction: Name="14084247", path="hpatch", fileName= "hpatch/bug14084247.pch", mkpatch params="", lineNumer="3", parentPath="%ORACLE_HOME%/hpatch/bug14084247.pch", filesTouched="lib/libserver11.a/kewr.o", "", modifiedFunctions="kewrfsc_flush_snapshot_c", "kewrasad_auto_split_all_dbids", "kewrsgp_split_glob_partn", "kewrspbs_split_partn_bysid", "kewrist_is_split_time", "kewrcfp_create_first_partition", "" rawCopyAction=" <hotpatch name="14084247" object_name="lib/libserver11.a/kewr.o" modified_function="kewrfsc_flush_snapshot_c,kewrasad_auto_split_all_dbids,kewrsgp_split_glob_partn,kewrspbs_split_partn_bysid,kewrist_is_split_time,kewrcfp_create_first_partition" filename="hpatch/bug14084247.pch" path="%ORACLE_HOME%/hpatch" mkpatch_param="" />"]
[Feb 22, 2017 2:18:00 PM] Start hotpatch Action at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] Finish hotpatch Action at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] Installing and enabling the online patch 'bug14084247.pch', on database 'phars1'.
[Feb 22, 2017 2:18:00 PM] Finish modifying the system at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] --------------------- Update inventory for apply ---------------------
[Feb 22, 2017 2:18:00 PM] OUI-67085:ApplySession adding interim patch '14084247' to inventory
[Feb 22, 2017 2:18:00 PM] Start saving patch to inventory at Wed Feb 22 14:18:00 CST 2017
[Feb 22, 2017 2:18:00 PM] Registered Encoding value is : UTF-8 for the file /oracle/product/11.2.0/inventory/oneoffs/14084247/etc/config/actions.xml
[Feb 22, 2017 2:18:01 PM] Finish saving patch to inventory at Wed Feb 22 14:18:01 CST 2017
[Feb 22, 2017 2:18:01 PM] Verifying the update...
[Feb 22, 2017 2:18:01 PM] Inventory check OK: Patch ID 14084247 is registered in Oracle Home inventory with proper meta-data.
[Feb 22, 2017 2:18:01 PM] verifying 1 plugin actions.
[Feb 22, 2017 2:18:01 PM] Files check OK: Files from Patch ID 14084247 are present in Oracle Home.
[Feb 22, 2017 2:18:01 PM] Finish applying patch to local system at Wed Feb 22 14:18:01 CST 2017
[Feb 22, 2017 2:18:01 PM] --------------------- RAC propagation ---------------------
[Feb 22, 2017 2:18:01 PM] Starting to apply patch to remote nodes 'phars2' at Wed Feb 22 14:18:01 CST 2017
[Feb 22, 2017 2:18:01 PM] Patching in all-node mode.
[Feb 22, 2017 2:18:01 PM] Updating nodes 'phars2'
[Feb 22, 2017 2:18:01 PM] Apply-related files are:
FP = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt"
DP = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt"
MP = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/make_cmds.txt"
RC = "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/remote_cmds.txt"
[Feb 22, 2017 2:18:01 PM] Instantiating the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt" with actual path.
[Feb 22, 2017 2:18:01 PM] Propagating files to remote nodes...
[Feb 22, 2017 2:18:02 PM] Instantiating the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt.instantiated" by replacing $ORACLE_HOME in "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt" with actual path.
[Feb 22, 2017 2:18:02 PM] Propagating directories to remote nodes...
[Feb 22, 2017 2:18:03 PM] Installing and enabling the online patch 'bug14084247.pch', on database 'phars2' on node 'phars2'.
[Feb 22, 2017 2:18:03 PM] Start Cluster command /oracle/product/11.2.0/OPatch/opatch util enableOnlinePatch -local -id 14084247 -oh /oracle/product/11.2.0 -invPtrLoc /oracle/product/11.2.0/oraInst.loc -connectString phars2:system:RACoracle11g:: on node phars2 at Wed Feb 22 14:18:03 CST 2017
[Feb 22, 2017 2:18:11 PM] Finish Cluster command /oracle/product/11.2.0/OPatch/opatch util enableOnlinePatch -local -id 14084247 -oh /oracle/product/11.2.0 -invPtrLoc /oracle/product/11.2.0/oraInst.loc -connectString phars2:system:RACoracle11g:: on node phars2 at Wed Feb 22 14:18:11 CST 2017
[Feb 22, 2017 2:18:11 PM] Finish applying patch to remote nodes at Wed Feb 22 14:18:11 CST 2017
[Feb 22, 2017 2:18:11 PM] OPatch will clean up 'restore.sh,make.txt' files and 'rac,scratch,backup' directories.
You will be still able to rollback patches after this cleanup.
Do you want to proceed? [y|n]
[Feb 22, 2017 2:18:14 PM] Y (auto-answered by -silent)
[Feb 22, 2017 2:18:14 PM] User Responded with: Y
[Feb 22, 2017 2:18:14 PM] Size of directory "/oracle/product/11.2.0/.patch_storage" before cleanup is 422000 bytes.
[Feb 22, 2017 2:18:14 PM] Deleting the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup"
[Feb 22, 2017 2:18:14 PM] Deleting the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup/inventory"
[Feb 22, 2017 2:18:14 PM] Deleting the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup/inventory/ContentsXML"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup/inventory/ContentsXML/comps.xml"
[Feb 22, 2017 2:18:14 PM] Deleted the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup/inventory/ContentsXML"
[Feb 22, 2017 2:18:14 PM] Deleted the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup/inventory"
[Feb 22, 2017 2:18:14 PM] Deleted the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/backup"
[Feb 22, 2017 2:18:14 PM] Deleting the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/remote_cmds.txt.instantiated"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/remote_cmds.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/remote_cmds_14084247.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files_14084247.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt.instantiated"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/make_cmds.txt.instantiated"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt.instantiated"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs_14084247.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_dirs.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/copy_files.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/make_cmds.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac/mode.txt"
[Feb 22, 2017 2:18:14 PM] Deleted the directory "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/rac"
[Feb 22, 2017 2:18:14 PM] Deleted the file "/oracle/product/11.2.0/.patch_storage/14084247_Feb_5_2014_05_35_15/restore.sh"
[Feb 22, 2017 2:18:14 PM] Size of directory "/oracle/product/11.2.0/.patch_storage" after cleanup is 10901 bytes.
[Feb 22, 2017 2:18:14 PM] UtilSession: Backup area for restore has been cleaned up. For a complete list of files/directories
deleted, Please refer log file.
[Feb 22, 2017 2:18:14 PM] Patch 14084247 successfully applied
[Feb 22, 2017 2:18:14 PM] Finishing ApplySession at Wed Feb 22 14:18:14 CST 2017
[Feb 22, 2017 2:18:14 PM] Total time spent waiting for user-input is 0 seconds. Finish at Wed Feb 22 14:18:14 CST 2017
[Feb 22, 2017 2:18:14 PM] Log file location: /oracle/product/11.2.0/cfgtoollogs/opatch/14084247_Feb_22_2017_14_17_56/apply2017-02-22_14-17-56PM_1.log
oracle@phars1: /dmp/14084247>
参考：
https://updates.oracle.com/Orion/Services/download?type=readme&aru=17159649
这个链接就是补丁的README文档，详细如下
oracle@phars1: /dmp/14084247> more README.txt
Oracle Database 11g Release 11.2.0.4.0
ORACLE DATABASE Patch for Bug# 14084247 for Linux-x86-64 Platforms
This patch is RAC Rolling Installable.
This patch is Online Patchable - Please read My Oracle Support note 761111.1 on how to use/deploy an online patch
This patch is Data Guard Standby-First Installable. Please read My Oracle Support Note 1265700.1 https://support.us.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1265700.1
Oracle Patch Assurance - Data Guard Standby-First Patch Apply for details on how to remove risk and reduce downtime when applying this patch.
Released: Wed Feb 5 05:15:59 2014
This document describes how you can install the ORACLE DATABASE combo patch for bug# 14084247 on your Oracle Database 11g Release 11.2.0.4.0.
A combo patch is a patch that can be applied either in offline mode or in online mode. For information about offline and online modes of patching, see My Oracle Support note 761111.1 avail
able at:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=761111.1
Note:
- Online patches are recommended when a downtime cannot be scheduled and the patch needs to be applied urgently.
- Online patches consume additional memory and if kept permanently the memory consumption increases as the number of processes in the system increases.
- It is strongly recommended to rollback all Online patches and replace them with regular (offline) patches on next instance shutdown or the earliest maintenance window.
(1) Prerequisites
------------------
Before you install or deinstall the patch, ensure that you meet the following requirements:
Note: In case of an Oracle RAC environment, meet these prerequisites on each of the nodes.
1. Ensure that the Oracle home on which you are installing the patch or from which you are rolling back the patch is Oracle Database 11g Release (11.2.0.4.0).
2. Oracle recommends you to use the latest version of OPatch available for 11g Release 11.2.0.4.0. If you do not have OPatch 11g Release 11.2.0.4.0 or the latest version available for
XXg Release X, then download it from patch# 6880880 for 11.2.0.4.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support Document 293369.1 OPatch documentation list:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1
3. Ensure that you set (as the home user) the ORACLE_HOME environment variable to the Oracle home.
4. Ensure that the $PATH definition has the following executables: make, ar, ld and nm. The location of these executables depends on your operating system. On many operating systems,
they are located in /usr/ccs/bin.
5. Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command. If the command displays some erro
rs, then contact Oracle Support and resolve the issue.
$ opatch lsinventory
Note:
- If this command succeeds, it will list the Top-Level Oracle Products and one-off patches if any that are installed in the Oralce Home.
- Save the output so you have the status prior to the patch apply.
- If the command displays some errors, then contact Oracle Support and resolve the issue first before proceeding further.
6. (Only for Installation) Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as <PATCH_TOP_
DIR>. Extract the contents of the patch ZIP file to the location (PATCH_TOP_DIR) you have created above. To do so, run the following command:
$ unzip -d <PATCH_TOP_DIR> p14084247_112040_Linux-x86-64.zip
7. (Only for Installation) Determine whether any currently installed interim patches conflict with this patch 14084247 as shown below:
$ cd <PATCH_TOP_DIR>/14084247
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
The report will indicate the patches that conflict with this patch and the patches for which the current 14084247 is a superset.
Note:
When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME. OPatch categorizes conflicts into the fol
lowing types:
- Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply - In this case, continue with the patch installation becaus
e the new patch contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
- Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
8. (Only for Offline Patching) Ensure that you shut down all the services running from the Oracle home.
Note:
- For a Non-RAC environment, shut down all databases and listeners associated with the Oracle home that you are updating. For more information, see Oracle Database Administra
tor's Guide.
- For a RAC environment, shut down all the services (database, ASM, listeners, nodeapps, and CRS daemons) running from the Oracle home of the node you want to patch. After yo
u patch this node, start the services on this node. Repeat this process for each of the other nodes of the Oracle RAC system. OPatch is used on only one node at a time.
9. (Only for Online Patching) Ensure that all the services in the Oracle home are up and running.
10. (Only for Online Patching) Ensure that you maintain adequate memory on your system to apply this online patch. To calculate the amount of memory required for this online patch, use
the following formula:
Memory Consumed = (Number of Oracle Processes + 1) X (Size of Patched .pch File)
Note:
- For UNIX, the number of Oracle processes is determined by checking the parameter "processes" in the database by querying v$parameter. For Microsoft Windows, the number of O
racle processes is always zero (0).
- The .pch file is available under <bug_number>/online/files/hpatch/ directory.
11. None
(2) Installation
-----------------
This section describes the following modes you can use to install the combo patch. Use the one that best suits your requirement.
- Installing in Offline Mode
- Installing in Online Mode
(2.1) Installing in Offline Mode
-----------------------------------
To install the patch, follow these steps:
1. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
$ cd <PATCH_TOP_DIR>/14084247
$ opatch apply
2. Verify whether the patch has been successfully installed by running the following command:
$ opatch lsinventory
3. Start the services from the Oracle home.
(2.2) Installing in Online Mode
-----------------------------------
To install the patch in online mode, follow these steps:
1. Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
$ cd <PATCH_TOP_DIR>/14084247
2. Install the patch by running the following command:
- For Non-RAC Environments (Standalone Databases):
$ opatch apply online -connectString <SID>:<USERNAME>:<PASSWORD>:
- For RAC Environments:
$ opatch apply online -connectString <SID_Node1>:<Username_Node1>:<Password_Node1>:<Node1_Name>,<SID_Node2>:<Username_Node2>:<Password_Node2>:<Node2_Name>,<SID_NodeN>:<User
name_NodeN>:<Password_NodeN>:<NodeN_Name>
Note:
- Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NodeN refers to the different no
des of the Oracle RAC system. Once the patch is applied on the first node, OPatch automatically moves over and patches the next node you have specified in the comamnd.
Note:Patch Post Install Steps:
None
(3) Deinstallation
--------------------
This section describes the following modes you can use to deinstall the combo patch. Use the one that best suits your requirement.
- Deinstalling in Offline Mode
- Deinstalling in Online Mode
(3.1) Deinstalling in Offline Mode
-------------------------------------
Ensure to follow the Prerequsites (Section 1). To deinstall the patch, follow these steps:
1. Deinstall the patch by running the following command:
$ opatch rollback -id 14084247
2. Start the services from the Oracle home.
3. Ensure that you verify the Oracle Inventory and compare the output with the one run before the patch installation and re-apply any patches that were rolled back as part of this pat
ch apply. To verify the inventory, run the following command:
$ opatch lsinventory
(3.2) Deinstalling in Online Mode
--------------------------------------
Ensure to follow the Prerequsites (Section 1). To deinstall the patch in online mode, follow these steps:
1. Deinstall the patch by running the following command:
- For Non-RAC Environments (Standalone Databases):
$ opatch rollback -id 14084247 -connectString <SID>:<USERNAME>:<PASSWORD>:
- For RAC Environments:
$ opatch rollback -id 14084247 -connectString <SID_Node1>:<Username_Node1>:<Password_Node1>:<Node1_Name>,<SID_Node2>:<Username_Node2>:<Password_Node2>:<Node2_Name>,<SID_Nod
eN>:<Username_NodeN>:<Password_NodeN>:<NodeN_Name>
Note:
Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NODEn refers to the different nodes of t
he
Oracle RAC system. Once the patch is rolled back from the first node, OPatch automatically moves over and rolls back the patch from the next node you have specified in the comamnd.
(4) Bugs Fixed by This Patch
---------------------------------
The following are the bugs fixed by this patch:
14084247: STBH: ORA-01555 DUE TO WRH$_ACTIVE_SESSION_HISTORY NOT PURGED
--------------------------------------------------------------------------
Copyright 2014, Oracle and/or its affiliates. All rights reserved.
--------------------------------------------------------------------------