ora-00600 求助!!!
Mon Apr 18 14:54:26 2011
Errors in file d:\oracle\admin\qhdmcc\udump\qhdmcc_ora_2172.trc:
ORA-00600: 内部错误代码，参数: [17112], [0x1E0BFFEB], [], [], [], [], [], []
---------出错后oracle 当机 重起服务
Dump file d:\oracle\admin\qhdmcc\bdump\alert_qhdmcc.log
Mon Apr 18 14:58:37 2011
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Mon Apr 18 14:58:37 2011
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.1.0.
System parameters with non-default values:
processes = 800
timed_statistics = TRUE
shared_pool_size = 419430400
sga_max_size = 1611737088
large_pool_size = 159383552
java_pool_size = 159383552
control_files = D:\oracle\oradata\qhdmcc\CONTROL01.CTL, D:\oracle\oradata\qhdmcc\CONTROL02.CTL, D:\oracle\oradata\qhdmcc\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 318767104
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 = qhdmcc
dispatchers = (PROTOCOL=TCP) (SERVICE=qhdmccXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\qhdmcc\bdump
user_dump_dest = D:\oracle\admin\qhdmcc\udump
core_dump_dest = D:\oracle\admin\qhdmcc\cdump
sort_area_size = 524288
db_name = qhdmcc
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 104857600
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
Mon Apr 18 14:58:40 2011
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Apr 18 14:58:40 2011
alter database mount exclusive
Mon Apr 18 14:58:45 2011
Successful mount of redo thread 1, with mount id 4213484641.
Mon Apr 18 14:58:45 2011
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Apr 18 14:58:45 2011
alter database open
Mon Apr 18 14:58:45 2011
Beginning crash recovery of 1 threads
Mon Apr 18 14:58:45 2011
Started first pass scan
Mon Apr 18 14:58:45 2011
Completed first pass scan
5425 redo blocks read, 219 data blocks need recovery
Mon Apr 18 14:58:45 2011
Started recovery at
Thread 1: logseq 38865, block 183989, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 2 Seq 38865 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\QHDMCC\REDO02.LOG
Mon Apr 18 14:58:46 2011
Ended recovery at
Thread 1: logseq 38865, block 189414, scn 1278.2173570471
219 data blocks read, 219 data blocks written, 5425 redo blocks read
Crash recovery completed successfully
Mon Apr 18 14:58:46 2011
Thread 1 advanced to log sequence 38866
Thread 1 opened at log sequence 38866
Current log# 3 seq# 38866 mem# 0: D:\ORACLE\ORADATA\QHDMCC\REDO03.LOG
Successful open of redo thread 1.
Mon Apr 18 14:58:46 2011
SMON: enabling cache recovery
Mon Apr 18 14:58:46 2011
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.
Mon Apr 18 14:58:46 2011
SMON: enabling tx recovery
Mon Apr 18 14:58:46 2011
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
[解决办法]
这个要查查metalink了
Subject: ORA-600 [17112] “Internal Heap Error”
Doc ID: Note:47411.1 Type: REFERENCE
[解决办法]
ora-600多数都是bug导致的。
如果是10g，解决办法有三个:
1。设置optimizer_features_enable=9.2.0
或者
2.打上oracle的补丁patch 5694466 ;
或者
3。在你的view sql语句中添加hint： NO_UNNEST
参考：http://topic.csdn.net/u/20081105/16/fe77b355-aea2-4993-866d-aec98ba551e6.html
