FAQ
Hi,

Database: 9.2.0.5
Middle tier: 9iAS (1.0.2.2.2)

Sometimes our Oracle applications database background processes start
dying, leaving behind trace files in udump directory.
This happens almost every minute till we bounce the middle tier.

The alert log says something like this:

Errors in file /u01/home/oracle/admin/BAN1/udump/ban1_ora_104222.trc:
Mon Jun 21 11:37:12 2004
Errors in file /u01/home/oracle/admin/BAN1/udump/ban1_ora_72416.trc:
Mon Jun 21 11:38:17 2004
Errors in file /u01/home/oracle/admin/BAN1/udump/ban1_ora_140886.trc:

And the udump trace file says:

SESSION ID:(365.6297) 2005-01-04 20:08:51.176

FATAL ERROR IN TWO-TASK SERVER: error = 12592
2005-01-04 20:08:51.191
ksedmp: internal or fatal error
Current SQL statement for this session:
begin dbms_session.reset_package; end;
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- --------------------

ksedmp+0148 bl ksedst 1027C5204 ?
opitsk+0970 bl ksedmp 2029D1C04 ?
opiino+0790 bl opitsk 000000000 ? 000000000 ?
opiodr+08e8 bl _ptrgl
opidrv+032c bl opiodr 3C104630B0 ? 400000000 ?
FFFFFFFFFFFFEE0 ?

0027B8718 ?
sou2o+0028 bl opidrv 3C00212E38 ? 4A004BBD0 ?
FFFFFFFFFFFFEE0 ?

main+0138 bl 01FD5D8C

Has anybody faced a similar problem. If yes how did you overcome it.
I have opened a tar with Oracle on this 4 times in last year.

Since this problem has happened 4 times last year and everytime we
bounce the middle tier the problem goes away.
Currently tar is open with Oracle on this.

thanks
amit

Search Discussions

  • Tim Gorman at Jan 5, 2005 at 8:56 pm
    Amit,

    Searching MetaLink (advanced search, set checkbox for "bugs") using the
    keywords "12592 TWO-TASK opitsk opiino opiodr opidrv sou2o main" (i.e.
    phrases from the error message, plus function names on the error stack)
    returns a lot of hits on bugs.

    Try it out to see if anything jumps out at you, but your best bet is to go
    ahead and log a TAR...

    Good luck!

    -Tim
    on 1/5/05 1:56 PM, amit poddar at amit.poddar_at_yale.edu wrote:

    Hi,

    Database: 9.2.0.5
    Middle tier: 9iAS (1.0.2.2.2)

    Sometimes our Oracle applications database background processes start
    dying, leaving behind trace files in udump directory.
    This happens almost every minute till we bounce the middle tier.

    The alert log says something like this:

    Errors in file /u01/home/oracle/admin/BAN1/udump/ban1_ora_104222.trc:
    Mon Jun 21 11:37:12 2004
    Errors in file /u01/home/oracle/admin/BAN1/udump/ban1_ora_72416.trc:
    Mon Jun 21 11:38:17 2004
    Errors in file /u01/home/oracle/admin/BAN1/udump/ban1_ora_140886.trc:

    And the udump trace file says:

    *** SESSION ID:(365.6297) 2005-01-04 20:08:51.176
    FATAL ERROR IN TWO-TASK SERVER: error = 12592
    *** 2005-01-04 20:08:51.191
    ksedmp: internal or fatal error
    Current SQL statement for this session:
    begin dbms_session.reset_package; end;
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- --------------------
    ----------------------------
    ksedmp+0148 bl ksedst 1027C5204 ?
    opitsk+0970 bl ksedmp 2029D1C04 ?
    opiino+0790 bl opitsk 000000000 ? 000000000 ?
    opiodr+08e8 bl _ptrgl
    opidrv+032c bl opiodr 3C104630B0 ? 400000000 ?
    FFFFFFFFFFFFEE0 ?
    0027B8718 ?
    sou2o+0028 bl opidrv 3C00212E38 ? 4A004BBD0 ?
    FFFFFFFFFFFFEE0 ?
    main+0138 bl 01FD5D8C

    Has anybody faced a similar problem. If yes how did you overcome it.
    I have opened a tar with Oracle on this 4 times in last year.

    Since this problem has happened 4 times last year and everytime we
    bounce the middle tier the problem goes away.
    Currently tar is open with Oracle on this.

    thanks
    amit

    --
    http://www.freelists.org/webpage/oracle-l
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedJan 5, '05 at 2:55p
activeJan 5, '05 at 8:56p
posts2
users2
websiteoracle.com

2 users in discussion

Tim Gorman: 1 post Amit poddar: 1 post

People

Translate

site design / logo © 2022 Grokbase