Hi,
We're having some problems. The db seems to have started up
but an attempt to connect gives a listener error ORA-12541
We have ORA-00600 errors in the alert log. Attached is the entry
in the alert_emprod.log. what can we do ?
Tia,
Andreas
Dump file c:\oracle\admin\emprod\bdump\alert_emprod.log
Mon Sep 12 13:01:14 2005
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Mon Sep 12 13:01:14 2005
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.4.0.
System parameters with non-default values:
processes = 1500
timed_statistics = TRUE
shared_pool_size = 503316480
large_pool_size = 100663296
java_pool_size = 16777216
resource_manager_plan = EMPROD_DAY
control_files = D:\oracle\oradata\emprod\control01.ctl,
E:\oracle\oradata\emprod\control02.ctl,
F:\oracle\oradata\emprod\control03.ctl
db_block_size = 8192
db_cache_size = 2105540608
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 = emprod
dispatchers = (PROTOCOL=TCP)
hash_join_enabled = TRUE
background_dump_dest = C:\oracle\admin\emprod\bdump
user_dump_dest = C:\oracle\admin\emprod\udump
core_dump_dest = C:\oracle\admin\emprod\cdump
sort_area_size = 524288
db_name = emprod
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 100000000
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
Mon Sep 12 13:01:17 2005
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address
'(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon Sep 12 13:01:18 2005
alter database mount exclusive
Mon Sep 12 13:01:22 2005
Successful mount of redo thread 1, with mount id 77357854.
Mon Sep 12 13:01:22 2005
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon Sep 12 13:01:22 2005
alter database open
Mon Sep 12 13:01:22 2005
Beginning crash recovery of 1 threads
Mon Sep 12 13:01:22 2005
Started first pass scan
Mon Sep 12 13:01:22 2005
Completed first pass scan
257 redo blocks read, 65 data blocks need recovery
Mon Sep 12 13:01:22 2005
Started recovery at
Thread 1: logseq 2509, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2509 Reading mem 0
Mem# 0 errs 0: F:\ORACLE\ORADATA\EMPROD\REDO01.LOG
Mon Sep 12 13:01:22 2005
Completed redo application
Mon Sep 12 13:01:22 2005
Ended recovery at
Thread 1: logseq 2509, block 260, scn 0.84192994
65 data blocks read, 65 data blocks written, 257 redo blocks read
Crash recovery completed successfully
Mon Sep 12 13:01:22 2005
Thread 1 advanced to log sequence 2510
Thread 1 opened at log sequence 2510
Current log# 2 seq# 2510 mem# 0: F:\ORACLE\ORADATA\EMPROD\REDO02.LOG
Successful open of redo thread 1.
Mon Sep 12 13:01:23 2005
SMON: enabling cache recovery
Mon Sep 12 13:01:23 2005
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 Sep 12 13:01:23 2005
SMON: enabling tx recovery
Mon Sep 12 13:01:23 2005
Database Characterset is WE8MSWIN1252
replication_dependency_tracking turned off (no async multimaster
replication found)
Completed: alter database open
Mon Sep 12 13:01:24 2005
Errors in file c:\oracle\admin\emprod\udump\emprod_p002_2032.trc:
ORA-00600: internal error code, arguments: [ktbair1], [1], [2], [], [],
[], [], []
Mon Sep 12 13:01:26 2005
Errors in file c:\oracle\admin\emprod\udump\emprod_p002_2032.trc:
ORA-00600: internal error code, arguments: [17114], [0x5F59003C], [],
[], [], [], [], []
ORA-00600: internal error code, arguments: [ktbair1], [1], [2], [], [],
[], [], []
This is an exerpt of the trc :
Dump file c:\oracle\admin\emprod\udump\emprod_p002_2032.trc
Mon Sep 12 13:01:24 2005
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: emprod
Redo thread mounted by this instance: 1
Oracle process number: 13
Windows thread id: 2032, image: ORACLE.EXE (P002)
- SESSION ID:(8.5) 2005-09-12 13:01:24.868
- 2005-09-12 13:01:24.868
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [ktbair1], [1], [2], [], [],
[], [], []
----- Call Stack Trace -----
calling call entry argument values in
hex
location type point (? means dubious
value)
-------------------- -------- --------------------
_ksedmp+327 CALLrel _ksedst+0
_ksfdmp.108+14 CALLrel _ksedmp+0 3
027174D3 CALLreg 00000000 5F0C1190 3
026ABCC3 CALLrel 02717450 5F0C1190 37A353C
268B390 2
6123D504
__VInfreq__ktbair+1 CALLrel _kgeasnmierr+0 5F0C1190 37A353C
268B390 2 4
72 1 4 2
_kdoirp+874 CALLrel _ktbair+0 8013C014 A 37A6354
1C 2
_kcoapl+479 CALLreg 00000000 37ACAC4 37ACEFE 2
8013C014
_kcbapl+113 CALLrel _kcoapl+0 37ACAC0 8013C000 1 7
2000
_kcrfwr+1812 CALLrel _kcbapl+0 37ACAC0 807D9408
6123D98C
_kcbchg1+2027 CALLrel _kcrfwr+0
_kcbchg+98 CALLrel _kcbchg1+0 8 2 6123DBD4
6123DBF0 0 0
_ktuapundo+352 CALLrel _kcbchg+0 8 2 6123EBE8 37ACAC0
6123E62C
6123DC60 0 0
_ktbapundo+47 CALLrel _ktuapundo+0 6123EBE8 37ACAC0 0 0
6123DF78
124 1 0 0
__VInfreq__kdoiur+1 CALLrel _ktbapundo+0 6123EBE0 37ACAC0 0 0
6123DF78
81 124 1 0 0
_kcoubk+113 CALLreg 00000000 6123DFA4 37A6338 2
124 0
6123DF78 6123E43C
..1.24_7.filter.101 CALLrel _kcoubk+0 6123DE6C 6123DFA4
37A6338 2
+317 124 0 6123DF78
6123E43C
..1.45_8.filter.101 CALLrel _ktundo+0 1 807718 37A6334 6C
172C
+1064 73765EE8 124
6123E62C
6123E588 6123E6C0
10F0 0 11
6123EBE0
_ktprundo_intra+786 CALLrel _kturbl+0 73765EE8 6123EC74
_ktprits+619 CALLrel _ktprundo_intra+0 73765E44 73751598
_ktprmai+152 CALL??? 00000000
_kxfprdp+1171 CALL??? 00000000
_opirip+787 CALLrel _kxfprdp+0
_opidrv+654 CALLrel _opirip+0 32 0 0
_sou2o+25 CALLrel _opidrv+0
_opimai+336 CALLrel _sou2o+0 6123FE1C 32 0 0
_BackgroundThreadSt CALLrel _opimai+0
art_at_4+356
7C57B385 CALLreg 00000000
- Binary Stack Dump ---------------------
- FRAME [1] (_ksedmp+327 -> _ksedst+0) ==========
Dump of memory from 0x6123D42C to 0x6123D4A4
6123D420 6123D4A4 [..#a]
6123D430 006A7588 00000000 00000000 00000000 [.uj.............]
6123D440 00000000 5F0C1274 0268B390 00000002 [....t.._..h.....]
6123D450 FFFFFFFF 000007E8 6123D4A0 027173FA [..........#a.sq.]
6123D460 5F0C126C 5F0C1274 00000000 00000000 [l.._t.._........]
6123D470 0268B390 00000002 00000007 5F0C1190 [..h............_]
6123D480 037A353C 019B2880 5F0C1008 6123D438 [<5z..(....._8.#a]
6123D490 5F0C1190 6123E50C 014AA6C0 02669D74 [..._..#a..J.t.f.]
6123D4A0 FFFFFFFF [....]
- FRAME [2] (_ksfdmp.108+14 -> _ksedmp+0) ==========
Dump of memory from 0x6123D4A4 to 0x6123D4B0
6123D4A0 6123D4B0 007E8AE7 00000003 [..#a..~.....]
- FRAME [3] (027174D3 -> 00000000) ==========
Dump of memory from 0x6123D4B0 to 0x6123D4D0
6123D4B0 6123D4D0 027174D5 5F0C1190 00000003 [..#a.tq...._....]
6123D4C0 8013C5FC 037A6354 0000000A 8013C014 [....Tcz.........]
- FRAME [4] (026ABCC3 -> 02717450) ==========
Dump of memory from 0x6123D4D0 to 0x6123D4EC
6123D4D0 6123D4EC 026ABCC8 5F0C1190 037A353C [..#a..j...._<5z.]
6123D4E0 0268B390 00000002 6123D504 [..h.......#a]
- FRAME [5] (__VInfreq__ktbair+172 -> _kgeasnmierr+0)
Dump of memory from 0x6123D4EC to 0x6123D53C
6123D4E0 6123D53C [<.#a]
6123D4F0 018CFCB1 5F0C1190 037A353C 0268B390 [......._<5z...h.]
6123D500 00000002 00000004 00000001 00000004 [................]
6123D510 00000002 00000001 0000000A 60574640 [............_at_FW`]
6123D520 8013C014 5F0C1008 00000002 8013C104 [......._........]
6123D530 000000F0 00000001 00000002 [............]
- FRAME [6] (_kdoirp+874 -> _ktbair+0) ==========
Dump of memory from 0x6123D53C to 0x6123D5B8
6123D530 6123D5B8 [..#a]
6123D540 005DA90B 8013C014 0000000A 037A6354 [..].........Tcz.]
6123D550 0000001C 00000002 05265C00 00000000 [.........\&.....]
6123D560 6123D628 3C773000 149E2122 00000000 [(.#a.0w<"!......]
6123D570 037ACEE4 5F0C1008 8013C000 00000002 [..z...._........]
6123D580 00000000 00000044 00000000 000000F0 [....D...........]
6123D590 00000001 5F0C1008 00000020 00000000 [......._ .......]
6123D5A0 00000000 8013C154 00001F40 6123D600 [....T...@.....#a]
6123D5B0 037A6370 00000214 [pcz.....]
- FRAME [7] (_kcoapl+479 -> 00000000) ==========
Dump of memory from 0x6123D5B8 to 0x6123D620
6123D5B0 6123D620 0045AD82 [ .#a..E.]
6123D5C0 037ACAC4 037ACEFE 00000002 8013C014 [..z...z.........]
6123D5D0 6FF1CDF8 00000000 6123D860 00000002 [...o....`.#a....]
6123D5E0 6FF1CD54 807D94B8 5F0C1008 807D9408 [T..o..}...._..}.]
6123D5F0 6123D98C 6FF1CD00 5F0C1008 6123D64C [..#a...o..._L.#a]
6123D600 050138F4 00000000 037ACAC4 00000000 [.8........z.....]
6123D610 01AB25CC 01AB25B8 6123D860 5F0C1008 [.%...%..`.#a..._]
- FRAME [8] (_kcbapl+113 -> _kcoapl+0) ==========
Dump of memory from 0x6123D620 to 0x6123D64C
6123D620 6123D64C 0045AB2E 037ACAC0 8013C000 [L.#a..E...z.....]
6123D630 00000001 00000007 00002000 6FF48554 [......... ..T..o]
6123D640 00000002 6123D860 00000001 [....`.#a....]
- FRAME [9] (_kcrfwr+1812 -> _kcbapl+0) ==========
Dump of memory from 0x6123D64C
etcetera....
Received on Mon Sep 12 2005 - 06:51:57 CDT