背景说明: 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
A dump can occur in ksxpfixcb for a SELECT from V$CONFIGURED_INTERCONNECTSPlease 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博客 ” ，链接：https://blog.itpub.net/2073/viewspace-1019633/ ，如需转载，请注明出处，否则将追究法律责任。
