DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 22

Thread: ORA-00600: internal error code-Urgent

  1. #11
    Join Date
    Oct 2004
    Posts
    18
    Hi,

    First of all I would like to thanks the Members participating in this Question.

    My OS is Windows 2000 Server and Oracle version is 9.2.0.4.

    Note:- I am using Context indexes(Ultra Text Search) or Intermedia Indexes, in my schema.

    I don't have Metalink support.Here is the Trace File Contents

    Dump file d:\oracle\admin\TEST\udump\TEST_ora_2932.trc
    Tue Dec 07 19:49:44 2004
    ORACLE V9.2.0.4.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.4.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: TEST

    Redo thread mounted by this instance: 1

    Oracle process number: 13

    Windows thread id: 2932, image: ORACLE.EXE


    *** 2004-12-07 19:49:44.381
    *** SESSION ID:(9.3687) 2004-12-07 19:49:44.350
    ********** Internal heap ERROR 17114 addr=09F4C658 *********
    ***** Dump of memory around addr 09F4C658:
    9F4C450 00000000 00000000 [........]
    9F4C460 00000000 00000000 00000000 00000000 [................]
    9F4C470 00000000 00000000 00000000 AED81300 [................]
    9F4C480 00000000 00000000 00000000 00000000 [................]
    9F4C490 00000000 0013D8AE 00000000 00000000 [................]
    9F4C4A0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C4C0 00000000 00000000 00000000 AED81300 [................]
    9F4C4D0 00000000 00000000 00000000 00000000 [................]
    9F4C4E0 00000000 0013D8AE 00000000 00000000 [................]
    9F4C4F0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C510 00000000 00000000 00000000 AED81300 [................]
    9F4C520 00000000 00000000 00000000 00000000 [................]
    9F4C530 00000000 0013D8AE 00000000 00000000 [................]
    9F4C540 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C560 00000000 00000000 00000000 AED81300 [................]
    9F4C570 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C590 D00000C9 09F4BB4C 05410258 09F4F53C [....L...X.A.<...]
    9F4C5A0 000000C9 00000D51 00400D57 00000007 [....Q...W.@.....]
    9F4C5B0 00000000 00000001 00000000 0C651E00 [..............e.]
    9F4C5C0 000000C9 00000D58 00400D5B 00000004 [....X...[.@.....]
    9F4C5D0 00000001 00000001 00000000 0C661E00 [..............f.]
    9F4C5E0 000000C9 00000D43 00400D49 00000007 [....C...I.@.....]
    9F4C5F0 00000002 00000001 00000000 0C671E00 [..............g.]
    9F4C600 000000C9 00000D4A 00400D50 00000007 [....J...P.@.....]
    9F4C610 00000003 00000001 00000000 0000004C [............L...]
    9F4C620 D0000039 09F4C590 05410258 09F4F53C [9.......X.A.<...]
    9F4C630 00000004 0B43F9D8 0000013C 00000000 [......C.<.......]
    9F4C640 00000000 0000001C 00000000 00A6D3C0 [................]
    9F4C650 00A6D440 05410210 00000000 09F40214 [@.....A.........]
    9F4C660 05410BF0 05410210 09F4CA94 40000201 [..A...A........@]
    9F4C670 00000000 09F4F384 00000200 0013D8AE [................]
    9F4C680 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C6B0 00000000 0013D8AE 00000000 00000000 [................]
    9F4C6C0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C6E0 00000000 00000000 00000000 0013D8AE [................]
    9F4C6F0 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C720 00000000 AED81300 00000000 00000000 [................]
    9F4C730 00000000 00000000 00000000 0013D8AE [................]
    9F4C740 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C770 00000000 0013D8AE 00000000 00000000 [................]
    9F4C780 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C7A0 00000000 00000000 00000000 AED81300 [................]
    9F4C7B0 00000000 00000000 00000000 00000000 [................]
    9F4C7C0 00000000 0013D8AE 00000000 00000000 [................]
    9F4C7D0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C7F0 00000000 00000000 00000000 0013D8AE [................]
    9F4C800 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C830 00000000 0013D8AE 00000000 00000000 [................]
    9F4C840 00000000 00000000 00000000 00000000 [................]
    9F4C850 00000000 00000000 [........]
    ******************************************************
    HEAP DUMP heap name="callheap" desc=05410210
    extent sz=0x424 alt=32767 het=32767 rec=0 flg=2 opc=6
    parent=05410BF0 owner=00000000 nex=00000000 xsz=0xe214
    EXTENT 0 addr=09F4C664
    Chunk 9f4c66c sz= 512 perm "perm " alo=512
    Chunk 9f4c86c sz= 376 perm "perm " alo=376
    Chunk 9f4c9e4 sz= 164 perm "perm " alo=152
    EXTENT 1 addr=09F4CA94
    Chunk 9f4ca9c sz= 4144 freeable "sql area " ds=09F4F210
    EXTENT 2 addr=09F4DAD8
    Chunk 9f4dae0 sz= 492 freeable "sql area " ds=09F4F210
    Chunk 9f4dccc sz= 560 freeable "library cache " ds=09F4F4C4
    EXTENT 3 addr=09F4DF08
    Chunk 9f4df10 sz= 4144 recreate "sql area " latch=00000000
    ds 9f4f210 sz= 19896 ct= 6
    b369610 sz= 4144
    b33efd0 sz= 4144
    9f4b02c sz= 2828
    9f4ca9c sz= 4144
    9f4dae0 sz= 492
    EXTENT 4 addr=09F4EF4C
    Chunk 9f4ef54 sz= 492 freeable "library cache " ds=09F4F4C4
    Chunk 9f4f140 sz= 560 recreate "library cache " latch=00000000
    ds 9f4f4c4 sz= 1612 ct= 3
    9f4dccc sz= 560
    9f4ef54 sz= 492
    EXTENT 5 addr=09F4F37C
    Chunk 9f4f384 sz= 432 perm "perm " alo=432
    Chunk 9f4f534 sz= 60 free " "
    Chunk 9f4f570 sz= 560 freeable "library cache " ds=09F4F9D4
    EXTENT 6 addr=09F4F7BC
    Chunk 9f4f7c4 sz= 608 perm "perm " alo=608
    Chunk 9f4fa24 sz= 428 recreate "library cache " latch=00000000
    ds 9f4f9d4 sz= 988 ct= 2
    9f4f570 sz= 560
    Total heap size = 13532
    FREE LISTS:
    Bucket 0 size=76
    Bucket 1 size=268
    Bucket 2 size=1036
    Total free space = 0
    UNPINNED RECREATABLE CHUNKS (lru first):
    PERMANENT CHUNKS:
    Permanent space = 0
    ******************************************************
    Hla: 0
    *** 2004-12-07 19:49:44.678
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [17114], [0x9F4C658], [], [], [], [], [], []
    No current SQL statement being executed.


    Thanking you,
    SankarG

  2. #12
    Join Date
    Oct 2004
    Posts
    18
    Hi Thanks to every one for quick response. Here is the Trace file contents. I don't have MetaLink Support, Please help any body.

    Dump file d:\oracle\admin\TEST\udump\TEST_ora_2932.trc
    Tue Dec 07 19:49:44 2004
    ORACLE V9.2.0.4.0 - Production vsnsta=0
    vsnsql=12 vsnxtr=3
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.4.0 - Production
    Windows 2000 Version 5.0 Service Pack 4, CPU type 586
    Instance name: TEST

    Redo thread mounted by this instance: 1

    Oracle process number: 13

    Windows thread id: 2932, image: ORACLE.EXE


    *** 2004-12-07 19:49:44.381
    *** SESSION ID:(9.3687) 2004-12-07 19:49:44.350
    ********** Internal heap ERROR 17114 addr=09F4C658 *********
    ***** Dump of memory around addr 09F4C658:
    9F4C450 00000000 00000000 [........]
    9F4C460 00000000 00000000 00000000 00000000 [................]
    9F4C470 00000000 00000000 00000000 AED81300 [................]
    9F4C480 00000000 00000000 00000000 00000000 [................]
    9F4C490 00000000 0013D8AE 00000000 00000000 [................]
    9F4C4A0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C4C0 00000000 00000000 00000000 AED81300 [................]
    9F4C4D0 00000000 00000000 00000000 00000000 [................]
    9F4C4E0 00000000 0013D8AE 00000000 00000000 [................]
    9F4C4F0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C510 00000000 00000000 00000000 AED81300 [................]
    9F4C520 00000000 00000000 00000000 00000000 [................]
    9F4C530 00000000 0013D8AE 00000000 00000000 [................]
    9F4C540 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C560 00000000 00000000 00000000 AED81300 [................]
    9F4C570 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C590 D00000C9 09F4BB4C 05410258 09F4F53C [....L...X.A.<...]
    9F4C5A0 000000C9 00000D51 00400D57 00000007 [....Q...W.@.....]
    9F4C5B0 00000000 00000001 00000000 0C651E00 [..............e.]
    9F4C5C0 000000C9 00000D58 00400D5B 00000004 [....X...[.@.....]
    9F4C5D0 00000001 00000001 00000000 0C661E00 [..............f.]
    9F4C5E0 000000C9 00000D43 00400D49 00000007 [....C...I.@.....]
    9F4C5F0 00000002 00000001 00000000 0C671E00 [..............g.]
    9F4C600 000000C9 00000D4A 00400D50 00000007 [....J...P.@.....]
    9F4C610 00000003 00000001 00000000 0000004C [............L...]
    9F4C620 D0000039 09F4C590 05410258 09F4F53C [9.......X.A.<...]
    9F4C630 00000004 0B43F9D8 0000013C 00000000 [......C.<.......]
    9F4C640 00000000 0000001C 00000000 00A6D3C0 [................]
    9F4C650 00A6D440 05410210 00000000 09F40214 [@.....A.........]
    9F4C660 05410BF0 05410210 09F4CA94 40000201 [..A...A........@]
    9F4C670 00000000 09F4F384 00000200 0013D8AE [................]
    9F4C680 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C6B0 00000000 0013D8AE 00000000 00000000 [................]
    9F4C6C0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C6E0 00000000 00000000 00000000 0013D8AE [................]
    9F4C6F0 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C720 00000000 AED81300 00000000 00000000 [................]
    9F4C730 00000000 00000000 00000000 0013D8AE [................]
    9F4C740 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C770 00000000 0013D8AE 00000000 00000000 [................]
    9F4C780 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C7A0 00000000 00000000 00000000 AED81300 [................]
    9F4C7B0 00000000 00000000 00000000 00000000 [................]
    9F4C7C0 00000000 0013D8AE 00000000 00000000 [................]
    9F4C7D0 00000000 00000000 00000000 00000000 [................]
    Repeat 1 times
    9F4C7F0 00000000 00000000 00000000 0013D8AE [................]
    9F4C800 00000000 00000000 00000000 00000000 [................]
    Repeat 2 times
    9F4C830 00000000 0013D8AE 00000000 00000000 [................]
    9F4C840 00000000 00000000 00000000 00000000 [................]
    9F4C850 00000000 00000000 [........]
    ******************************************************
    HEAP DUMP heap name="callheap" desc=05410210
    extent sz=0x424 alt=32767 het=32767 rec=0 flg=2 opc=6
    parent=05410BF0 owner=00000000 nex=00000000 xsz=0xe214
    EXTENT 0 addr=09F4C664
    Chunk 9f4c66c sz= 512 perm "perm " alo=512
    Chunk 9f4c86c sz= 376 perm "perm " alo=376
    Chunk 9f4c9e4 sz= 164 perm "perm " alo=152
    EXTENT 1 addr=09F4CA94
    Chunk 9f4ca9c sz= 4144 freeable "sql area " ds=09F4F210
    EXTENT 2 addr=09F4DAD8
    Chunk 9f4dae0 sz= 492 freeable "sql area " ds=09F4F210
    Chunk 9f4dccc sz= 560 freeable "library cache " ds=09F4F4C4
    EXTENT 3 addr=09F4DF08
    Chunk 9f4df10 sz= 4144 recreate "sql area " latch=00000000
    ds 9f4f210 sz= 19896 ct= 6
    b369610 sz= 4144
    b33efd0 sz= 4144
    9f4b02c sz= 2828
    9f4ca9c sz= 4144
    9f4dae0 sz= 492
    EXTENT 4 addr=09F4EF4C
    Chunk 9f4ef54 sz= 492 freeable "library cache " ds=09F4F4C4
    Chunk 9f4f140 sz= 560 recreate "library cache " latch=00000000
    ds 9f4f4c4 sz= 1612 ct= 3
    9f4dccc sz= 560
    9f4ef54 sz= 492
    EXTENT 5 addr=09F4F37C
    Chunk 9f4f384 sz= 432 perm "perm " alo=432
    Chunk 9f4f534 sz= 60 free " "
    Chunk 9f4f570 sz= 560 freeable "library cache " ds=09F4F9D4
    EXTENT 6 addr=09F4F7BC
    Chunk 9f4f7c4 sz= 608 perm "perm " alo=608
    Chunk 9f4fa24 sz= 428 recreate "library cache " latch=00000000
    ds 9f4f9d4 sz= 988 ct= 2
    9f4f570 sz= 560
    Total heap size = 13532
    FREE LISTS:
    Bucket 0 size=76
    Bucket 1 size=268
    Bucket 2 size=1036
    Total free space = 0
    UNPINNED RECREATABLE CHUNKS (lru first):
    PERMANENT CHUNKS:
    Permanent space = 0
    ******************************************************
    Hla: 0
    *** 2004-12-07 19:49:44.678
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [17114], [0x9F4C658], [], [], [], [], [], []
    No current SQL statement being executed.

    Thanks and Regards,
    SankarG

  3. #13
    Join Date
    May 2001
    Posts
    736
    For this particular type of error Contact oracle support if u have.

  4. #14
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    If no one else is going to say it.....

    sankar, How is it that (I assume) you're a DBA working for a company who is paying money to administer their database and yet you do not have access to Metalink. Would you mind telling us your companies name and where it's located at?

    I would advise you to seek another profession because you are doing a disservice to the company by being a fraud.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  5. #15
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

    Re: If no one else is going to say it.....

    Originally posted by OracleDoc
    sankar, How is it that (I assume) you're a DBA working for a company who is paying money to administer their database and yet you do not have access to Metalink. Would you mind telling us your companies name and where it's located at?

    I would advise you to seek another profession because you are doing a disservice to the company by being a fraud.
    and you expect us to read the trace file.

    i think I know the problem - you dont know what you are doing

  6. #16
    Join Date
    Oct 2004
    Posts
    18
    Hi all,

    Note that the Database is Test Database server not Production Database, and also I am a Programmer not DBA. I have little knowledge on Oracle DBA, and even I can't understand the trace files also. Please excuse me If u people felt that I am demanding. I am learning Oracle DBA, as a part of that I got this error. Otherwise I will formate the system, and try once, no issues.


    Thanks,
    Sankar

  7. #17
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I think if you report your company to Oracle saying they use the software with no license you will get a reward. Or try BSA, Business Software Alliance, www.bsa.org

  8. #18
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by davey23uk
    i wish my company would do this

    fire_idiots=true
    my databases would be fine then
    But then what would you do???
    Jeff Hunter

  9. #19
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    Now that IS funny =]

  10. #20
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: Re: If no one else is going to say it.....

    Originally posted by davey23uk
    i think I know the problem - you dont know what you are doing
    Happens to me a lot

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