遇到BUG:5103658

背景说明: spotlight以RAC方式连接XDB数据库时产生连接成功后即中断,spotlight无法正常以RAC方式监控XDB;

但能以RAC方式监控同样平台,同样版本的另一个RAC数据库.

分析:根据连接时产生的错误提示ORA-03113: end-of-file on communication channel, 并在alert数据库报警日志文件中产生trc文件及ORA-07445: exception encountered: core dump [] [] [] [] [] []错误提示. Trc文件中发现:

*** 2009-03-03 15:44:47.458

ksedmp: internal or fatal error

ORA-07445: 鍑虹幇寮傚父閿欒?: 鏍稿績杞?偍 [] [] [] [] [] []

Current SQL statement for this session:

SELECT inst_id, ip_ksxpia FROM x$ksxpia

直连测试:下面第一个SQL窗口查询自YDB数据库正常返回结果,第二个SQL窗口查询自XDB数据库,则同样产生trc及ORA-07445:

[@more@]

Metalink上查到ORACLE文档(5103658.8)中提到的ORACLE BUG有关,需要打补丁到10.2.0.3

Description

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/2073/viewspace-1019633/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/2073/viewspace-1019633/