ORACLE 10.2.0.2版本的RAC环境下，因为拿标准的TPC-C进行压力测试，发现后台ALERT日志中报有很多DEADLOCK，或许是TPC-C压力测试软件的问题，也或许是ORACLE的BUG，于是找到BUG相对应的补丁，OPATCH打上去，结果三个节点只有一个节点能起的来了，其他两个节点不能OPEN了，最后把新打的PATCH删掉，错误依旧。

[@more@]

手工启动会报ORA-03113: end-of-file on communication channel,尝试了一步步的来启动，结果发现是最后库OPEN的时候出现的问题，同时后台ALERT日志中报错：ORA-07445: exception encountered: core dump [kkxsyn()+584] [SIGSEGV] [Address not mapped to object] [0x000000168] [] []，METALINK发现是一个新的BUG，BUG号5128575。基本上就是说，你打PATCH的时候，ORACLE会忽悠你，说是PATCH打好了，其实只更新了你执行OPATCH的那个节点的库文件，其他的节点都没有更新，手工更新一下就OK了，下面是METALINK上详细的描述：

Installing the 10.2.0.2 Patch Set in a RAC installation
on any Unix platform does not correctly update the libknlopt.a
file on all nodes. The local node where the installer is run
does update libknlopt.a but remote nodes do not get the
updated file.

This can lead to dumps or internal errors on the remote nodes
if Oracle is subsequently relinked.
eg: Attempts to use PLSQL may dump in kkxcms or kkxsyn

The workaround steps below should be considered as a mandatory
post install steps for the 10.2.0.2 Patch Set.

Workaround:
Following install of 10.2.0.2 on a RAC system:
Ensure all instances are shut down
Manually copy $ORACLE_HOME/rdbms/lib/libknlopt.a from the local node
to all remote nodes and relink Oracle on all nodes.
eg: cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk ioracle