我的oracle每天都会莫名其妙的停掉,这是在从9.2.0.1升级到9.2.0.5之后频繁出现的,下面是alert_orcl.log日至的部分内容,哪位高人帮我看看啦.
Wed Dec 22 20:13:51 2004
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
Wed Dec 22 22:29:42 2004
Thread 1 advanced to log sequence 1247
Current log# 2 seq# 1247 mem# 0: /oradata/db/orcl/redo02.log
Wed Dec 22 22:29:42 2004
ARC0: Evaluating archive log 1 thread 1 sequence 1246
ARC0: Beginning to archive log 1 thread 1 sequence 1246
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1246.dbf'
Wed Dec 22 22:30:51 2004
ARC0: Completed archiving log 1 thread 1 sequence 1246
Wed Dec 22 22:50:44 2004
Thread 1 advanced to log sequence 1248
Current log# 4 seq# 1248 mem# 0: /oradata/db/orcl/redo04.log
Wed Dec 22 22:50:44 2004
ARC1: Evaluating archive log 2 thread 1 sequence 1247
ARC1: Beginning to archive log 2 thread 1 sequence 1247
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1247.dbf'
Wed Dec 22 22:51:52 2004
ARC1: Completed archiving log 2 thread 1 sequence 1247
Wed Dec 22 23:09:34 2004
Thread 1 advanced to log sequence 1249
Current log# 5 seq# 1249 mem# 0: /oradata/db/orcl/redo05.log
Wed Dec 22 23:09:34 2004
ARC0: Evaluating archive log 4 thread 1 sequence 1248
ARC0: Beginning to archive log 4 thread 1 sequence 1248
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1248.dbf'
Wed Dec 22 23:10:46 2004
ARC0: Completed archiving log 4 thread 1 sequence 1248
Wed Dec 22 23:29:29 2004
ARC1: Evaluating archive log 5 thread 1 sequence 1249
ARC1: Beginning to archive log 5 thread 1 sequence 1249
Wed Dec 22 23:29:29 2004
Thread 1 advanced to log sequence 1250
Wed Dec 22 23:29:29 2004
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1249.dbf'
Wed Dec 22 23:29:29 2004
Current log# 1 seq# 1250 mem# 0: /oradata/db/orcl/redo01.log
Wed Dec 22 23:30:46 2004
ARC1: Completed archiving log 5 thread 1 sequence 1249
Wed Dec 22 23:49:31 2004
Thread 1 advanced to log sequence 1251
Current log# 2 seq# 1251 mem# 0: /oradata/db/orcl/redo02.log
Wed Dec 22 23:49:31 2004
ARC0: Evaluating archive log 1 thread 1 sequence 1250
ARC0: Beginning to archive log 1 thread 1 sequence 1250
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1250.dbf'
Wed Dec 22 23:50:48 2004
ARC0: Completed archiving log 1 thread 1 sequence 1250
Thu Dec 23 00:05:49 2004
Errors in file /oradata/db/admin/orcl/bdump/orcl_dbw0_21859.trc:
ORA-00600: internal error code, arguments: [kslawe:!pwq], [0x456585518], [], [], [], [], [], []
Thu Dec 23 00:05:52 2004
Errors in file /oradata/db/admin/orcl/bdump/orcl_dbw0_21859.trc:
ORA-00600: internal error code, arguments: [kslawe:!pwq], [0x456585518], [], [], [], [], [], []
Thu Dec 23 00:05:52 2004
DBW0: terminating instance due to error 600
Instance terminated by DBW0, pid = 21859
如果需要我还可以把trc日志贴出来。我也查过网上的资料,说是oracle bug,可是要怎么解决就没讲到。还请各位好心路过一下下。
Wed Dec 22 20:13:51 2004
SMON offlining US=11
SMON offlining US=12
SMON offlining US=13
SMON offlining US=14
SMON offlining US=15
Wed Dec 22 22:29:42 2004
Thread 1 advanced to log sequence 1247
Current log# 2 seq# 1247 mem# 0: /oradata/db/orcl/redo02.log
Wed Dec 22 22:29:42 2004
ARC0: Evaluating archive log 1 thread 1 sequence 1246
ARC0: Beginning to archive log 1 thread 1 sequence 1246
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1246.dbf'
Wed Dec 22 22:30:51 2004
ARC0: Completed archiving log 1 thread 1 sequence 1246
Wed Dec 22 22:50:44 2004
Thread 1 advanced to log sequence 1248
Current log# 4 seq# 1248 mem# 0: /oradata/db/orcl/redo04.log
Wed Dec 22 22:50:44 2004
ARC1: Evaluating archive log 2 thread 1 sequence 1247
ARC1: Beginning to archive log 2 thread 1 sequence 1247
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1247.dbf'
Wed Dec 22 22:51:52 2004
ARC1: Completed archiving log 2 thread 1 sequence 1247
Wed Dec 22 23:09:34 2004
Thread 1 advanced to log sequence 1249
Current log# 5 seq# 1249 mem# 0: /oradata/db/orcl/redo05.log
Wed Dec 22 23:09:34 2004
ARC0: Evaluating archive log 4 thread 1 sequence 1248
ARC0: Beginning to archive log 4 thread 1 sequence 1248
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1248.dbf'
Wed Dec 22 23:10:46 2004
ARC0: Completed archiving log 4 thread 1 sequence 1248
Wed Dec 22 23:29:29 2004
ARC1: Evaluating archive log 5 thread 1 sequence 1249
ARC1: Beginning to archive log 5 thread 1 sequence 1249
Wed Dec 22 23:29:29 2004
Thread 1 advanced to log sequence 1250
Wed Dec 22 23:29:29 2004
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1249.dbf'
Wed Dec 22 23:29:29 2004
Current log# 1 seq# 1250 mem# 0: /oradata/db/orcl/redo01.log
Wed Dec 22 23:30:46 2004
ARC1: Completed archiving log 5 thread 1 sequence 1249
Wed Dec 22 23:49:31 2004
Thread 1 advanced to log sequence 1251
Current log# 2 seq# 1251 mem# 0: /oradata/db/orcl/redo02.log
Wed Dec 22 23:49:31 2004
ARC0: Evaluating archive log 1 thread 1 sequence 1250
ARC0: Beginning to archive log 1 thread 1 sequence 1250
Creating archive destination LOG_ARCHIVE_DEST_1: '/oradata/oraarch/orcl/archive/1_1250.dbf'
Wed Dec 22 23:50:48 2004
ARC0: Completed archiving log 1 thread 1 sequence 1250
Thu Dec 23 00:05:49 2004
Errors in file /oradata/db/admin/orcl/bdump/orcl_dbw0_21859.trc:
ORA-00600: internal error code, arguments: [kslawe:!pwq], [0x456585518], [], [], [], [], [], []
Thu Dec 23 00:05:52 2004
Errors in file /oradata/db/admin/orcl/bdump/orcl_dbw0_21859.trc:
ORA-00600: internal error code, arguments: [kslawe:!pwq], [0x456585518], [], [], [], [], [], []
Thu Dec 23 00:05:52 2004
DBW0: terminating instance due to error 600
Instance terminated by DBW0, pid = 21859
如果需要我还可以把trc日志贴出来。我也查过网上的资料,说是oracle bug,可是要怎么解决就没讲到。还请各位好心路过一下下。
[string], [string], [string], [string]
Cause: This is the generic internal error number for Oracle program exceptions.
It indicates that a process has encountered a low-level, unexpected condition.
Causes of this message include:
n timeouts
n file corruption
n failed data checks in memory
n hardware, memory, or I/O errors
n incorrectly restored files
The first argument is the internal message number. Other arguments are
various numbers, names, and character strings. The numbers may change
meanings between different versions of Oracle.
Action: Report this error to Oracle Support Services after gathering the
following information:
n events that led up to the error
n the operations that were attempted that led to the error
n the conditions of the operating system and databases at the time of the error
n any unusual circumstances that occurred before receiving the ORA-00600
message
n contents of any trace files generated by the error
n the relevant portions of the Alter files
Note: The cause of this message may manifest itself as different errors at
different times. Be aware of the history of errors that occurred before this
internal error.
但你可以:
把你的OS版本,客户端软件及版本,数据库连接方式(CS BS JDBC OCI.....),故障发生详情等等发上来,大家看看.....
有好心人的话,有可能把你的问题提交到ORACLE METALINK
Oracle数据库版本是9.2.0.1升级到9.2.0.5
发生这些问题的时候都是在夜里12点到凌晨3点之间,这个时候没有任何客户端连在数据库上,weblogic连在oracle上,但这个时候肯定没有人访问web的
但在oracle里面做了大约4.5个job,定时执行,我想有可能是这些job的问题