DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: alert log message

  1. #1
    Join Date
    May 2001
    Posts
    57

    Unhappy

    There are two things which I felt skeptical about when i was checking the alert logs.
    firstly it is an internal error code retruned and secondly a message of session softspace exceeded in the user trace file. I have pasted the alert log text with this. Can anyone please let me know if this can be harmful to the database and how to overcome. What is the reason behind this? I would appreciate if anybody can throw some light on this.
    1. It has also given a memory dump in the trace file
    Mon Jan 14 14:53:26 2002
    Errors in file /software/oracle/home/admin/ipmtdb/udump/ipmtdb_ora_3051.trc:
    ORA-00600: internal error code, arguments: [12333], [0], [3], [81], [], [], [], []
    Mon Jan 14 14:54:18 2002
    Errors in file /software/oracle/home/admin/ipmtdb/udump/ipmtdb_ora_3055.trc:
    ORA-00600: internal error code, arguments: [12333], [0], [3], [81], [], [], [], []
    Mon Jan 14 14:54:28 2002
    Errors in file /software/oracle/home/admin/ipmtdb/udump/ipmtdb_ora_3057.trc:
    ORA-00600: internal error code, arguments: [12333], [0], [3], [81], [], [], [], []
    Tue Jan 15 00:38:09 2002
    Errors in file /software/oracle/home/admin/ipmtdb/udump/ipmtdb_ora_3339.trc:
    ORA-00600: internal error code, arguments: [12333], [0], [3], [81], [], [], [], []

    partial contents of trace file is
    ump file /software/oracle/home/admin/dbname/udump/sidname_ora_18927.trc
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production
    ORACLE_HOME = /software/oracle/home
    System name: SunOS
    Node name: hostname
    Release: 5.7
    Version: Generic_106541-02
    Machine: sun4u
    Instance name: sidname
    Redo thread mounted by this instance: 1
    Oracle process number: 11
    Unix process pid: 18927, image: oracle@hostname (TNS V1-V3)

    *** SESSION ID:(10.9193) 2002.01.09.00.38.09.000
    *** 2002.01.09.00.38.09.000
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [12333], [0], [3], [81], [], [], [], []
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp()+160 CALL ksedst()+0 230 ? 1 ? FFBEDB34 ?
    FFBED5D8 ? FFBED5BC ? 0 ?
    kgeriv()+196 PTR_CALL 00000000 3 ? 0 ? 0 ? 258 ? 3 ? 302D ?
    kgesiv()+96 CALL kgeriv()+0 165545C ? 16D3DEC ? 12851EC ?
    3 ? FFBEE148 ? 1647600 ?
    ksesic3()+48 CALL kgesiv()+0 165545C ? 16D3DEC ? 302D ?
    3 ? FFBEE148 ? 2 ?
    opitsk()+2164 CALL ksesic3()+0 302D ? 0 ? 0 ? 0 ? 3 ? 0 ?
    opiino()+1720 CALL opitsk()+0 0 ? 1656D74 ? 16595F4 ? 0 ?
    0 ? 0 ?
    opiodr()+5336 PTR_CALL 00000000 FFBEF940 ? 1657F88 ?
    1657C00 ? 16BAA58 ? 0 ? 0 ?
    opidrv()+1232 CALL opiodr()+0 12B3C60 ? FFBEF564 ?
    16554C4 ? 1659400 ? 13691C2 ?
    0 ?
    sou2o()+20 CALL opidrv()+0 3C ? FFBEF654 ? 16554C4 ?
    2F6C6F67 ? 0 ? 2F ?
    main()+160 CALL sou2o()+0 FFBEF950 ? 3C ? 4 ?
    FFBEF940 ? 1663DB0 ?
    1663DB0 ?
    _start()+220 CALL main()+0 0 ? FFBEFAFC ? 16AA8B0 ?
    1654800 ? 0 ? 0 ?
    ----- Argument/Register Address Dump -----
    Argument/Register addr=ffbedb34. Dump of memory from 0xFFBEDAF4 to 0xFFBEDC34
    FFBEDAE0 726E616C 206F7220 66617461
    FFBEDB00 6C206572 726F720A 00000000 00000000 00000000 00000000 00000000 00000000



    2.
    software/oracle/home/admin/bcedev2/udump/sidname_ora_13826.trc
    Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
    With the Partitioning option
    JServer Release 8.1.6.0.0 - Production
    ORACLE_HOME = /software/oracle/home
    System name: SunOS
    Node name: hostname
    Release: 5.6
    Version: Generic_105181-05
    Machine: sun4u
    Instance name: sidname
    Redo thread mounted by this instance: 1
    Oracle process number: 8
    Unix process pid: 13826, image: oracle@hostname (TNS V1-V3)

    *** SESSION ID:(10.29716) 2002-01-09 09:00:07.762
    Session 9 exceeded soft sessionspace limit of 0x100000 bytes.

  2. #2
    Join Date
    Jan 2002
    Posts
    8

    alert_log

    "Session 9 exceeded soft sessionspace limit of 0x100000 bytes."

    I think this is just a warning

    try to increase:

    JAVA_MAX_SESSIONSPACE_SIZE
    JAVA_SOFT_SESSIONSPACE_LIMIT
    JAVA_SOFT_SESSIONSPACE_LIMIT

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