-
Server:MS win 2000
ORacle 8.1.7.2.1
The SMON crashed due to ora 600 and the database went down, now I am not able to bring the database up. I tried rebooting the server to release memory, but still again the SMON crashed when trying to open the database. I have logged a tar with Metalink but the response is slow. Please help any advice.
Here's the error I get in the alert log:
Errors in file C:\mnt\ora_system\oracle\admin\dev1\bdump\dev1SMON.TRC:
ORA-00600: internal error code, arguments: [kcbrbr_2], [3], [16782730], [8], [], [], [], []
Thanx a lot.
-
here's a part of what's there on the SMON trace:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kcbrbr_2], [3], [16782730], [8], [], [], [], []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
E0E44C
_ksfdmp+e CALLrel _ksedmp+0 3
_kgerinv+8e CALLreg 00000000
7D190
3
_kgeasnmierr+19 CALLrel _kgerinv+0
C54B8
FE4CD58
E7F644
3
FE0E5BC
_kcbrbr+85 CALLrel _kgeasnmierr+0
7D190
FE4CD58
E7F644
3 0 3
0
100158A
0 8
_ktssdro_segment+59f CALLrel _kcbrbr+0 3
100158A
8
_ktssdt_segs+184 CALLrel _ktssdro_segment+0
AA3F44
60D7550
_ktmmon+c03 CALLrel _ktssdt_segs+0 0
7FFFFFFF
7FFFFFFF
0
_ksbrdp+1b6 CALLreg 00000000
3C2698
_opirip+234 CALLrel _ksbrdp+0
_opidrv+549 CALLrel _opirip+0 32 0
0
_sou2o+19 CALLrel _opidrv+0
_opimai+152 CALLrel _sou2o+0
E0FE2C
32 0
0
_BackgroundThreadStart@4+127 CALLrel _opimai+0 3
FE0FF78
77E87587 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=fe0e44c.
Dump of memory from 0xFE0E40C to 0xFE0E54C
FE0E400 00000003 [....]
FE0E410 00000000 65522100 00000033 00000000 [.....!Re3.......]
FE0E420 00000003 0FE0E3E1 00000000 00000000 [................]
FE0E430 00000000 0017D008 00000000 0000001D [................]
FE0E440 0FE0E458 0041E6D4 00000001 00E291BC [X.....A.........]
FE0E450 00E291BC 00E291DC 00E291BC 00E291BC [................]
FE0E460 00E291BC 00E291BC 00E291BC 00E291C4 [................]
FE0E470 00E291BC 00E291BC 00E291BC 00E291BC [................]
FE0E480 00E291BC 00E291C4 0FE0E498 0000001C [................]
FE0E490 0017D008 00000003 2A2A2A0A 30303220 [.........*** 200]
FE0E4A0 31302D32 2034322D 313A3332 39323A35 [2-01-24 23:15:29]
FE0E4B0 32332D25 2D252073 25207338 7332332D [%-32s %-8s %-32s]
FE0E4C0 00000020 00000000 0FE4E2F8 0FE0E4A0 [ ...............]
FE0E4D0 30454620 38374646 25200000 7332332D [ FE0FF78.. %-32s]
FE0E4E0 342D2520 00000A73 000007E0 65522108 [ %-4s........!Re]
FE0E4F0 00170033 00000000 00000000 0017D5B5 [3...............]
FE0E500 00000000 00000000 00000000 0FE0FFEC [................]
FE0E510 00000000 0FE0FF78 00000000 00000001 [....x...........]
FE0E520 00000001 00000000 0FE0DE74 0000000C [........t.......]
FE0E530 0FE0E558 0047894D 0FE0E488 0FE4CD58 [X...M.G.....X...]
FE0E540 0017D190 0017D204 0017D204 [............]
Argument/Register addr=17d190.
Dump of memory from 0x17D150 to 0x17D290
17D150 0017D150 0017D150 0004000C 0017D15C [P...P.......\...]
17D160 0017D15C 0008000C 0017D168 0017D168 [\.......h...h...]
17D170 0020000C 0017D174 0017D174 0FE4F1E8 [.. .t...t.......]
17D180 0FE78344 0FE7C5A0 00000000 00000000 [D...............]
17D190 013B85B0 0FE4F310 0017D060 00000000 [..;.....`.......]
17D1A0 0FE47B80 0FE710FC 00181480 00000000 [.{..............]
17D1B0 0FE47BE0 0FE47644 00000000 00000000 [.{..Dv..........]
17D1C0 00000001 00000000 00000000 00000000 [................]
17D1D0 00000000 00000000 00000000 00E6AE78 [............x...]
17D1E0 00001000 00000000 00000000 00000000 [................]
17D1F0 0000000C 00000010 00000000 0FE4CD58 [............X...]
17D200 0FE4CC30 0FE0EF58 00000000 0FE4CD58 [0...X.......X...]
17D210 00000002 00000258 0017D590 00000004 [....X...........]
17D220 00000026 00000000 00000000 00000000 [&...............]
17D230 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
Argument/Register addr=ec54b8.
Dump of memory from 0xEC5478 to 0xEC55B8
EC5470 6F6C2042 6F746163 [B locato]
EC5480 70732072 66696365 3A646569 41524F20 [r specified: ORA]
EC5490 3232322D 00003537 0041E6A0 0041E6E0 [-22275....A...A.]
EC54A0 00CA9CF4 004E6FA0 007B3D60 007B3D80 [.....oN.`={..={.]
EC54B0 007B3DA0 007B3DC0 0041E6A0 007B34E0 [.={..={...A..4{.]
EC54C0 007B3500 007B3520 007B3530 00000000 [.5{. 5{.05{.....]
EC54D0 00000000 007B3550 007B35F0 007B3620 [....P5{..5{. 6{.]
EC54E0 007B36D0 007B38C0 007B38F0 007B3970 [.6{..8{..8{.p9{.]
EC54F0 007B3990 007B3A30 007B3A70 007B3A80 [.9{.0:{.p:{..:{.]
EC5500 007B3A90 007B3AB0 007B3AD0 007B3BC0 [.:{..:{..:{..;{.]
EC5510 007B3C00 007B3CF0 0047AF10 007B37B0 [.<{..<{...G..7{.]
EC5520 007B37D0 000003F5 00000259 007B37F0 [.7{.....Y....7{.]
EC5530 007B3820 007B3840 007B3880 00E48598 [ 8{.@8{..8{.....]
EC5540 00000150 00EC5498 00000000 00000000 [P....T..........]
EC5550 000001B8 000000A4 00000070 00000034 [........p...4...]
EC5560 00000024 007B38A0 00000068 007B3730 [$....8{.h...07{.]
EC5570 00539A20 00675640 00675640 00675640 [ .S.@Vg.@Vg.@Vg.]
EC5580 00675640 00675640 00675640 00AC8D80 [@Vg.@Vg.@Vg.....]
EC5590 00675640 00675640 00675640 00AC7C10 [@Vg.@Vg.@Vg..|..]
EC55A0 00AC7820 00675640 00675640 00000000 [ x..@Vg.@Vg.....]
EC55B0 004723B0 00CB26C0 [.#G..&..]
Argument/Register addr=fe4cd58.
Dump of memory from 0xFE4CD18 to 0xFE4CE58
FE4CD10 00000000 00000000 [........]
FE4CD20 00000000 00000000 00000000 00000000 [................]
FE4CD30 00000000 0662C1A8 00181438 00000000 [......b.8.......]
FE4CD40 00000000 00000000 00000000 00000000 [................]
FE4CD50 00000000 00000000 0FE4CD80 0FE4CF1C [................]
FE4CD60 00000258 0000025B 00000000 00000000 [X...[...........]
FE4CD70 00000000 00000000 0FE4D814 0FE4D818 [................]
FE4CD80 00000094 00000294 00000394 00000694 [................]
FE4CD90 0032007F 00010032 00000001 00000000 [..2.2...........]
FE4CDA0 007F0000 007F007F 007F007F 007F007F [................]
FE4CDB0 02820676 2C2E2C2E 0000242C 00000000 [v....,.,,$......]
FE4CDC0 00000000 00000001 0000002D 00000000 [........-.......]
FE4CDD0 00000000 00000001 00000000 00000000 [................]
FE4CDE0 00000000 00000000 4D2D4444 522D4E4F [........DD-MON-R]
FE4CDF0 00000052 00000000 00000000 00000000 [R...............]
FE4CE00 00000000 00000000 00000009 2C2E2C2E [.............,.,]
FE4CE10 0000242C 00000000 00000000 00240000 [,$............$.]
FE4CE20 00000000 00000000 007F0100 2016180E [............... ]
FE4CE30 00000001 0032007F 007F0000 007F007F [......2.........]
FE4CE40 007F007F 0000007F 00000000 00000000 [................]
FE4CE50 00000000 00000000 [........]
Argument/Register addr=e7f644.
Dump of memory from 0xE7F604 to 0xE7F744
E7F600 20646E65 64206F74 20727762 [end to dbwr ]
E7F610 66206425 305B7862 64253D5D 0000000A [%d fbx[0]=%d....]
E7F620 6962636B 755F6D73 6F6E6B6E 745F6E77 [kcbism_unknown_t]
E7F630 00657079 00000000 7262636B 315F7262 [ype.....kcbrbr_1]
E7F640 00000000 7262636B 325F7262 00000000 [....kcbrbr_2....]
E7F650 7262636B 00316F62 7262636B 00326F62 [kcbrbo1.kcbrbo2.]
E7F660 00004F52 7262636B 6B5F6F62 65677173 [RO..kcbrbo_ksqge]
E7F670 61665F74 00006C69 6362636B 00316F62 [t_fail..kcbcbo1.]
E7F680 6362636B 00326F62 656C6966 6E692073 [kcbcbo2.files in]
E7F690 62617420 7073656C 00656361 74706B63 [ tablespace.ckpt]
E7F6A0 6C69665F 203A7365 253D7374 666E2064 [_files: ts=%d nf]
E7F6B0 3D736C69 000A6425 74706B63 6E6F645F [ils=%d..ckpt_don]
E7F6C0 74203A65 64253D73 69666E20 253D736C [e: ts=%d nfils=%]
E7F6D0 00000A64 00000000 72727543 20746E65 [d.......Current ]
E7F6E0 3A414252 00000000 6C62636B 5F726269 [RBA:....kcblibr_]
E7F6F0 72657375 756F665F 0000646E 00000000 [user_found......]
E7F700 73676B73 0072666C 6374614C 6F6E5F68 [skgslfr.Latch_no]
E7F710 65685F74 0000646C 7262636B 315F7473 [t_held..kcbrst_1]
E7F720 00000000 00000000 7262636B 315F6172 [........kcbrra_1]
E7F730 00000000 7262636B 335F6172 00000000 [....kcbrra_3....]
E7F740 72727543 [Curr]
Argument/Register addr=fe0e5bc.
Dump of memory from 0xFE0E57C to 0xFE0E6BC
FE0E570 00000000 [....]
FE0E580 0FE0E5A4 6003D9FE 00EC54B8 0FE4CD58 [.......`.T..X...]
FE0E590 00E7F644 00000003 0FE0E5BC 00000003 [D...............]
FE0E5A0 0100158A 0FE0E5E0 005CBD5A 0017D190 [........Z.\.....]
FE0E5B0 0FE4CD58 00E7F644 00000003 00000000 [X...D...........]
FE0E5C0 00000003 00000000 0100158A 00000000 [................]
FE0E5D0 00000008 06A60894 00000001 0017D008 [................]
FE0E5E0 0FE0E778 006E5EF4 00000003 0100158A [x....^n.........]
FE0E5F0 00000008 00000001 067A99BC 00000000 [..........z.....]
FE0E600 00000000 0FE0E6D8 004CDFBE 00000000 [..........L.....]
FE0E610 0FE0E69C 00000000 00000000 00000000 [................]
FE0E620 00000000 0FE0E71C 0FE0E6F4 0017D008 [................]
FE0E630 00000000 0017D204 0FE0EF58 0FE0E404 [........X.......]
FE0E640 00000000 0FE0E700 0FE0E410 00000000 [................]
FE0E650 0FE0E74C 00CB3E70 00DF5968 FFFFFFFF [L...p>..hY......]
FE0E660 0FE0E75C 004CDFB0 066F2DDC 00000000 [\.....L..-o.....]
FE0E670 0FE0E6CC 00000002 0FE0E6EC 0F00E6CC [................]
FE0E680 0017D008 00000000 0FE0E75C 004CDFBE [........\.....L.]
FE0E690 00000000 0FE0E720 00000001 00000000 [.... ...........]
FE0E6A0 00000000 0FE7219C 00000000 00000000 [.....!..........]
FE0E6B0 00000016 00000000 0017D204 [............]
Argument/Register addr=100158a.
Dump of memory from 0x100154A to 0x100168A
1001540 5341524C 00000A47 [LRASG...]
1001550 53524550 00004E4F 20475542 4F202D2D [PERSON..BUG -- O]
1001560 41524C52 202C4753 74736574 49434F20 [RLRASG, test OCI]
1001570 4355535F 53534543 00000A2E 20475542 [_SUCCESS....BUG ]
1001580 4F202D2D 41524C52 202C4753 74736574 [-- ORLRASG, test]
1001590 49434F20 4355535F 53534543 00000A2E [ OCI_SUCCESS....]
10015A0 20475542 45202D2D 63657078 6F622074 [BUG -- Expect bo]
10015B0 72206874 20736665 20657261 61757165 [th refs are equa]
10015C0 000A2E6C 20475542 4F202D2D 43524C52 [l...BUG -- ORLRC]
10015D0 202C524C 74736574 49434F20 4355535F [LR, test OCI_SUC]
10015E0 53534543 00000A2E 20475542 45202D2D [CESS....BUG -- E]
10015F0 63657078 6F622074 72206874 20736665 [xpect both refs ]
1001600 20657261 61757165 000A2E6C 00000000 [are equal.......]
1001610 656C6573 76207463 65756C61 20297028 [select value(p) ]
1001620 6D6F7266 72657020 5F6E6F73 206C6274 [from person_tbl ]
1001630 68772070 20657265 73732E70 32323D6E [p where p.ssn=22]
1001640 35343433 00353535 2D2D2D0A 3E2D2D2D [3445555..------>]
1001650 73655420 524F2074 5145524C 00000A55 [ Test ORLREQU...]
1001660 53524550 00004E4F 20475542 4F202D2D [PERSON..BUG -- O]
1001670 41524C52 202C4753 74736574 49434F20 [RLRASG, test OCI]
1001680 4355535F 53534543 00000A2E [_SUCCESS....]
Argument/Register addr=6aa3f44.
Dump of memory from 0x6AA3F04 to 0x6AA4044
6AA3F00 06AA3F04 06AA3F04 06AA3F0C [.?...?...?..]
6AA3F10 06AA3F0C 06AA3F14 06AA3F14 06AA3F1C [.?...?...?...?..]
6AA3F20 06AA3F1C 06AA3F24 06AA3F24 06AA3F2C [.?..$?..$?..,?..]
6AA3F30 06AA3F2C 06AA3F34 06AA3F34 06AA3F3C [,?..4?..4?..
6AA3F40 06AA3F3C 00000120 06747F24 067A9904 [
6AA3F50 06A6089C 066EFB54 060D75C0 060D75C0 [....T.n..u...u..]
6AA3F60 060D75C0 00000003 00000001 00000000 [.u..............]
6AA3F70 00000120 06A60894 067A9704 06A608A4 [ .........z.....]
6AA3F80 066EFB54 060A6350 060A6350 060A6350 [T.n.Pc..Pc..Pc..]
6AA3F90 00000005 00000001 00000000 00000120 [............ ...]
6AA3FA0 06747D94 06B266E0 06747CFC 066F1498 [.}t..f...|t...o.]
6AA3FB0 0608A480 0608A480 0608A480 00000003 [................]
6AA3FC0 00000001 00000000 00000220 06AA3FF4 [........ ....?..]
6AA3FD0 06AA3FD0 06AA3FD0 066F1498 06077AD8 [.?...?....o..z..]
6AA3FE0 06AA3FE0 06AA3FE0 00000000 00000000 [.?...?..........]
6AA3FF0 00000000 00000220 06AA4020 06AA3FFC [.... ... @...?..]
6AA4000 06AA3FFC 066F1498 060A0E44 06AA400C [.?....o.D....@..]
6AA4010 06AA400C 00000000 00000000 00000000 [.@..............]
6AA4020 00000200 06AA404C 06AA4028 06AA4028 [....L@..(@..(@..]
6AA4030 00000000 00000000 00000000 00000000 [................]
6AA4040 00000000 [....]
Argument/Register addr=60d7550.
Dump of memory from 0x60D7510 to 0x60D7650
60D7510 060D750C 00000000 00000006 00000005 [.u..............]
60D7520 060D7520 060D7520 060D7528 060D7528 [ u.. u..(u..(u..]
60D7530 00000000 00000000 000007BD 060D74C4 [.............t..]
60D7540 00E8BDB8 06628DC4 00000000 060D7C90 [......b......|..]
60D7550 00020001 00000002 06A9A454 06A9A454 [........T...T...]
60D7560 060A143C 060D7648 00000000 00000000 [<...Hv..........]
60D7570 00000000 00000000 00000000 00000000 [................]
Repeat 4 times
60D75C0 06AA3F5C 06AA3F5C 060D75C8 060D75C8 [\?..\?...u...u..]
60D75D0 00000003 00000000 00000000 00000000 [................]
60D75E0 00000000 00000000 00000000 00000000 [................]
60D75F0 00000000 00000003 00000009 0000000A [................]
60D7600 00000000 00000018 00000003 7FFFFFFD [................]
60D7610 00000008 00000000 00000003 00000008 [................]
60D7620 00000001 00000000 00000003 00000000 [................]
60D7630 FFFFFFFF 00000000 00020001 00000002 [................]
60D7640 06A9A704 06A9A704 060D7560 060D7730 [........`u..0w..]
Argument/Register addr=13c2698.
Dump of memory from 0x13C2658 to 0x13C2798
13C2650 00000000 00000000 [........]
13C2660 00000000 00000000 00000000 00000000 [................]
13C2670 00000000 00000000 013C2678 013C2678 [........x&<.x&<.]
13C2680 00000000 00000000 00000000 066C28A0 [.............(l.]
13C2690 000002F5 000002F6 0000002F 066CD888 [......../.....l.]
13C26A0 00000000 00000000 4E4F4D53 00000200 [........SMON....]
13C26B0 0000013C 00000690 4E4F4D53 00000000 [<.......SMON....]
13C26C0 00000000 00000144 00000001 00000000 [....D...........]
13C26D0 00040081 00000031 00000032 00000033 [....1...2...3...]
13C26E0 000000C1 000000C2 000000C3 000000C4 [................]
13C26F0 000000C5 000000C6 000000C7 000000C8 [................]
13C2700 000000C9 000000CA 000000CB 000000CC [................]
13C2710 000000CD 000000CE 000000CF 000000D0 [................]
13C2720 000000D1 000000D2 000000D3 000000D4 [................]
13C2730 000000D5 000000D6 000000D7 000000D8 [................]
13C2740 000000D9 000000DA 000000DB 000000DC [................]
13C2750 000000DD 000000DE 000000DF 000000E0 [................]
13C2760 000000E1 000000E2 000000E3 000000E4 [................]
13C2770 000000E5 000000E6 000000E7 000000E8 [................]
13C2780 000000E9 000000EA 000000EB 000000EC [................]
13C2790 000000ED 000000EE [........]
Argument/Register addr=fe0fe2c.
Dump of memory from 0xFE0FDEC to 0xFE0FF2C
FE0FDE0 608437D8 [.7.`]
FE0FDF0 00000000 00000000 00000000 00000003 [................]
FE0FE00 00000000 00000000 00000000 00000000 [................]
FE0FE10 00000000 00000000 0000013C 00000000 [........<.......]
FE0FE20 0FE0FDF4 60650DFC 0FE0FFA4 00000000 [......e`........]
FE0FE30 00DF46C8 FFFFFFFF 0FE0FFB4 00402BBC [.F...........+@.]
FE0FE40 00000003 0FE0FF78 7FFDCC00 024CD4BC [....x.........L.]
FE0FE50 01769FF0 00000000 00000000 4E4F4D53 [..v.........SMON]
FE0FE60 00000000 00000000 00000001 011E94B4 [................]
FE0FE70 00000000 00000144 00000000 00000000 [....D...........]
FE0FE80 00000000 00000000 00000000 00000000 [................]
Repeat 9 times
FE0FF20 00000000 00000000 00000000 [............]
Argument/Register addr=fe0ff78.
Dump of memory from 0xFE0FF38 to 0xFE10078
FE0FF30 00000000 FFDFF4DC [........]
FE0FF40 80469B5C 888E2000 8042BE0D 888E2020 [\.F.. ....B. ..]
FE0FF50 888E2180 800654E0 00000000 00000000 [.!...T..........]
FE0FF60 00000000 00000000 00000000 BF35CCB0 [..............5.]
FE0FF70 00000000 888E21B0 01769FF0 01769FFB [.....!....v...v.]
FE0FF80 0176A000 00000000 8042F3AD 00000000 [..v.......B.....]
FE0FF90 00000000 8042F45D 889ED020 0FE0FE48 [....].B. ...H...]
FE0FFA0 FFFFFFFF 0FE0FFDC 00CB3E70 00DF4640 [........p>..@F..]
FE0FFB0 00000001 0FE0FFEC 77E8758A 01769FF0 [.........u.w..v.]
FE0FFC0 7FFDCC00 024CD4BC 01769FF0 7FFD6000 [......L...v..`..]
FE0FFD0 00151138 0FE0FFC0 00151138 FFFFFFFF [8.......8.......]
FE0FFE0 77E8615B 77E8B580 00000000 00000000 [[a.w...w........]
FE0FFF0 00000000 00402A90 01769FF0 00000000 [.....*@...v.....]
FE10000 00000000 00000000 00000000 00000000 [................]
Repeat 6 times
FE10070 00000000 00000000 [........]
----- End of Call Stack Trace -----
===================================================
Files currently opened by this process:
===================================================
PROCESS STATE
-------------
Process global information:
process: 66cd888, call: 6747f24, xact: 6a60894, curses: 66efb54, usrses: 66efb54
----------------------------------------
SO: 66cd888, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=6, calls cur/top: 6747f24/6747f24, flag: (a) SYSTEM
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 50
last post received-location: ktmchg
last process to post me: 66ce850 1 0
last post sent: 129 0 4
last post sent-location: kslpsr
last process posted by me: 66ce850 1 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 66e9f1c
O/S info: user: SYSTEM, term: COMPLEX-UQBU68W, ospid: 1680
OSD pid info: 1680
----------------------------------------
SO: 67d3c40, type: 9, owner: 66cd888, pt: 0, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 66cd888,
event: 5, last message event: 9, messages read: 1
channel: (67d42f8) scumnt mount lock
scope: 101, event: 9, last mesage event: 9,
publishers/subscribers: 1/7,
messages published: 1
----------------------------------------
SO: 66efb54, type: 3, owner: 66cd888, pt: 0, flag: INIT/-/-/0x00
(session) trans: 6a60894, creator: 66cd888, flag: (51) USR/- BSY/-/-/-/-/-
DID: 0001-0006-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 0/SYS
last wait for 'db file sequential read' blocking sess=0x0 seq=114 wait_time=-2
file#=1, block#=39d, blocks=1
----------------------------------------
SO: 67d3cb8, type: 9, owner: 66cd888, pt: 0, flag: INIT/-/-/0x00
(broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 66cd888,
event: 6, last message event: 6, messages read: 0
channel: (67d4218) system events broadcast channel
scope: 101, event: 12, last mesage event: 0,
publishers/subscribers: 0/10,
messages published: 0
----------------------------------------
SO: 6747f24, type: 2, owner: 66cd888, pt: 0, flag: INIT/-/-/0x00
(call) sess: cur 66efb54, rec 66f2ddc, usr 66efb54; depth: 0
----------------------------------------
SO: 6a60894, type: 25, owner: 6747f24, pt: 0, flag: INIT/-/-/0x00
(trans) bsn = 129, flg = 0x31, flg2 = 0x00, prx = 0x0, ros = 2147483647, spn = 156
efd = 4
parent xid: 0x0000.000.00000000
env: (scn: 0x0000.00000000 xid: 0x0000.000.00000000 uba: 0x00000000.0000.00)
cev: (spc = 0 usi = 2147483647 ubk tsn: 0 rdba: 0x00000000 useg tsn: 0 rdba: 0x00000000
hwm uba: 0x00000000.0000.00 col uba: 0x00000000.0000.00
num bl: 0 bk list: 0x0)
(enqueue)
res: 0, prv: 0, sess: 0
xga: 0x0, heap: UGA
----------------------------------------
SO: 6aa3f70, type: 32, owner: 6a60894, pt: 0, flag: INIT/-/-/0x00
row cache enqueue: count=1 session=66efb54 object=60a62e0, mode=X
row cache parent object: address=60a62e0 type=4(dc_used_extents)
transaction=6a60894 mode=X flags=0002
status=VALID/-/-/-/-/-/-/-
data=
00000003 00000009 0000000a 00000002 00000004 0000158a 00000008
----------------------------------------
SO: 67a96fc, type: 4, owner: 6a60894, pt: 0, flag: INIT/-/-/0x00
(enqueue) ST-00000000-00000000 DID: 0001-0006-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 67a9d9c, mode: X, prv: 67a9da4, sess: 66efb54, proc: 66cd888
----------------------------------------
SO: 6aa3f44, type: 32, owner: 6747f24, pt: 0, flag: INIT/-/-/0x00
row cache enqueue: count=1 session=66efb54 object=60d7550, mode=S
row cache parent object: address=60d7550 type=2(dc_segments)
transaction=0 mode=S flags=0002
status=VALID/-/-/-/-/-/-/-
data=
00000003 00000009 0000000a 00000000 00000018 00000003 7ffffffd 00000008
00000000 00000003 00000008 00000001 00000000 00000003 00000000 ffffffff
00000000
----------------------------------------
SO: 67a98fc, type: 4, owner: 6747f24, pt: 0, flag: INIT/-/-/0x00
(enqueue) TT-00000003-00000010 DID: 0001-0006-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 67a9b5c, mode: S, prv: 67a9b64, sess: 66efb54, proc: 66cd888
----------------------------------------
SO: 67a99bc, type: 4, owner: 6747f24, pt: 0, flag: INIT/-/-/0x00
(enqueue) TS-00000003-0240000A DID: 0001-0006-00000002
lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
res: 67a9a84, mode: X, prv: 67a9a8c, sess: 66efb54, proc: 66cd888
----------------------------------------
SO: 66f2ddc, type: 3, owner: 6747f24, pt: 0, flag: INIT/-/-/0x00
(session) trans: 6a60894, creator: 0, flag: (2) -/REC -/-/-/-/-/-
DID: 0000-0000-00000000, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 0/SYS
----------------------------------------
SO: 6b1e460, type: 36, owner: 66f2ddc, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=6b1e460 handle=60c4afc mode=S lock=6b1d440
user=66efb54 session=66f2ddc count=1 mask=0041 savepoint=0 flags=[00]
----------------------------------------
SO: 6b1d440, type: 35, owner: 66f2ddc, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=6b1d440 handle=60c4afc mode=N
call pin=0 session pin=6b1e460
user=66efb54 session=66f2ddc count=1 flags=BRO/PNS/[09] savepoint=0
LIBRARY OBJECT HANDLE: handle=60c4afc
namespace=CRSR flags=RON/KGHP/PN0/[10010000]
kkkk-dddd-llll=0000-0041-0041 lock=0 pin=S latch=2
lwt=60c4b14[60c4b14,60c4b14] ltm=60c4b1c[6b1d450,6b1d450]
pwt=60c4b2c[60c4b2c,60c4b2c] ptm=60c4b84[60c4b84,60c4b84]
ref=60c4b04[60c5d9c,60c5d9c] lnd=60c4b90[60c4b90,60c4b90]
LIBRARY OBJECT: object=60c4884
type=CRSR flags=EXS[0001] pflags= [00] status=INVL load=0
DEPENDENCIES: count=1 size=16
ACCESSES: count=1 size=16
TRANSLATIONS: count=1 size=16
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 60c4a8c 60c4644 I/P/A 0 NONE
6 60c4918 60c3624 I/P/A 1 NONE
----------------------------------------
SO: 6b1d4b8, type: 35, owner: 66f2ddc, flag: INIT/-/-/0x00
LIBRARY OBJECT LOCK: lock=6b1d4b8 handle=60c60bc mode=N
call pin=6b1e4f0 session pin=0
user=66efb54 session=66f2ddc count=1 flags=[00] savepoint=0
LIBRARY OBJECT HANDLE: handle=60c60bc
name=select file#, block#, ts# from seg$ where type# = 3
hash=2b9d6f9d timestamp=01-24-2002 23:15:26
namespace=CRSR flags=RON/KGHP/TIM/PN0/SML/[12010000]
kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch=2
lwt=60c60d4[60c60d4,60c60d4] ltm=60c60dc[60c60dc,60c60dc]
pwt=60c60ec[60c60ec,60c60ec] ptm=60c6144[60c6144,60c6144]
ref=60c60c4[60c60c4,60c60c4] lnd=60c6150[60c6150,60c6150]
LIBRARY OBJECT: object=60c5c14
type=CRSR flags=EXS[0001] pflags= [00] status=VALD load=0
CHILDREN: size=16
child# table reference handle
------ -------- --------- --------
0 60c5dd0 60c5d9c 60c4afc
DATA BLOCKS:
data# heap pointer status pins change
----- -------- -------- ------ ---- ------
0 60c5e1c 60c5c98 I/P/A 0 NONE
===================================================
CURRENT SESSION'S INSTANTIATION STATE
-------------------------------------
current session=66efb54
******************** Cursor Dump ************************
Current cursor: 0, pgadep: 0
Cursor Dump:
----------------------------------------
Cursor 1 (fe4e2cc): CURROW curiob: fe70b1c
curflg: f curpar: 0 curusr: 0 curses 66f2ddc
cursor name: select file#, block#, ts# from seg$ where type# = 3
child pin: 6b1e460, child lock: 6b1d440, parent lock: 6b1d4b8
xscflg: 141464, parent handle: 60c60bc, xscfl2: 4000400
nxt: 3.0x00000004 nxt: 2.0x00000074 nxt: 1.0x00000434
Cursor frame allocation dump:
frm: -------- Comment -------- Size Seg Off
bhp size: 156/560
whp size: 128/2980
Dump of CURRENT WORK HEAP:
******************************************************
HEAP DUMP heap name="cursor work he" desc=0xfe7c5d0
extent sz=0x1068 alt=32767 het=32767 rec=0 flg=2 opc=2
parent=17d060 owner=0 nex=0 xsz=0xb88
EXTENT 0
Chunk fe7d6b0 sz= 2816 free " "
FE7D6B0 C0000B01 00000000 0FE7C624 0FE7C624 [........$...$...]
FE7D6C0 00000000 00000000 00000000 00000000 [................]
Repeat 174 times
Chunk fe7e1b0 sz= 24 freeable "Skip Extents "
FE7E1B0 00000019 0FE7D6B0 00E72ED8 00000000 [................]
FE7E1C0 00000000 00000000 [........]
Chunk fe7e1c8 sz= 52 freeable "Extent Sizes "
FE7E1C0 00000035 0FE7E1B0 [5.......]
FE7E1D0 00E72EC8 00000002 00000002 00000003 [................]
FE7E1E0 00000005 00000008 00000010 00000018 [................]
FE7E1F0 00000020 00000030 00000040 [ ...0...@...]
Chunk fe7e1fc sz= 52 freeable "Extent Starting"
FE7E1F0 10000035 [5...]
FE7E200 0FE7E1C8 00E72EB4 00400031 004000F7 [........1.@...@.]
FE7E210 00400196 004002AD 0040165B 0040569B [..@...@.[[email protected]@.]
FE7E220 00405703 004066FB 0040679B 004067CB [[email protected]@[email protected]@.]
Total heap size = 2944
FREE LISTS:
Bucket 0 size=524
Bucket 1 size=1036
Chunk fe7d6b0 sz= 2816 free " "
Total free space = 2816
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Permanent space = 0
******************************************************
End of cursor dump
END OF PROCESS STATE
******************** Cursor Dump ************************
Current cursor: 0, pgadep: 0
Cursor Dump:
----------------------------------------
Cursor 1 (fe4e2cc): CURROW curiob: fe70b1c
curflg: f curpar: 0 curusr: 0 curses 66f2ddc
cursor name: select file#, block#, ts# from seg$ where type# = 3
child pin: 6b1e460, child lock: 6b1d440, parent lock: 6b1d4b8
xscflg: 141464, parent handle: 60c60bc, xscfl2: 4000400
nxt: 3.0x00000004 nxt: 2.0x00000074 nxt: 1.0x00000434
Cursor frame allocation dump:
frm: -------- Comment -------- Size Seg Off
bhp size: 156/560
whp size: 128/2980
Dump of CURRENT WORK HEAP:
******************************************************
HEAP DUMP heap name="cursor work he" desc=0xfe7c5d0
extent sz=0x1068 alt=32767 het=32767 rec=0 flg=2 opc=2
parent=17d060 owner=0 nex=0 xsz=0xb88
EXTENT 0
Chunk fe7d6b0 sz= 2816 free " "
FE7D6B0 C0000B01 00000000 0FE7C624 0FE7C624 [........$...$...]
FE7D6C0 00000000 00000000 00000000 00000000 [................]
Repeat 174 times
Chunk fe7e1b0 sz= 24 freeable "Skip Extents "
FE7E1B0 00000019 0FE7D6B0 00E72ED8 00000000 [................]
FE7E1C0 00000000 00000000 [........]
Chunk fe7e1c8 sz= 52 freeable "Extent Sizes "
FE7E1C0 00000035 0FE7E1B0 [5.......]
FE7E1D0 00E72EC8 00000002 00000002 00000003 [................]
FE7E1E0 00000005 00000008 00000010 00000018 [................]
FE7E1F0 00000020 00000030 00000040 [ ...0...@...]
Chunk fe7e1fc sz= 52 freeable "Extent Starting"
FE7E1F0 10000035 [5...]
FE7E200 0FE7E1C8 00E72EB4 00400031 004000F7 [........1.@...@.]
FE7E210 00400196 004002AD 0040165B 0040569B [..@...@.[[email protected]@.]
FE7E220 00405703 004066FB 0040679B 004067CB [[email protected]@[email protected]@.]
Total heap size = 2944
FREE LISTS:
Bucket 0 size=524
Bucket 1 size=1036
Chunk fe7d6b0 sz= 2816 free " "
Total free space = 2816
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Permanent space = 0
******************************************************
End of cursor dump
ksedmp: no current context area
----- Dump of the Fixed PGA -----
word ksmpgf_ [17D018, 17D01C) = 00000000
word ksmmpd_ [17D01C, 17D020) = 00000001
skgm_cx ksmskgmctx_ [17D020, 17D054) = 00EC5498 0017D190 0000007F 00000001 ...
Dump of memory from 0x17D030 to 0x17D054
17D030 6F5C0000 00001000 00010000 00010000 [..\o............]
17D040 7FFEFFFF 0FD11000 025B28C0 00000000 [.........([.....]
17D050 ACC01ADE [....]
skgmrhandle * ksmrealm_ [17D054, 17D058) = 025B28C0
Dump of memory from 0x25B28C0 to 0x25B2900
25B28C0 025B1EC0 025B1FE0 025B2798 00151538 [..[...[..'[.8...]
25B28D0 025B27E0 025B27F0 00150D48 025B0000 [.'[..'[.H.....[.]
25B28E0 00000000 00000000 00060006 000C0100 [................]
25B28F0 025B1EC0 025B1FE0 025B2798 00151538 [..[...[..'[.8...]
kgsmp * ksmgpp_ [17D058, 17D05C) = 0017D190
Dump of memory from 0x17D190 to 0x17D1D0
17D190 013B85B0 0FE4F310 0017D060 00000000 [..;.....`.......]
17D1A0 0FE47B80 0FE710FC 00181480 00000000 [.{..............]
17D1B0 0FE47BE0 0FE47644 00000000 00000000 [.{..Dv..........]
17D1C0 00000001 00000000 00000000 00000000 [................]
ksmpy ksmpgh_ [17D060, 17D17C) = 00000000 0000213C 00000000 10FB0034 ...
Dump of memory from 0x17D070 to 0x17D17C
17D070 0FE7C5BC 00000000 00000000 03120300 [................]
17D080 00000000 0000213C 20616770 70616568 [....
17D090 00000000 00000000 7FFF0028 7FFF7FFF [........(.......]
17D0A0 00000000 0000002C 0FE4DD14 0FE4DD14 [....,...........]
17D0B0 0000004C 0017D0B4 0017D0B4 00000060 [L...........`...]
17D0C0 0017D0C0 0017D0C0 0000008C 0017D0CC [................]
17D0D0 0017D0CC 000000EC 0017D0D8 0017D0D8 [................]
17D0E0 0000010C 0017D0E4 0017D0E4 0000020C [................]
17D0F0 0017D0F0 0017D0F0 0000040C 0FE7C694 [................]
17D100 0FE7C694 0000080C 0017D108 0017D108 [................]
17D110 0000100C 0017D114 0017D114 0000200C [............. ..]
17D120 10FB0044 10FB0044 0000400C 0017D12C [D...D....@..,...]
17D130 0017D12C 0000800C 0017D138 0017D138 [,.......8...8...]
17D140 0001000C 0017D144 0017D144 0002000C [....D...D.......]
17D150 0017D150 0017D150 0004000C 0017D15C [P...P.......\...]
17D160 0017D15C 0008000C 0017D168 0017D168 [\.......h...h...]
17D170 0020000C 0017D174 0017D174 [.. .t...t...]
struct ksmug * ksmugp_ [17D17C, 17D180) = 0FE4F1E8
Dump of memory from 0xFE4F1E8 to 0xFE4F228
FE4F1E0 0000ABAB 0FE4F1F0 [........]
FE4F1F0 0017D060 0000108C 066EFB54 0FE7CE68 [`.......T.n.h...]
FE4F200 0FE710EC 00000000 00000000 03120300 [................]
FE4F210 00000000 00000824 73736573 206E6F69 [....$...session ]
FE4F220 70616568 00000000 [heap....]
ub1 * ksmkcu_ [17D180, 17D184) = 0FE78344
Dump of memory from 0xFE78344 to 0xFE78384
FE78340 0000000D 00000000 00E4562C [........,V..]
FE78350 00000001 00000000 0000000F 0FE78350 [............P...]
FE78360 00FDB10C 00000001 00000001 00020016 [................]
FE78370 00000001 00020016 00000001 00020016 [................]
FE78380 00000001 [....]
ub1 * ksmken_ [17D184, 17D188) = 0FE7C5A0
Dump of memory from 0xFE7C5A0 to 0xFE7C5E0
FE7C5A0 00BC614E FFFFFFFF 00000690 00002140 [Na..........@!..]
FE7C5B0 00002140 0017D060 0FE78324 400000D1 [@!..`...$......@]
FE7C5C0 00000000 0FE7218C 000000D0 00000000 [.....!..........]
FE7C5D0 0017D060 00001068 00000000 0FE7D6A8 [`...h...........]
ub1 * ksmkpr_ [17D188, 17D18C) = 00000000
kgsmp ksmgpg_ [17D190, 17E560) = 013B85B0 0FE4F310 0017D060 00000000 ...
Dump of memory from 0x17D1A0 to 0x17E560
17D1A0 0FE47B80 0FE710FC 00181480 00000000 [.{..............]
17D1B0 0FE47BE0 0FE47644 00000000 00000000 [.{..Dv..........]
17D1C0 00000001 00000000 00000000 00000000 [................]
17D1D0 00000000 00000000 00000000 00E6AE78 [............x...]
17D1E0 00001000 00000000 00000000 00000000 [................]
17D1F0 0000000C 00000010 00000000 0FE4CD58 [............X...]
17D200 0FE4CC30 0FE0EF58 00000000 0FE4CD58 [0...X.......X...]
17D210 00000002 00000258 0017D590 00000004 [....X...........]
17D220 00000026 00000000 00000000 00000000 [&...............]
17D230 00000000 00000000 00000000 00000000 [................]
Repeat 52 times
17D580 00000000 00000000 00000000 00000001 [................]
17D590 00000802 62636B00 5F726272 00010132 [.....kcbrbr_2...]
17D5A0 01330000 00000008 38373631 30333732 [..3.....16782730]
17D5B0 00000101 00003800 00000000 00000000 [.....8..........]
17D5C0 00000000 00000000 00000000 00000000 [................]
Repeat 124 times
17DD90 0017D5B6 0017DD90 00000004 0FE4CD58 [............X...]
17DDA0 00000001 00000000 00000000 00000000 [................]
17DDB0 00000000 00000003 0FE47624 00000000 [........$v......]
17DDC0 00000005 00000094 532F4C50 00004C51 [........PL/SQL..]
17DDD0 00000000 00000000 00000000 00000000 [................]
17DDE0 00000000 00000000 62954CA0 62954E90 [.........L.b.N.b]
17DDF0 62954C60 62954BF0 62954EA0 62954F20 [`L.b.K.b.N.b O.b]
17DE00 00000000 00000000 0000004C 534D4C49 [........L...ILMS]
17DE10 00000000 00000000 00000000 00000000 [................]
17DE20 00000000 00000000 00000000 6007AFA0 [...............`]
17DE30 00000000 00000000 00000000 00000000 [................]
17DE40 00000000 00000000 00000000 000001B0 [................]
17DE50 73727563 0000726F 00000000 00000000 [cursor..........]
17DE60 00000000 00000000 00000000 00000000 [................]
17DE70 004EDCA0 004EDCB0 00000000 00000000 [..N...N.........]
17DE80 00000000 00000000 00000000 00000000 [................]
17DE90 00000058 414B4F4B 65706F20 7563206E [X...KOKA open cu]
17DEA0 726F7372 00000000 00000000 00000000 [rsor............]
17DEB0 00000000 0071FFD0 00000000 0071FFE0 [......q.......q.]
17DEC0 007201E0 00000000 00000000 00000000 [..r.............]
17DED0 00000000 00000058 414B4F4B 65737020 [....X...KOKA pse]
17DEE0 206F6475 73727563 0000726F 00000000 [udo cursor......]
17DEF0 00000000 00000000 00720470 00000000 [........p.r.....]
17DF00 00720480 00720600 00000000 00000000 [..r...r.........]
17DF10 00000000 00000000 00000000 00000000 [................]
Repeat 13 times
17DFF0 00000000 0017E574 00EC54B8 00480010 [....t....T....H.]
17E000 60045270 00000000 00480010 00000000 [pR.`......H.....]
17E010 0017E9F0 0017E9FC 0017E9F8 0017E9F4 [................]
17E020 0017EA10 00180058 00000000 0FE46F08 [....X........o..]
17E030 00000000 0FE4C9A4 0FE4C9B0 0FE4CAE0 [................]
17E040 0FE4CAC8 0FE4D834 0FE4C7F8 0FE4CAD8 [....4...........]
17E050 00000000 00000000 0FE47444 00000EF6 [........Dt......]
17E060 0FE46EFC 00F08AF0 00000001 00000000 [.n..............]
17E070 00000000 00000000 00000000 00000000 [................]
Repeat 2 times
17E0A0 00000000 00000001 00F08B10 0093D8F0 [................]
17E0B0 00000000 0093DA10 00000000 00000000 [................]
17E0C0 00000001 00F08ED0 00000000 0093E110 [................]
17E0D0 0093E170 00000000 00000000 00000001 [p...............]
17E0E0 00F08CF0 00000000 0093D360 0093D4E0 [........`.......]
17E0F0 00000000 00000000 00000001 00F08CF0 [................]
17E100 00000000 0093D360 0093D4E0 00000000 [....`...........]
17E110 00000000 00000000 00000000 00000000 [................]
Repeat 10 times
17E1C0 00000000 00000000 00000001 00000001 [................]
17E1D0 0093B9D0 00000000 00000000 00000000 [................]
17E1E0 00000000 00000000 00000000 00000000 [................]
Repeat 8 times
17E270 00000000 00000000 00F090B0 00000000 [................]
17E280 00000000 00000000 00000000 00000000 [................]
Repeat 45 times
ksdeg ksdpeg_ [17E560, 17E570) = 00000000 00000000 0FE4CAF0 0017D060
ub1 ksdein_ [17E570, 17E574) = 00000003
word ksdtfg_ [17E574, 17E578) = 00000000
ksdbv ksdpbv_ [17E578, 17E5F8) = 00000000 00000000 00000000 00000000 ...
Dump of memory from 0x17E588 to 0x17E5F8
17E580 00000000 00000000 [........]
17E590 00000000 00000000 00000000 00000000 [................]
Repeat 5 times
17E5F0 00000000 00000000 [........]
ksdep_O ksdepn_ [17E5F8, 17E61C) = 00000000 00000000 00000000 00000000 ...
Dump of memory from 0x17E608 to 0x17E61C
17E600 00000000 00000000 [........]
17E610 00000000 00000000 00000000 [............]
ksdbf ksdbuf_ [17E620, 17E6A4) = 6264736B 736B2066 66756264 205F205F ...
Dump of memory from 0x17E630 to 0x17E6A4
17E630 67756D73 20205F70 31383220 20202036 [smugp_ 2816 ]
17E640 30303020 20203437 3A74786E 302E3120 [ 00074 nxt: 1.0]
17E650 30303078 33343030 65707934 203D2023 [x00000434ype# = ]
17E660 302D3033 30303030 66303030 20302066 [30-00000000ff 0 ]
17E670 61626472 7830203A 30303030 30303030 [rdba: 0x00000000]
17E680 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
17E6A0 00000000 [....]
size_t ksdbfl_ [17E6A4, 17E6A8) = 0000000F
ub4 ksdftm_ [17E6A8, 17E6AC) = 00022D08
eword ksdfin_ [17E6AC, 17E6B0) = 00000001
ub4 ksdfbs_ [17E6B0, 17E6B4) = 00000000
text * ksdfbp_ [17E6B4, 17E6B8) = 00000000
ub4 ksdfbo_ [17E6B8, 17E6BC) = 00000000
ub4 ksdfbw_ [17E6BC, 17E6C0) = 00000000
ub2 ksdsid_ [17E6C0, 17E6C4) = 00000005
ub2 ksdser_ [17E6C4, 17E6C8) = 00000001
word ksdsch_ [17E6C8, 17E6CC) = 00000000
struct ksdhngpg *ksdhpg_ ksdhpg_ [17E6CC, 17E6D0) = 00000000
word ksdtfp_ [17E6D0, 17E6D4) = 00000001
lrmctx * ksppgs_ [17E6D4, 17E6D8) = 00000000
ksppst * ksppvt_ [17E6D8, 17E6DC) = 0611A6F0
Dump of memory from 0x611A6F0 to 0x611A730
611A6F0 00000000 00000001 000007D0 00000001 [................]
611A700 00000000 00000001 00000004 00000001 [................]
611A710 00000000 00000001 00000001 00000001 [................]
611A720 000000FE 00000001 00000001 00000001 [................]
text * kspmsg_ [17E6DC, 17E6E0) = 00000000
struct lxhnd ksplxhnd_ [17E6E0, 17E87C) = 00000000 00000000 00000000 ...
Dump of memory from 0x17E6EC to 0x17E87C
17E6E0 00000000 [....]
17E6F0 00000000 00000000 00000000 00000000 [................]
Repeat 23 times
17E870 00000000 00000000 00000000 [............]
struct lxglo ksplxglo_ [17E880, 17E9A8) = 00000000 00000000 00000000 ...
Dump of memory from 0x17E88C to 0x17E9A8
17E880 00000000 [....]
17E890 00000000 00000000 00000000 00000000 [................]
Repeat 16 times
17E9A0 00000000 00000000 [........]
struct kspvsrc * ksppstbl_ [17E9A8, 17E9AC) = 00000000
struct kspvsrc * kspoptbl_ [17E9AC, 17E9B0) = 00000000
struct ksupr * kslrov_ [17E9B0, 17E9B4) = 066CEB78
Dump of memory from 0x66CEB78 to 0x66CEBB8
66CEB70 00000001 00000000 [........]
66CEB80 00000000 00000000 066CEB88 066CEB88 [..........l...l.]
66CEB90 00000000 00000001 00000000 00000000 [................]
66CEBA0 00000000 00000000 066CEBA8 066CEBA8 [..........l...l.]
66CEBB0 00000000 00000000 [........]
ub4 kslbwt_ [17E9B4, 17E9B8) = 00000000
word ksllsp_ [17E9B8, 17E9BC) = 00000001
struct ksltr * ksltri_ [17E9BC, 17E9C0) = 00000000
ub1 ksldbg_ [17E9C0, 17E9C4) = 00000000
const char * kslcmt_ [17E9C4, 17E9C8) = 00E8BE50
Dump of memory from 0xE8BE50 to 0xE8BE90
E8BE50 5052514B 00344552 5052514B 00004B4C [KQRPRE4.KQRPLK..]
E8BE60 5052514B 00004B4C 5052514B 31564953 [KQRPLK..KQRPSIV1]
E8BE70 00000000 7072716B 2D766973 00000031 [....kqrpsiv-1...]
E8BE80 5052514B 31564953 00000000 00000000 [KQRPSIV1........]
struct skgslctx kslctx_ [17E9C8, 17E9CC) = 00000000
word kslspc_ [17E9CC, 17E9D0) = 00000002
word kslsst_ [17E9D0, 17E9D4) = 00000003
word kslmxs_ [17E9D4, 17E9D8) = 00000004
word kslmes_ [17E9D8, 17E9DC) = 00000005
word kslpsw_ [17E9DC, 17E9E0) = 00000006
word kslrpp_ [17E9E0, 17E9E4) = 00000007
word kslvpst_ [17E9E4, 17E9E8) = 00000008
ub4 ksustpg_ [17E9E8, 17E9EC) = 00000000
-
Looks like oracle only would be in a position to help you. For information, how did you try starting the oracle?
Sam
-
I had to do a shutdown abort to shutdown oracle fully. Then I connected internal and tried to start it up, it mounts the database but is not able to open it I get the error:
Ora 3114: end of file communication channel, then when I try to reconnect it gives me tns protocol adapter error, I have to again do a shutdown abort......, I rebooted the server to release memory and then tried to restart but no success. There are 3 other instances in the same server which are running ok.
Oracle is looking at the trace files but no response yet.
Thanx
-
Oracle said it might be a new bug, they asked to to set event in the init.ora and the database is up now, but I will have to upgrade to 8.1.7.3.
Thanx
-
Did you set your SID properly before trying to start?
did you try
startup mount
recover database;
alter database open;
Sam
[Edited by sambavan on 01-25-2002 at 02:27 PM]
-
Hi Narayan,
Please give us what Oracle asked you change an event in init.ora .. I case if we got the same problem we can fix it ..
-
the event I had to set in the init file is:
event="10061 trace name context forever, level 10"
Sambavan,
Yes I had set the SID correctly, now after setting the event I had no problem in starting up. But the problem now is I have started getting ora 600 errors again in user trace files:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [25012], [4], [3], [], [], [], [], []
No current SQL statement being executed.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+a8 CALLrel _ksedst+0
2FCCF7C
_ksfdmp+e CALLrel _ksedmp+0 3
_kgeriv+95 CALLreg 00000000
A5158
3
_kgesiv+49 CALLrel _kgeriv+0
C54B8
23044654
61B4
2
22FCD0FC
_ksesic2+3c CALLrel _kgesiv+0
A5158
23044654
61B4
2
22FCD0FC
_kftr2ah+f7 CALLrel _ksesic2+0 61B4
0 4 0
3
_kcblrs+ed CALLrel _kftr2ah+0
_kcblrd+43 CALLrel _kcblrs+0
A4FD0
_kcblgt+17e CALLrel _kcblrd+0
_kcbldrget+73 CALLrel _kcblgt+0
304C6D0
4
C1E8B5
_kcbgtcr+ac CALLrel _kcbldrget+0
309B55C
0
_kdlrdb+94 CALLrel _kcbgtcr+0
_kdlprl+158 CALLrel _kdlrdb+0
2FCDD54
22FCDA88
22FCDC0C
0
22FCDF3C
B3CC10
0
1FC4
_kdl_read+587 CALLrel _kdlprl+0
2FCDD54
22FCDC0C
C1E8B5
2 0 0
22FCDF3C
B3CC10
0
3869
22FCDA88
22FCDAFC
_koklread+366 CALLrel _kdl_read+0
2FCDD54
22FCDE44
0
22FCDD14
0
22FCDF3C
B3CC10
22FCDD10
_kpolob+1f5 CALLrel _koklread+0
2FCE4D0
0 0 1
22FCE4C8
0 0
22FCDF3C
B3CC10
0 0
_opiodr+507 CALLreg 00000000 60 C
22FCEF80
_ttcpip+df8 CALLreg 00000000 60 C
22FCEF80
0
_opitsk+608 CALLrel _ttcpip+0
_opiino+50c CALLrel _opitsk+0 0
_opiodr+507 CALLreg 00000000 3C 4
22FCFBF8
_opidrv+384 CALLrel _opiodr+0 3C 4
22FCFBF8
0
_sou2o+19 CALLrel _opidrv+0
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+4b8 CALLrel _opimai+0 2
22FCFE74
77E87587 CALLreg 00000000
I am waiting for response from metalink.
Thanx,
Kavita
-
ORA-00600: internal error code, arguments: [25012], [4], [3], [], [], [], [], []
Check v$datafile and see which tablespace is file#3. Use dbverify to see if the datafile is corrupt.
dbv filename=datafile blocksize=database blocksize
-
I ran dfverify on all the datafiles and there is no corruption
Thanx
-
Does it occour when you do some truncation on the table with CLOB types. On such case its a Bug 1678963 . Make sure that the tablespace 4 is in good health.
Sam
-
It turns out to be that the data dictionary is corrupted by the crash. So the database has to be recreated thru an import which will rebuild the data dictionary.
Sambavan you were right it seems to have hit a bug with the alter of a lob column.
Now the problem: I am getting the same ora 600 errors on one table (which has a lob column) in my export. Please help how do I get a clean export. I have a hot backup from before, Can I use that instead of the export/import??
Thanx
-
Do you have any Temporary Segments yet to be released?
try , Mount the db then make uncritical tblsps offline , then open, and try making one by one tblsp online ..
-
ORA-00600: is internal error code and it is recommended for you to call Oracle support with error stack messages. I will not advise you to try to fix it if you really don't know what you are doing.
Thanks
