ORA-00600 Errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-00600 Errors

  1. #1
    Join Date
    Sep 2000
    Posts
    384
    I get these errors and the database crashes ??
    Oracle says that this is memory heap corruption ??
    HAs anyone encountred the same

    Any help will be of much use

    Wed Dec 19 19:58:29 2001
    Errors in file /opt/app/oracle/admin/SPRD/udump/sprd_ora_11806.trc:
    ORA-00600: internal error code, arguments: [17114], [26054788], [], [], [], [],
    [], []
    Radhakrishnan.M

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    This is a memory corruption error and could result due to the heap corruption. To further investigate this problem set the event in your ini.ora and bounce the instance. Such that when it were to occour next time it would generate a detail trace under udump. Then contact oracle.

    Code:
      event="10235 trace name context forever, level 1"
    My personal undestanding of this problem is that the corruption could have occoured at Call heap, PGA heap, session heap or SGA heap. The event trace can only pin point the exact location. On some occassions increasing the java_pool_size and shared_pool_size would help to solve the problem.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Sep 2000
    Posts
    384
    ******************************************************
    HEAP DUMP heap name="pga heap" desc=0x185e1d8
    extent sz=0x213c alt=40 het=32767 rec=0 flg=3 opc=3
    parent=0 owner=0 nex=0 xsz=0xfe28
    EXTENT 0
    Chunk 1aa72d4 sz= 65056 free " "
    EXTENT 1
    Chunk 1946d84 sz= 8500 free " "
    EXTENT 2
    Chunk 195107c sz= 8500 free " "
    EXTENT 3
    Chunk 195530c sz= 8500 free " "
    EXTENT 4
    Chunk 1a9749c sz= 65056 free " "
    EXTENT 5

    That's indeed pga heap .Do you know any work around to ensure that the database does not crashes ...
    Radhakrishnan.M

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Try increasing the shared_pool_size. Also interested to know about the dbversion and os.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Sep 2000
    Posts
    384
    I have doubled the shared_pool_size (40MB)
    The oracle version is 8.1.6.0.0 and OS is sun solaris 5.7
    Radhakrishnan.M

  6. #6
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    8.1.6.0 is quiet buggy. I would suggest that you put the patch set 3 to get it upgraded to 8.1.6.3. It was pretty stable.

    Consider doing this upgrade rather than breaking your heads. This holidays is the great time to call your down time...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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