ORA-00600: internal error code, arguments: [13310], [],错误解决

时间：2010-08-23 来源：djb1008

一. 问题描述

在数据库警告日志中不断报ORA-00600 [13310]的错误.

$tail -f alert_<ORACLE_SID>.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 /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.

源文档 <https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=468122.1>

从网络层查找原因,发现hosts文件设置与hostname不相同,情况如下:

$hostname

pxlsdb

$more /etc/hosts

12.34.18.205 pxls

三. 问题解决

#vi /etc/hosts

#more /etc/hosts