上周五遇到数据库遇到一个问题:除sys外其它用户都不能连接上去,连接中也不报错,陷入等待,shutdowm immediate也陷入等待,最后只得重启机器,今天又重现了这个情况
以下是从alter_sgeora.log文件系统出问题时间段里的日志:Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1266172.trc:
ORA-00600: internal error code, arguments: [ttclxx1], [3], [0], [], [], [], [], []
Sun Nov 29 00:30:33 2009
Thread 1 advanced to log sequence 36
Current log# 3 seq# 36 mem# 0: /dev/rlv_redo3_1
Current log# 3 seq# 36 mem# 1: /dev/rlv_redo3_2
Tue Dec 1 00:09:35 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1454490.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Dec 1 00:09:35 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1454490.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Dec 1 22:47:40 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1491334.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Dec 1 22:47:40 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1491334.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Wed Dec 2 10:06:29 2009
Thread 1 advanced to log sequence 37
Current log# 1 seq# 37 mem# 0: /dev/rlv_redo1_1
Current log# 1 seq# 37 mem# 1: /dev/rlv_redo1_2
Wed Dec 2 23:53:13 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1315208.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Wed Dec 2 23:53:13 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1315208.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Thu Dec 3 11:30:09 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1515842.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Thu Dec 3 11:30:09 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1515842.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Thu Dec 3 23:34:22 2009
ORACLE Instance sgeora - Can not allocate log, archival required哪位大哥,能帮我分析分析大概是什么问题引起的呢?
以下是从alter_sgeora.log文件系统出问题时间段里的日志:Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1266172.trc:
ORA-00600: internal error code, arguments: [ttclxx1], [3], [0], [], [], [], [], []
Sun Nov 29 00:30:33 2009
Thread 1 advanced to log sequence 36
Current log# 3 seq# 36 mem# 0: /dev/rlv_redo3_1
Current log# 3 seq# 36 mem# 1: /dev/rlv_redo3_2
Tue Dec 1 00:09:35 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1454490.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Dec 1 00:09:35 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1454490.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Dec 1 22:47:40 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1491334.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Tue Dec 1 22:47:40 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1491334.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Wed Dec 2 10:06:29 2009
Thread 1 advanced to log sequence 37
Current log# 1 seq# 37 mem# 0: /dev/rlv_redo1_1
Current log# 1 seq# 37 mem# 1: /dev/rlv_redo1_2
Wed Dec 2 23:53:13 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1315208.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Wed Dec 2 23:53:13 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1315208.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Thu Dec 3 11:30:09 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1515842.trc:
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Thu Dec 3 11:30:09 2009
Errors in file /ora_base/admin/sgeora/udump/sgeora_ora_1515842.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [12333], [0], [0], [0], [], [], [], []
Thu Dec 3 23:34:22 2009
ORACLE Instance sgeora - Can not allocate log, archival required哪位大哥,能帮我分析分析大概是什么问题引起的呢?
Cause
This could happens if a statement take a time and the process could have a timeout and died , the
error ora-600 means that the process dies or was killedSolution
The ora-600 [12333] error is only telling us that the client and server process communication was terminated due to some event.
This error is only affecting the session seeing the error and not the instance as a whole.
可知:
是由于应用程序异常死掉,或者异常断开。导致client 和server 断开。只影响当前的session , 不影响整个实例
你是什么版本的Oracle,最好写清楚一些
/ora_base/admin/sgeora/udump/sgeora_ora_1515842.trc/ora_base/admin/sgeora/udump/sgeora_ora_1315208.trc
如果数据库有备份的话,就把库清空重新建一遍吧。