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

Thread: Internal Error

Hybrid View

  1. #1
    Join Date
    Aug 2002
    Posts
    176

    Internal Error

    Hi ,

    Database is Oracle 8.1.4 on Sun Solaris 5.8, OLTP environment.

    we have a table of 10mb which is frequently used, Its inserted , deleted, selected.

    But yesterday we got errors on four similar trace files depicting the same error. Trace file content is displayed below.

    ================================

    *** SESSION ID:(320.34060) 2004-06-16 20:11:13.499
    FATAL ERROR IN TWO-TASK SERVER: error = 12592
    *** 2004-06-16 20:11:13.515
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    select count(recordhandle) from iway_jmssessionstorejmsstore
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp()+168 CALL ksedst()+0 188 ? 1 ? FFBED670 ?
    FFBED114 ? FFBED0F8 ? 0 ?
    opitsk()+5344 CALL ksedmp()+0 2 ? 0 ? 0 ? 800 ? 941D5C44 ?
    0 ?
    opiino()+1792 CALL opitsk()+0 0 ? 1A15E10 ? 1A1888C ? 0 ?
    0 ? 3130 ?
    opiodr()+5748 PTR_CALL 00000000 FFBEF9F8 ? 80005000 ?
    1A17000 ? 1A4E560 ? 0 ?
    1A02E80 ?
    opidrv()+1308 CALL opiodr()+0 16632B0 ? FFBEF5FC ?
    1A18400 ? 0 ? 16983CA ?



    Kindly adivce on what could be the error and how to recitfy it.
    They have an index in thsi table whihc is just three columns. Is the index necessary , cos per second three to five records gets inserted and deleted. So at a specific point only max of 5 records will be there. But suddenly the waits have increased and at peak times around 1500 records stay in as a stack queue.

    Your views are highly appreciated
    Success Consists of Getting Up Just One More Time Than You've Fallen Down
    Be Blessed

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: Internal Error

    Oracle 8.1.4?

    Is that a typo or was this version relaesed for some countries only?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    TNS-12592 TNS:bad packet

    Cause: An ill-formed packet has been detected by the TNS software.

    Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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