我的一个oracle数据库 一天死一次！！！

[csl610]

这个是我的日志。找了好久不知道从何下手，请教高手！
Sat Dec 02 14:12:42 2006
Errors in file c:\oracl\ora92\admin\ora90\bdump\ora90_pmon_2604.trc:
ORA-00600: internal error code, arguments: [17114], [0x2BEFFEB], [], [], [], [], [], []

Sat Dec 02 14:13:25 2006
CKPT: terminating instance due to error 472
Instance terminated by CKPT, pid = 2448
Dump file c:\oracl\ora92\admin\ora90\bdump\alert_ora90.log
Sat Dec 02 16:09:54 2006
ORACLE V9.2.0.3.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Sat Dec 02 16:09:54 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.3.0.
System parameters with non-default values:
processes = 200
timed_statistics = TRUE
shared_pool_size = 536870912
sga_max_size = 965813244
large_pool_size = 8388608
java_pool_size = 134217728
control_files = D:\oracl\ora92\oradata\ora90\CONTROL01.CTL, D:\oracl\ora92\oradata\ora90\CONTROL02.CTL, D:\oracl\ora92\oradata\ora90\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 67108864
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora90
dispatchers = (PROTOCOL=TCP) (SERVICE=ora90XDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = C:\oracl\ora92\admin\ora90\bdump
user_dump_dest = C:\oracl\ora92\admin\ora90\udump
core_dump_dest = C:\oracl\ora92\admin\ora90\cdump
sort_area_size = 524288
db_name = ora90
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Sat Dec 02 16:09:57 2006
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Sat Dec 02 16:09:57 2006
alter database mount exclusive
Sat Dec 02 16:10:02 2006
Successful mount of redo thread 1, with mount id 2528463573.
Sat Dec 02 16:10:02 2006
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Sat Dec 02 16:10:02 2006
alter database open
Sat Dec 02 16:10:02 2006
Beginning crash recovery of 1 threads
Sat Dec 02 16:10:02 2006
Started first pass scan
Sat Dec 02 16:10:02 2006
Completed first pass scan
10947 redo blocks read, 265 data blocks need recovery
Sat Dec 02 16:10:02 2006
Started recovery at
Thread 1: logseq 111, block 115638, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 111 Reading mem 0
Mem# 0 errs 0: D:\ORACL\ORA92\ORADATA\ORA90\REDO02.LOG
Sat Dec 02 16:10:03 2006
Completed redo application
Sat Dec 02 16:10:04 2006
Ended recovery at
Thread 1: logseq 111, block 126585, scn 0.19175627
265 data blocks read, 265 data blocks written, 10947 redo blocks read
Crash recovery completed successfully
Sat Dec 02 16:10:04 2006
Thread 1 advanced to log sequence 112
Thread 1 opened at log sequence 112
Current log# 3 seq# 112 mem# 0: D:\ORACL\ORA92\ORADATA\ORA90\REDO03.LOG
Successful open of redo thread 1.
Sat Dec 02 16:10:04 2006
SMON: enabling cache recovery
Sat Dec 02 16:10:05 2006
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Sat Dec 02 16:10:05 2006
SMON: enabling tx recovery
Sat Dec 02 16:10:05 2006
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Sun Dec 03 00:55:54 2006
Thread 1 advanced to log sequence 113
Current log# 1 seq# 113 mem# 0: D:\ORACL\ORA92\ORADATA\ORA90\REDO01.LOG
Sun Dec 03 07:33:28 2006
CKPT: terminating instance due to error 472

[csl610]

里面有几个触发器。不知道是不是这个愿意。

[wiler]

试试：
重新创建控制文件，重新建立redo文件组

[jdsnhan]

ORA-00600 oracle的经典错误,也是最让人头痛的错误。造成这个错误的原因好多，但最终的结果近乎只有一个,没辙,重做。

[csl610]

唉。没有吧。。。。。。。

[tgm78]

是否是归档模式，参数设置的不对呢

SQL> archive log list
Database log mode Archive Mode ――归档模式
Automatic archival Enabled ――自动归档

当Database log mode为Archive Mode时，Automatic archival必须为Automatic archival

[csl610]

今天又死了一次。郁闷啊。
CKPT: terminating instance due to error

[liuyi8903]

怎么不能说一下版本啊.唉!

[wiler]

建议检查一下硬件，如硬盘是否异常等等

[火龙岛主]

不应该是硬件的问题,硬件不会定时发生问题。还是oracle的问题！
关键是：CKPT: terminating instance due to error 472
看看他是怎么说的：http://www.eygle.com/pdf/Ora-1157.Error.Correct.pdf

[liuyi8903]

并不是每个ora-00600错误都一样的.
在每个版本都不一定是样的.
因此类似这种错误最好是查metalink.
但是这两天上不去.没办法给你查.

如果我没有记错的话,应该需要打一个opatch或者patch set

[qiyousyc]

600错误一般是由系统或者硬件引起的.
你只能察看您的操作系统有什么毛病(不行重新安装操作系统)
如果想从oracle角度解决,就是升级oracle为新小版本(我原先的600错误就是这么处理的)