DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: ora 600 help urgent

  1. #1
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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.
    KN

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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
    KN

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Looks like oracle only would be in a position to help you. For information, how did you try starting the oracle?

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  4. #4
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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
    KN

  5. #5
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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
    KN

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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]
    Thanx
    Sam



    Life is a journey, not a destination!


  7. #7
    Join Date
    Aug 2001
    Posts
    267
    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 ..


    Raghu

  8. #8
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    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
    KN

  9. #9
    Join Date
    Apr 2000
    Posts
    126
    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

  10. #10
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    I ran dfverify on all the datafiles and there is no corruption

    Thanx
    KN

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width