Results 1 to 3 of 3

Thread: need help

  1. #1
    Join Date
    Sep 2008
    Posts
    10

    Unanswered: need help

    I have a problem with my oracle database. suddenly shutdown immediate.. when i go through alert_database.log, then i got errors which is mentioned in financial_s000_27287.trc and financial_pmon_11637.trc..The error in file financial_s000_27287.trc as below

    Redo thread mounted by this instance: 1
    Oracle process number: 10
    Unix process pid: 27287, image: financial@esaga (S000)

    *** 2008-12-02 13:30:44.303
    *** SESSION ID429.41202) 2008-12-02 13:30:44.302
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    *** 2008-12-02 13:31:05.158
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    *** SESSION ID563.16228) 2008-12-02 13:31:11.618
    Internal Error 3113 occured in qmf
    *** SESSION ID429.41202) 2008-12-02 13:31:11.630
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    *** SESSION ID563.16228) 2008-12-02 13:31:16.269
    Internal Error 3113 occured in qmf
    Internal Error 3113 occured in qmf
    *** SESSION ID429.41202) 2008-12-02 13:31:16.306
    ********** Internal heap ERROR 17114 addr=3c9fee5f8 *********
    ***** Dump of memory around addr 3c9fee5f8:
    3C9FEE3F0 58585858 58585858 [XXXXXXXX]
    .
    .
    .
    word xsoqsqlusebindvariables_ [10374A270, 10374A274) = 00000350
    word xsoqsqlpreparestmtcachesize_ [10374A274, 10374A278) = 00000351
    word xsoqsqlresultsetcachesize_ [10374A278, 10374A27C) = 00000352
    word xsoqdebugoutput_ [10374A27C, 10374A280) = 00000353
    word xsoqcursoruserowcache_ [10374A280, 10374A284) = 00000354
    word xsoqcursormaxrowstocacheperreq_ [10374A284, 10374A288) = 00000355
    word xsoqcursormaxtimeforpartialcache_ [10374A288, 10374A28C) = 00000356
    word xsoqsourcetrace_ [10374A28C, 10374A290) = 00000357
    struct _xsawpga * xsawpga_ [10374A290, 10374A298) = 00000000 00000000
    struct _xsoqpga * xsoqpga_ [10374A298, 10374A2A0) = 00000000 00000000
    word ksmpgl_ [10374A2A0, 10374A2A4) = 00000000
    ----- Dump of the Fixed SGA -----
    ***** SGA not mapped *****
    ----- Dump of the Fixed UGA -----
    ***** no UGA *****
    KSTDUMP: SGA no longer mapped
    OPIRIP: Uncaught error 603. Error stack:
    ORA-00603: ORACLE server session terminated by fatal error
    ORA-00603: ORACLE server session terminated by fatal error
    ORA-00600: internal error code, arguments: [17114], [0x3C9FEE5F8], [], [], [], [], [], []
    ORA-03113: end-of-file on communication channel
    ORA-00600: internal error code, arguments: [17114], [0x3C9FEE5F8], [], [], [], [], [], []

    and the error in file financial_pmon_11637.trc
    as below

    *** SESSION ID1.1) 2008-12-02 13:31:25.847
    ********** Internal heap ERROR 17147 addr=3c9fee5d0 *********
    ***** Dump of memory around addr 3c9fee5d0:
    3C9FEE3D0 58585858 58585858 58585858 58585858 [XXXXXXXXXXXXXXXX]
    Repeat 19 times
    3C9FEE510 00000000 00005858 58585858 58585858 [......XXXXXXXXXX]
    3C9FEE520 58585858 58585858 58585858 58585858 [XXXXXXXXXXXXXXXX]
    Repeat 5 times
    3C9FEE580 00000000 58585858 58585858 58585858 [....XXXXXXXXXXXX]
    3C9FEE590 58585858 58585858 58585858 58585858 [XXXXXXXXXXXXXXXX]
    Repeat 35 times
    Recovery state: ds=38006d3f0 rtn=0 *rtn=0 szo=1 u4o=0 hdo=0 off=2
    Szo:
    3c9fea6f8 B38F0000003ED9
    UB4o:
    Hdo:
    Off:
    38006d488 3c9fe2958
    38006d480 3c9fe2958
    Hla: 1
    ************************************************** ****
    HEAP DUMP heap name="large pool" desc=38006d3f0
    extent sz=0xfe0 alt=200 het=32767 rec=9 flg=-125 opc=3
    parent=0 owner=0 nex=0 xsz=0x1000000
    EXTENT 0 addr=3c9000000
    Chunk 3c9000040 sz= 16279048 free " "
    Chunk 3c9f86648 sz= 16088 freeable "session heap " ds=3d71e6948

    .
    .
    .
    NO DETACHED BRANCHES.
    NO DETACHED NETWORK CONNECTIONS.
    CLEANUP STATE OBJECTS:
    ----------------------------------------
    SO: 3ca0a4ab8, type: 1, owner: 0, flag: INIT/-/-/0x00
    (cleanup state object) description: instance enqueue anchor state
    latch: 0x38000a2b8
    ----------------------------------------
    SO: 3cb21f6f8, type: 6, owner: 3ca0a4ab8, flag: INIT/-/-/0x00
    (enqueue) TA-00000006-00000001 DID: 0001-000E-0000000C
    lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
    res: 3cb3e3100, mode: X, prv: 3cb3e3110, sess: 0
    ----------------------------------------
    SO: 3ca0a4b18, type: 1, owner: 0, flag: INIT/-/-/0x00
    (cleanup state object) description: switchable channel handle anch
    latch: 0x38000b868
    ----------------------------------------
    SO: 3ca0a4b78, type: 1, owner: 0, flag: INIT/-/-/0x00
    (cleanup state object) description: TT shared object cleanup SO
    latch: 0x380018098
    ----------------------------------------
    SO: 3ca0a4bd8, type: 1, owner: 0, flag: INIT/-/-/0x00
    (cleanup state object) description: SS shared object cleanup SO
    latch: 0x3800187d0
    END OF SYSTEM STATE
    (k2g table)
    error 600 detected in background process
    ORA-00600: internal error code, arguments: [17147], [0x3C9FEE5D0], [], [], [], [], [], []

    Plz help.
    Tq.

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Look at the 600 error ... this is an "in memory" error ... a memory heap
    got overriden ... No data has been harmed or lost. They say that this is normally a 1 time occurrance, but to
    try to reproduce it as well as checking the system memory for errors


    https://metalink2.oracle.com/metalin...,0,1,helvetica

    HTH
    Gregg

  3. #3
    Join Date
    Sep 2008
    Posts
    10
    Quote Originally Posted by gbrabham
    Look at the 600 error ... this is an "in memory" error ... a memory heap
    got overriden ... No data has been harmed or lost. They say that this is normally a 1 time occurrance, but to
    try to reproduce it as well as checking the system memory for errors


    https://metalink2.oracle.com/metalin...,0,1,helvetica

    HTH
    Gregg
    thanks gbrabham... i will update here as soon as possible..

Posting Permissions

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