ORA-00600: internal error code, arguments: [13310], [],錯誤解決

一. 問題描述

在資料庫警告日誌中不斷報ORA-00600 [13310]的錯誤.

$tail -f alert_.log

…….

ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], []

Mon Aug 23 10:48:35 2010

Errors in file /oracle/admin/ypjkdb/bdump/ypjkdb_j000_1225180.trc:

ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], []

Mon Aug 23 10:49:35 2010

Errors in file /oracle/admin/ypjkdb/bdump/ypjkdb_j000_1225180.trc:

ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], []

Mon Aug 23 10:50:35 2010

……

[@more@]

$more /oracle/admin/ypjkdb/bdump/ypjkdb_j000_1225180.trc

/oracle/admin/ypjkdb/bdump/ypjkdb_j000_1225180.trc

…...

Warning: keltnfy call to ldmInit failed with error 46

*** ACTION NAME:(AGENT_STATUS_MARKER) 2010-08-23 10:45:35.011

*** MODULE NAME:(EM_PING) 2010-08-23 10:45:35.011

*** SERVICE NAME:(SYS$USERS) 2010-08-23 10:45:35.011

*** SESSION ID:(372.58043) 2010-08-23 10:45:35.011

*** 2010-08-23 10:45:35.011

ksedmp: internal or fatal error

ORA-00600: internal error code, arguments: [13310], [], [], [], [], [], [], []

Current SQL statement for this session:

SELECT SYS_GUID() FROM SYS.DUAL

…...

二. 問題分析

metalink上搜尋"ORA-00600: internal error code, arguments: [13310]",找到了468122.1

…...

Cause

Research on the ORA-600 [13310] indicates this error can be raised due to failures in the network layer calls. If ORA-03136 is also reported, this is a strong confirmation the problem is most likely network related.

For any ORA-600 [13310] error, it is important to review accompanying errors because in many cases this problem has been linked to a resource (swap, memory, etc..) issue on the server.

Solution

1. Check the network logs to identify the root cause of any network failures.

2. Check the O/S logs to determine if the operating system is reporting a resource related problem.

源文件 <>

從網路層查詢原因,發現hosts檔案設定與hostname不相同,情況如下:

$hostname

pxlsdb

$more /etc/hosts

12.34.18.205 pxls

三. 問題解決

#vi /etc/hosts

#more /etc/hosts

12.34.18.205 pxlsdb

再次檢查alter_.log,資料庫不再報ORA-00600 [13310]錯誤了,問題得到解決