316 积分	0 好友	0 主题

发消息

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

1^#

发表于 2012-8-16 15:17:22 | 查看: 6175| 回复: 7

10.2.0.4 Linux RAC

ORA-00600: internal error code, arguments: [12269], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12316], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [12316], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [733], [1936597240], [pga heap], [], [], [], [], []
ORA-00600: internal error code, arguments: [12316], [], [], [], [], [], [], []

该数据库在NAT后，当前现象，用PL/SQL Developer 连接进行某个SQL 查询时，会直接报ORA-3113，但是在SQLPLUS 下是正常的。如何诊断？

Wed Aug  1 23:09:25 2012
Thread 1 advanced to log sequence 352 (LGWR switch)
  Current log# 2 seq# 352 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Thu Aug  2 23:10:20 2012
Thread 1 advanced to log sequence 353 (LGWR switch)
  Current log# 1 seq# 353 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Fri Aug  3 23:11:22 2012
Thread 1 advanced to log sequence 354 (LGWR switch)
  Current log# 2 seq# 354 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Sat Aug  4 14:00:02 2012
Thread 1 advanced to log sequence 355 (LGWR switch)
  Current log# 1 seq# 355 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Sun Aug  5 04:00:20 2012
Thread 1 advanced to log sequence 356 (LGWR switch)
  Current log# 2 seq# 356 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Sun Aug  5 23:13:35 2012
Thread 1 advanced to log sequence 357 (LGWR switch)
  Current log# 1 seq# 357 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Mon Aug  6 23:14:33 2012
Thread 1 advanced to log sequence 358 (LGWR switch)
  Current log# 2 seq# 358 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Tue Aug  7 11:08:23 2012
Thread 1 advanced to log sequence 359 (LGWR switch)
  Current log# 1 seq# 359 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Tue Aug  7 23:15:26 2012
Thread 1 advanced to log sequence 360 (LGWR switch)
  Current log# 2 seq# 360 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Wed Aug  8 23:16:20 2012
Thread 1 advanced to log sequence 361 (LGWR switch)
  Current log# 1 seq# 361 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Thu Aug  9 23:17:15 2012
Thread 1 advanced to log sequence 362 (LGWR switch)
  Current log# 2 seq# 362 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Fri Aug 10 19:59:57 2012
Thread 1 advanced to log sequence 363 (LGWR switch)
  Current log# 1 seq# 363 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Sat Aug 11 08:00:21 2012
Thread 1 advanced to log sequence 364 (LGWR switch)
  Current log# 2 seq# 364 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Sat Aug 11 23:19:09 2012
Thread 1 advanced to log sequence 365 (LGWR switch)
  Current log# 1 seq# 365 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Sun Aug 12 23:20:00 2012
Thread 1 advanced to log sequence 366 (LGWR switch)
  Current log# 2 seq# 366 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Mon Aug 13 23:20:56 2012
Thread 1 advanced to log sequence 367 (LGWR switch)
  Current log# 1 seq# 367 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Tue Aug 14 16:59:57 2012
Thread 1 advanced to log sequence 368 (LGWR switch)
  Current log# 2 seq# 368 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Wed Aug 15 07:00:23 2012
Thread 1 advanced to log sequence 369 (LGWR switch)
  Current log# 1 seq# 369 mem# 0: +DATA/orcl/onlinelog/group_1.257.766685683
Wed Aug 15 10:46:42 2012
Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl1_ora_26736.trc:
ORA-00600: internal error code, arguments: [12269], [], [], [], [], [], [], []
Wed Aug 15 10:46:43 2012
Trace dumping is performing id=[cdmp_20120815104643]
Wed Aug 15 10:47:57 2012
Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl1_ora_26736.trc:
ORA-00600: internal error code, arguments: [12316], [], [], [], [], [], [], []
Wed Aug 15 10:47:58 2012
Trace dumping is performing id=[cdmp_20120815104758]
Wed Aug 15 10:54:03 2012
Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl1_ora_26736.trc:
ORA-00600: internal error code, arguments: [12316], [], [], [], [], [], [], []
Wed Aug 15 10:54:04 2012
Trace dumping is performing id=[cdmp_20120815105404]
Wed Aug 15 10:55:10 2012
Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl1_ora_26736.trc:
ORA-00600: internal error code, arguments: [733], [1936597240], [pga heap], [], [], [], [], []
Wed Aug 15 10:55:11 2012
Trace dumping is performing id=[cdmp_20120815105511]
Wed Aug 15 10:56:11 2012
WARNING: inbound connection timed out (ORA-3136)
Wed Aug 15 14:19:17 2012
Errors in file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl1_ora_6528.trc:
ORA-00600: internal error code, arguments: [12316], [], [], [], [], [], [], []
Wed Aug 15 14:19:18 2012
Trace dumping is performing id=[cdmp_20120815141918]
Wed Aug 15 15:24:14 2012
WARNING: inbound connection timed out (ORA-3136)
Wed Aug 15 22:00:07 2012
Thread 1 advanced to log sequence 370 (LGWR switch)
  Current log# 2 seq# 370 mem# 0: +DATA/orcl/onlinelog/group_2.258.766685683
Thu Aug 16 09:38:40 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 09:45:08 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 10:18:16 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 10:18:22 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 10:38:57 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 13:46:42 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 13:51:09 2012
WARNING: inbound connection timed out (ORA-3136)
Thu Aug 16 14:12:58 2012
WARNING: inbound connection timed out (ORA-3136)

aaa.zip (3.31 MB, 下载次数: 708)

bbb.zip (807.15 KB, 下载次数: 918)

[ 本帖最后由武汉-SSH 于 2012-8-16 15:38 编辑 ]

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

8^#

发表于 2012-8-24 11:12:02

坚持精神可敬，加下精华

以后有问题请去OTN中文论坛发帖 https://forums.oracle.com/forums/forum.jspa?forumID=314&start=0

回复只看该作者道具举报

武汉-SSH

7^#

发表于 2012-8-24 01:30:29

问题最终定位在 CISCO ASA 防火墙的 SQLNet inspect，关闭就OK了。

回复只看该作者道具举报

武汉-SSH

6^#

发表于 2012-8-18 00:31:55

客户端trace

ora_10364_15132.zip (139.2 KB, 下载次数: 986)

回复只看该作者道具举报

武汉-SSH

5^#

发表于 2012-8-17 21:35:31

最新进展，在服务器端设置
To enable tracing at the server, find the sqlnet.ora file for the server and create the following lines in it:

TRACE_TIMESTAMP_SERVER = ON
TRACE_LEVEL_SERVER = 16
TRACE_UNIQUE_SERVER = ON

后，本来3113 的查询可以正常出来了，但是关闭trace后，又不正常了。

回复只看该作者道具举报

武汉-SSH

4^#

发表于 2012-8-17 16:55:51

目前定位于，PL/SQL DEV NAT后的数据库，31493 行的 ORA-3113，25463 行的正常返回。

回复只看该作者道具举报

武汉-SSH

3^#

发表于 2012-8-17 00:37:03

后续的验证，发现 sqldeveloper 3.0.04和 pl/sql developer 8.0.0.1483 在查询大表的时候都会报3113，唯有SQLPLUS 没问题。

回复只看该作者道具举报

武汉-SSH

2^#

发表于 2012-8-16 15:44:53

节点2

Wed Aug 15 03:00:42 2012
Thread 2 advanced to log sequence 571 (LGWR switch)
  Current log# 3 seq# 571 mem# 0: +DATA/orcl/onlinelog/group_3.265.766686179
Wed Aug 15 10:47:03 2012
Trace dumping is performing id=[cdmp_20120815104643]
Wed Aug 15 10:48:18 2012
Trace dumping is performing id=[cdmp_20120815104758]
Wed Aug 15 10:54:24 2012
Trace dumping is performing id=[cdmp_20120815105404]
Wed Aug 15 10:55:31 2012
Trace dumping is performing id=[cdmp_20120815105511]
Wed Aug 15 13:12:29 2012
Thread 2 advanced to log sequence 572 (LGWR switch)
  Current log# 4 seq# 572 mem# 0: +DATA/orcl/onlinelog/group_4.266.766686179
Wed Aug 15 14:19:38 2012
Trace dumping is performing id=[cdmp_20120815141918]
Wed Aug 15 22:00:10 2012
Thread 2 advanced to log sequence 573 (LGWR switch)
  Current log# 3 seq# 573 mem# 0: +DATA/orcl/onlinelog/group_3.265.766686179
Thu Aug 16 13:13:48 2012
Thread 2 advanced to log sequence 574 (LGWR switch)
  Current log# 4 seq# 574 mem# 0: +DATA/orcl/onlinelog/group_4.266.766686179

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册