st put in "cd 18522512 opatch apply"?Should I "startup" and "@catbundle.sql psu apply"? We are applying patch only at binary level in 3rd step, i.e. opatch apply Database start up and catbundle execution is covered in step 7 We can do this step along with opatch apply, but for applying overlay patch (step 4) again we have to shutdown the database. To avoid that we apply all patches at binary first, then start the database to execute catbundle.sql
11.2.0.3.11的PSU是包含11.2.0.3.7的PSU的。Apply 11.2.0.3.11的PSU,是会先APPLY 11.2.0.3.7版本的。但是,已经存在的patch 13004894跟这个11.2.0.3.7 PSU有冲突,因此我们需要安装13004894的11.2.0.3.7版本,这个PSU,是会包含11.2.0.3.7的PSU与13004894这个patch的协调版本。
三,实际操作 Thanks for contacting oracle support.
PSU patch has conflict with existing installed patches.
Merge patch is available for this conflict. You can follow below steps to apply patch
1) Shutdown oracle services and then take backup of Oracle database, oracle home and central inventory
2) Rollback conflicting patches 13004894,12942119
opatch rollback -id
3) Apply PSU patch 18522512
4) Download following overlay patches from Oracle support,
https://updates.oracle.com/download/13004894.
html
choose platform as 'Linux X86' and version as 11.2.0.3.7
p13004894_112037_LINUX.zip
https://updates.oracle.com/download/12942119.html
choose platform as 'Linux X86' and version as 11.2.0.3.8
p12942119_112038_LINUX.zip
5) Unzip the downloaded patches and apply. It will not have conflicts
6) Start the database
7) Perform PSU patch post Installation Instructions as specified in Patch Read me file
Please let me know if you require more details/assistance on any steps
We would like inform you about new MOS feature.
A new Patch Conflict Checker feature is available in the latest release of MOS. This is accessible from the Patch Search results screen ("Analyze with OPatch" button) and allows you to analyze candidate patches for conflicts and request merge fixes a lot more easily and quickly at the time of patch download itself. This feature allows you to:
1. Analyze patches for conflicts right at the time of patch download - All you need is your Opatch inventory.
2. Locate already available replacement patches ? So, you can download resolution patches immediately.
3. Request a merge patch right there, if no replacement patches exist - You will not have to spend time logging a SR.
For more information and a demonstration video, please see Note 1091294.1 - How to use the My
Oracle Support Conflict Checker Tool. Should you need assistance get started, I am glad to set up a call/web conference to walk you through the steps.
(1)停应用、监听、数据库; (2)rollback两个已经存在的patch ora@erpt1:erpt1 >
opatch rollback -id 13004894
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/erpt1/db/tech_st/11.2.0
Central Inventory : /u01/oraInventory
from : /u01/erpt1/db/tech_st/11.2.0/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /u01/erpt1/db/tech_st/11.2.0/cfgtoollogs/opatch/13004894_Jul_30_2014_11_45_32/rollback2014-07-30_11-45-31AM_1.log
RollbackSession rolling back interim patch '13004894' from OH '/u01/erpt1/db/tech_st/11.2.0'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/erpt1/db/tech_st/11.2.0')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Patching component oracle.rdb |