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
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
Mon Apr 18 14:54:14 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
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Instance name: qhdmccRedo thread mounted by this instance: 1Oracle process number: 17Windows thread id: 2172, image: ORACLE.EXE
*** 2011-04-18 14:54:14.000
*** SESSION ID:(16.41) 2011-04-18 14:54:14.000
********** Internal heap ERROR 17112 addr=1E0BFFEB *********
***** Dump of memory around addr 1E0BFFEB:
1E0BFDE0 00000000 00000000 [........]
1E0BFDF0 00000000 00000000 00000000 1E0BFE74 [............t...]
1E0BFE00 00000010 00000004 1E0BFE5C 00000010 [........\.......]
1E0BFE10 00000004 00000000 00000000 00000000 [................]
1E0BFE20 00000000 00000000 00000000 1E0BFE98 [................]
1E0BFE30 00000000 00000000 00000000 1E0BFE3C [............<...]
1E0BFE40 1E0BFE3C 00000000 00000004 00000001 [<...............]
1E0BFE50 1E0BFCDC 0000000C 00000001 1DFF3A84 [.............:..]
1E0BFE60 00000000 00000000 00000000 1C38E500 [..............8.]
1E0BFE70 1C38E500 1DFF3A38 00000000 00000000 [..8.8:..........]
1E0BFE80 00000000 00000000 00000000 1000004D [............M...]
1E0BFE90 1E0BFDC8 028250D0 1E0BFE3C 00000000 [.....P..<.......]
1E0BFEA0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1E0BFED0 00000000 00000000 00000061 1E0BFCA8 [........a.......]
1E0BFEE0 2AC59CFC 1E299448 00000224 1E0BFCDC [...*H.).$.......]
1E0BFEF0 1E0BFCC4 00000000 00000000 00000000 [................]
1E0BFF00 06010209 00000000 00000224 7262696C [........$...libr]
1E0BFF10 20797261 68636163 00000065 00107FFF [ary cache.......]
1E0BFF20 7FFF7FFF 00000301 00000000 1E0BFCD4 [................]
1E0BFF30 1E0BFCD4 01FE1250 000002FD 1E0BFED8 [....P...........]
1E0BFF40 034F02BC 1E23FEF4 1E1B095C 400002B1 [..O...#.\......@]
1E0BFF50 00000000 1E1B0964 000002B0 80000002 [....d...........]
1E0BFF60 00020002 00020002 00000016 01008100 [................]
1E0BFF70 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1E0BFFA0 00000000 00000004 00000000 00000000 [................]
1E0BFFB0 00000000 00000000 0000AA4F 80000002 [........O.......]
1E0BFFC0 00090009 00020009 00000016 01008100 [................]
1E0BFFD0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1E0C0000 00000000 00000004 00000000 00000000 [................]
1E0C0010 00000000 00000000 0000AA4F 00000000 [........O.......]
1E0C0020 00030003 00010003 00640064 00000000 [........d.d.....]
1E0C0030 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
1E0C0050 00000000 00000000 00000000 00010354 [............T...]
1E0C0060 00000000 00000000 00000000 00000000 [................]
1E0C0070 00000000 00000000 0000AA4F 80000002 [........O.......]
1E0C0080 00040004 00010004 00C800C8 01000000 [................]
1E0C0090 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
1E0C00B0 00000000 00000000 00000000 00010354 [............T...]
1E0C00C0 00000000 00000004 00000000 00000000 [................]
1E0C00D0 00000000 00000000 0000AA4F 80000002 [........O.......]
1E0C00E0 00050005 00020005 00000016 01008100 [................]
1E0C00F0 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
1E0C0120 00000000 00000004 00000000 00000000 [................]
1E0C0130 00000000 00000000 0000AA4F 00000000 [........O.......]
1E0C0140 00060006 00010006 01F401F4 00000000 [................]
1E0C0150 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
1E0C0170 00000000 00000000 00000000 00010354 [............T...]
1E0C0180 00000000 00000000 00000000 00000000 [................]
1E0C0190 00000000 00000000 0000AA4F 00000000 [........O.......]
1E0C01A0 00070007 00010007 01F401F4 00000000 [................]
1E0C01B0 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
1E0C01D0 00000000 00000000 00000000 00010354 [............T...]
1E0C01E0 00000000 00000000 00000000 [............]
Recovery state: ds=034F02BC rtn=00000000 *rtn=00000000 szo=0 u4o=0 hdo=0 off=0
Szo:
UB4o:
Hdo:
Off:
Hla: 1
******************************************************
HEAP DUMP heap name="sga heap(1,0)" desc=034F02BC
extent sz=0xfc4 alt=100 het=32767 rec=9 flg=-126 opc=0
parent=00000000 owner=00000000 nex=00000000 xsz=0x1
EXTENT 0 addr=2B000000
Chunk 2b000024 sz= 20 R-freeable "reserved stoppe"
Chunk 2b000038 sz= 73988 R-perm "perm " alo=73988
Chunk 2b01213c sz= 189540 R-free " "
Chunk 2b0405a0 sz= 19204 R-freeable "session param v"
Chunk 2b0450a4 sz= 17724 R-free " "
Chunk 2b0495e0 sz= 19204 R-freeable "session param v"
Chunk 2b04e0e4 sz= 19204 R-freeable "session param v"
Chunk 2b052be8 sz= 7184 R-freeable "modificaton ha "
Chunk 2b0547f8 sz= 7184 R-freeable "modificaton ha "
Chunk 2b056408 sz= 7184 R-freeable "modificaton ha "
Chunk 2b058018 sz= 17136 R-free " "
Chunk 2b05c308 sz= 7184 R-freeable "modificaton ha "
Chunk 2b05df18 sz= 4704 R-free " "
Chunk 2b05f178 sz= 188 R-recreate "KGL handles " latch=2A70B03C
Chunk 2b05f234 sz= 5796 R-free " "
Chunk 2b0608d8 sz= 19204 R-freeable "session param v"
Chunk 2b0653dc sz= 7184 R-freeable "modificaton ha "
Chunk 2b066fec sz= 20 R-freeable "reserved stoppe"
Chunk 2b067000 sz= 7958648 perm "perm " alo=7958648
Chunk 2b7fe078 sz= 3568 freeable "sim memory hea " ds=01FEEF88
Subject: ORA-600 [17112] “Internal Heap Error”
Doc ID: Note:47411.1 Type: REFERENCE