环境介绍:
AIX、Oracle11gRAC 11.2.0.3.0
根据文档[ID 1392633.1],安装patch 13831007.
Bugs Fixed by This Patch 13831007
———————————
The following are the bugs fixed by this patch:
12797420: MUTEX X WAITS WITH TWO JVMS
13588248: AC: OCI STRESS: ORA-7445 [KGLSESSIONHASHREMOVEFROMSESS()+59] [SIGSEGV] [ADDR:0X0
安装完成后,通过opatch lsinventory检查13831007情况,发现以下问题:
Interim patches (5) :
Patch 13831007 : applied on Sun Apr 01 14:27:12 GMT+08:00 2012
Unique Patch ID: 14654877
Created on 9 Mar 2012, 16:43:46 hrs PST8PDT
Bugs fixed:
12797420, 13588248
* Warning: no filemap entries available.
Patch Location in Inventory:
/oracle/app/oracle/product/11.2.0.3/inventory/oneoffs/13831007
Patch Location in Storage area:
/oracle/app/oracle/product/11.2.0.3/.patch_storage/13831007_Mar_9_2012_16_43_46
解决方法:
两个rac节点下都操作:
[oracle@p510]$cd /tmp/oracle/patch/13831007/etc/config
[oracle@p510]$ls
actions.xml deploy.xml inventory.xml
[oracle@p510]/tmp/oracle/patch/13831007/etc/config $cp inventory.xml $ORACLE_HOME/inventory/oneoffs/13831007/etc/config
[oracle@p510]/tmp/oracle/patch/13831007/etc/config $cp actions.xml $ORACLE_HOME/inventory/oneoffs/13831007/etc/config
再次检查:
[oracle@p520 ~]$ /oracle/app/oracle/product/11.2.0.3/OPatch/opatch lsinventory -detail -oh /oracle/app/oracle/product/11.2.0.3
Patch 13831007 : applied on Sun Apr 01 14:27:12 GMT+08:00 2012
Unique Patch ID: 14654877
Created on 9 Mar 2012, 16:43:45 hrs PST8PDT
Bugs fixed:
12797420, 13588248
Files Touched:
/kks.o –> ORACLE_HOME/lib/libserver11.a
ins_rdbms.mk –> ORACLE_HOME/rdbms/lib/irenamedg
ins_rdbms.mk –> ORACLE_HOME/rdbms/lib/ioracle
/kgl.o –> ORACLE_HOME/lib/libgeneric11.a
/kgl2.o –> ORACLE_HOME/lib/libgeneric11.a
/kgl4.o –> ORACLE_HOME/lib/libgeneric11.a
ins_net_client.mk –> ORACLE_HOME/network/lib/client_sharedlib
Patch Location in Inventory:
/oracle/app/oracle/product/11.2.0.3/inventory/oneoffs/13831007
Patch Location in Storage area:
/oracle/app/oracle/product/11.2.0.3/.patch_storage/13831007_Mar_9_2012_16_43_45
问题原因:
详见metalink:[ID 431783.1]
Cause
$ORACLE_HOME/inventory/oneoffs/patch number/etc/config/actions or $ORACLE_HOME/inventory/oneoffs/patch number/etc/config/inventory does not exist.
OR
The above files exist but they are not of proper size.
更多Oracle相关信息见Oracle 专题页面 ?tid=12
,