给某移动账务容灾A库应用11.2.0.4.6的psu时出现如下报错（在A1应用psu时正常，在A2应用时报错,，数据库当前版本为11.2.0.4.2）：
|
h7sd02da#[/home/grid]/oracle/app/11.2.0/grid/OPatch/opatch napply -oh /oracle/app/11.2.0/grid -local /arch01/jzw/20485808/20420937
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/11.2.0/grid
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/11.2.0/grid/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /oracle/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-09-08_12-59-41PM_1.log
OPatchSession cannot load inventory for the given Oracle Home /oracle/app/11.2.0/grid. Possible causes are:
No read or write permission to ORACLE_HOME/.patch_storage
Central Inventory is locked by another OUI instance
No read permission to Central Inventory
The lock file exists in ORACLE_HOME/.patch_storage
The Oracle Home does not exist in Central Inventory
UtilSession failed: Unable to create patchObject
Possible causes are:
ORACLE_HOME/inventory/oneoffs/18031740 is corrupted
No read permission to above directory
Please remove one-off entry [ 18031740 ] from /oracle/app/11.2.0/grid/inventory/ContentsXML/comps.xml and retry if above directory corrupted, or Please check the contents of the directory ORACLE_HOME/inventory/oneoffs/18031740 for read permission
Log file location: /oracle/app/11.2.0/grid/cfgtoollogs/opatch/opatch2015-09-08_12-59-41PM_1.log
OPatch failed with error code 73
|
想想可能由于应用psu前将 18031740 这个补丁卸载导致的
opatch rollback -id 18031740 ---这个补丁不要卸载，就是由于卸载这个补丁导致报错
|
DB Version |
PSU Version |
<GI_PSU_number> |
<OCW Components_number> |
<ACFS Components_number> |
<DB_PSU_number> |
|
11.2.0.4.0 |
11.2.0.4.2GIPSU |
18139609 |
18031740 |
18031731 |
18031668 |
|
|
11.2.0.4.3GIPSU |
18706472 |
18522515 |
18522514 |
18522509 |
|
|
11.2.0.4.4GIPSU |
19380115 |
19121549 |
19121552 |
19121551 |
|
|
11.2.0.4.5GIPSU |
19955028 |
19769476 |
19769469 |
19769489 |
|
|
11.2.0.4.6GIPSU |
20485808 |
20420937 |
20299019 |
20299013 |
|
|
11.2.0.4.7GIPSU |
20996923 |
20831122 |
20299019 |
20760982 |
在网上没有查找到解决方案方案，通过报错自己找到比较暴力的解决方法，修改 /oracle/app/11.2.0/grid/inventory/ContentsXML/comps.xml 文件，将对应的one-off-patch文字删除
|
--备份 /oracle/app/11.2.0/grid/inventory/ContentsXML/comps.xml 文件
su - grid
cd /oracle/app/11.2.0/grid/inventory/ContentsXML
h7sd02da#[/oracle/app/11.2.0/grid/inventory/ContentsXML]ls -lrt
total 564
drwx------ 2 grid oinstall 1024 Nov 1 2014 ConfigXML
-rw-rw---- 1 grid oinstall 708 Nov 1 2014 oraclehomeproperties.xml
-rwxrwx--- 1 grid oinstall 278655 Nov 1 2014 comps.xml
-rwxrwx--- 1 grid oinstall 4382 Nov 1 2014 libs.xml
-rwxrwx--- 1 grid oinstall 1568 Nov 1 2014 config.xml
h7sd02da#[/oracle/app/11.2.0/grid/inventory/ContentsXML]cp comps.xml comps.xml.bak
h7sd02da#[/oracle/app/11.2.0/grid/inventory/ContentsXML]ls -lrt
total 1110
drwx------ 2 grid oinstall 1024 Nov 1 2014 ConfigXML
-rw-rw---- 1 grid oinstall 708 Nov 1 2014 oraclehomeproperties.xml
-rwxrwx--- 1 grid oinstall 278655 Nov 1 2014 comps.xml
-rwxrwx--- 1 grid oinstall 4382 Nov 1 2014 libs.xml
-rwxrwx--- 1 grid oinstall 1568 Nov 1 2014 config.xml
-rwxr-x--- 1 grid oinstall 278655 Sep 8 13:43 comps.xml.bak
然后编辑 comps.xml 文件，删除如下信息：
</ONEOFF>
<ONEOFF REF_ID="18031740" UNIQ_ID="17282285" ROLLBACK="T" XML_INV_LOC="oneoffs/18031740/" ACT_INST_VER="11.2.0.4.0" INSTALL_TIME="2014.Nov.01 22:30:57 GMT+08:00">
<DESC>OCW Patch Set Update : 11.2.0.4.2 (18031740)</DESC>
<REF_LIST>
<REF NAME="oracle.crs" VER="11.2.0.4.0" HOME_IDX="1"/>
</REF_LIST>
<BUG_LIST>
<BUG>17481314</BUG>
<BUG>17750548</BUG>
<BUG>12928658</BUG>
<BUG>17172091</BUG>
<BUG>18229842</BUG>
<BUG>17500165</BUG>
<BUG>17405302</BUG>
<BUG>16317771</BUG>
<BUG>13991403</BUG>
<BUG>17387214</BUG>
<BUG>17273020</BUG>
<BUG>18343490</BUG>
<BUG>14693336</BUG>
<BUG>16613232</BUG>
<BUG>17001914</BUG>
<BUG>16346413</BUG>
<BUG>16206997</BUG>
<BUG>15832129</BUG>
<BUG>17039197</BUG>
<BUG>17238586</BUG>
<BUG>17305100</BUG>
<BUG>17065496</BUG>
<BUG>17391726</BUG>
<BUG>16876500</BUG>
<BUG>17483479</BUG>
<BUG>18328800</BUG>
<BUG>17155238</BUG>
<BUG>14525998</BUG>
<BUG>17292250</BUG>
<BUG>17551223</BUG>
</BUG_LIST>
<FILE_LIST/>
|
再使用opatch auto的方式，应用psu成功。
|
h7sd02da#[/oracle/app/11.2.0/grid/inventory/ContentsXML] /oracle/app/11.2.0/grid/OPatch/opatch auto /arch01/jzw/20485808 -ocmrf /oracle/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp
Executing /oracle/app/11.2.0/grid/perl/bin/perl /oracle/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /arch01/jzw -patchn 20485808 -ocmrf /oracle/app/11.2.0/grid/OPatch/ocm/bin/ocm.rsp -paramfile /oracle/app/11.2.0/grid/crs/install/crsconfig_params
This is the main log file: /oracle/app/11.2.0/grid/cfgtoollogs/opatchauto2015-09-08_13-44-36.log
This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:
/oracle/app/11.2.0/grid/cfgtoollogs/opatchauto2015-09-08_13-44-36.report.log
2015-09-08 13:44:36: Starting Clusterware Patch Setup
Using configuration parameter file: /oracle/app/11.2.0/grid/crs/install/crsconfig_params
Stopping RAC /oracle/app/oracle/product/11.2.0/db_1 ...
Stopped RAC /oracle/app/oracle/product/11.2.0/db_1 successfully
patch /arch01/jzw/20485808/20299013 apply successful for home /oracle/app/oracle/product/11.2.0/db_1
patch /arch01/jzw/20485808/20420937/custom/server/20420937 apply successful for home /oracle/app/oracle/product/11.2.0/db_1
Stopping CRS...
Stopped CRS successfully
patch /arch01/jzw/20485808/20299013 apply successful for home /oracle/app/11.2.0/grid
patch /arch01/jzw/20485808/20420937 apply successful for home /oracle/app/11.2.0/grid
Starting CRS...
Installing Trace File Analyzer
CRS-4123: Oracle High Availability Services has been started.
Starting RAC /oracle/app/oracle/product/11.2.0/db_1 ...
Started RAC /oracle/app/oracle/product/11.2.0/db_1 successfully
opatch auto succeeded.
|