Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

316

积分

0

好友

0

主题
1#
发表于 2012-8-16 15:17:22 | 查看: 6250| 回复: 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, 下载次数: 758)
bbb.zip (807.15 KB, 下载次数: 967)

[ 本帖最后由 武汉-SSH 于 2012-8-16 15:38 编辑 ]
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

回复 只看该作者 道具 举报

3#
发表于 2012-8-17 00:37:03
后续的验证,发现 sqldeveloper 3.0.04和 pl/sql developer 8.0.0.1483 在查询大表的时候都会报3113,唯有SQLPLUS 没问题。

回复 只看该作者 道具 举报

4#
发表于 2012-8-17 16:55:51
目前定位于,PL/SQL DEV NAT后的数据库,31493 行的 ORA-3113,25463 行的 正常返回。

回复 只看该作者 道具 举报

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后,又不正常了。

回复 只看该作者 道具 举报

6#
发表于 2012-8-18 00:31:55
客户端trace

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

回复 只看该作者 道具 举报

7#
发表于 2012-8-24 01:30:29
问题最终定位在 CISCO ASA 防火墙的 SQLNet inspect,关闭就OK了。

回复 只看该作者 道具 举报

8#
发表于 2012-8-24 11:12:02
坚持精神 可敬, 加下精华


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

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-25 15:33 , Processed in 0.055420 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569