ora 600 help urgent

**Knarayan** · 01-25-2002 11:37 AM

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.

**Knarayan** · 01-25-2002 11:56 AM

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 [..@...@.[.@..V@.]
FE7E220 00405703 004066FB 0040679B 004067CB [.W@..f@..g@..g@.]
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 [..@...@.[.@..V@.]
FE7E220 00405703 004066FB 0040679B 004067CB [.W@..f@..g@..g@.]
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

**sambavan** · 01-25-2002 12:05 PM

Looks like oracle only would be in a position to help you. For information, how did you try starting the oracle?

Sam

**Knarayan** · 01-25-2002 12:38 PM

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

**Knarayan** · 01-25-2002 01:14 PM

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

**sambavan** · 01-25-2002 02:20 PM

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]

**raghud** · 01-25-2002 03:14 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 ..

**Knarayan** · 01-25-2002 03:56 PM

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

**mhaller** · 01-25-2002 04:05 PM

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

**Knarayan** · 01-25-2002 04:14 PM

I ran dfverify on all the datafiles and there is no corruption

Thanx

Thread: ora 600 help urgent

Thread Tools

Display

Bookmarks

Bookmarks

Posting Permissions