Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Posts
    25

    Unanswered: error in alert log

    Hello there,

    I found the following error in our alert log:

    Tue Dec 9 15:12:21 2003
    Errors in file /export/home/dump/udump/hrdb_ora_4743.trc:
    ORA-00600: internal error code, arguments: [6022], [9900], [], [], [], [], [], [
    ]
    Tue Dec 9 15:15:34 2003
    Thread 1 advanced to log sequence 13666
    Current log# 3 seq# 13666 mem# 0: /disk20/imis/human_resources/hrdbredo3a.log
    Current log# 3 seq# 13666 mem# 1: /disk21/imis/human_resources/hrdbredo3b.log
    Current log# 3 seq# 13666 mem# 2: /disk30/imis/human_resources/hrdbredo3c.log

    and produce the following trace file:

    Tue Dec 9 15:12:21 2003
    *** SESSION ID23.428) 2003.12.09.15.12.21.000
    ksedmp: internal or fatal error
    ORA-00600: internal error code, arguments: [6022], [9900], [], [], [], [], [], [
    ]
    Current SQL statement for this session:
    delete from attendance_transactions
    where to_char(attendance_date,'YYYYMM') = '200302'
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp()+136 CALL ksedst()+0 3F0 ? 1 ? EFFFB6B4 ?
    EFFFB158 ? EFFFB13C ? 0 ?
    kgeriv()+196 PTR_CALL 3 ? 0 ? 0 ? 258 ? 1 ? 1786 ?
    kgeasi()+164 CALL kgeriv()+0 100DB4C ? 1071EB4 ? D8C738 ?
    1 ? EFFFBC78 ? 10056E4 ?
    kdidelduc()+320 CALL kgeasi()+0 100DB4C ? 1071EB4 ? 1786 ?
    2 ? 1 ? 0 ?
    kaudel()+2172 CALL kdidelduc()+0 100DA64 ? EFFFC324 ? 2 ?
    100D800 ? 82007B54 ? 2 ?
    delrow()+2544 CALL kaudel()+0 1079844 ? EFFFC2B0 ?
    100DBB4 ? 0 ? 1047860 ?


    Another comes today,

    Wed Dec 10 13:38:33 2003
    Errors in file /export/home/dump/udump/hrdb_ora_7651.trc:
    ORA-07445: exception encountered: core dump [EF623C3C] [SIGSEGV] [Address not ma
    pped to object] [8] [] []
    Wed Dec 10 13:43:09 2003
    Thread 1 advanced to log sequence 13752
    Current log# 2 seq# 13752 mem# 0: /disk20/imis/human_resources/hrdbredo2a.log
    Current log# 2 seq# 13752 mem# 1: /disk21/imis/human_resources/hrdbredo2b.log
    Current log# 2 seq# 13752 mem# 2: /disk30/imis/human_resources/hrdbredo2c.log
    Wed Dec 10 13:55:01 2003

    and trace file contents
    Wed Dec 10 13:38:33 2003
    *** SESSION ID22.1568) 2003.12.10.13.38.33.000
    Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x
    8Cannot find symbol in /usr/lib/libnsl.so.1.
    , PC: EF623C3C
    Wed Dec 10 13:38:33 2003
    ksedmp: internal or fatal error
    ORA-07445: exception encountered: core dump [EF623C3C] [SIGSEGV] [Address not ma
    pped to object] [8] [] []
    Current SQL statement for this session:
    SELECT f.aa, f.bb, f.cc, f.last_name, f.first_name, f.middle_name,
    f.amount, LPAD(g.control_number,8,' '), f.dd, f.ee, f.ff
    FROM
    (SELECT '0309' aa,LPAD(' ',12,' ') bb, LPAD(' ',10,' ') cc,RPAD(SUBSTR(a.last_na
    me,1,17),17,' ') last_name,
    RPAD(SUBSTR(a.first_name,1,17),17,' ') first_name,SUBSTR(a.middle_n
    ame,1,1) middle_name,
    SUBSTR(LPAD(TO_CHAR(SUM(d.amount),'99999.99'),9,' '),2,8) amount
    ,LPAD(' ',8,' ') dd,RPAD('YAZAKI-TORRES MFG., INC.',40,' ') ee,LPAD
    (' ',15,' ') ff
    ,max(d.date_granted) date_granted

    FROM file_201 a,
    (select a.id_number, max(b.date_granted) date_granted, a.amount
    from payroll_backup1119 a, loans b
    where a.id_number = b.id_number
    -- and a.id_number = 850355
    and a.payroll_transaction_code = b.payroll_transaction_code
    and b.payroll_transaction_code = 'B15'
    and a.pay_date in ('19-SEP-03','26-SEP-03','03-OCT-03','10-OCT-03
    ','15-SEP-03','30-SEP-03')
    group by a.id_number, a.amount) d

    WHERE a.id_number = d.id_number
    -- and a.id_number = 850355
    AND a.company_code IN ('YTMI','YTMCI','TTECH','YTPM')
    GROUP BY d.id_number,RPAD(SUBSTR(a.last_name,1,17),17,' '),
    RPAD(SUBSTR(a.first_name,1,17),17,' '),
    SUBSTR(a.middle_name,1,1)) f,
    loans g, file_201 h
    WHERE g.id_number = h.id_number
    AND RPAD(SUBSTR(f.last_name,1,17),17,' ') || RPAD(SUBSTR(f.first_name,1,17),
    17,' ') || SUBSTR(f.middle_name,1,1)
    =
    RPAD(SUBSTR(h.last_name,1,17),17,' ') || RPAD(SUBSTR(h.first_name,1,17),
    17,' ') || SUBSTR(h.middle_name,1,1)
    AND f.date_granted = g.date_granted
    order by f.last_name
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    Cannot find symbol in /usr/lib/libnsl.so.1.
    ksedmp()+136 CALL ksedst()+0 3B8 ? 1 ? EFFFC49C ?
    EFFFBF40 ? EFFFBF24 ? 0 ?
    ssexhd()+368 CALL ksedmp()+0 3 ? 0 ? 1 ? EFFFC9B4 ? 1 ?
    7 ?
    EF638A0C PTR_CALL B ? 1011800 ? EFFFCD48 ?
    1011800 ? 0 ? 0 ?
    rsoGetColumns()+924 CALL B ? EFFFD000 ? EFFFCD48 ? 0

    Can anybody gave an idea why this happened? any suggestions are highly appreciated...


    tia,
    ynoel
    Last edited by ynoel; 12-10-03 at 08:02.

  2. #2
    Join Date
    Nov 2003
    Posts
    19
    These are internal ora erros and u shuld contact support or open an itr on metalink if these errors happen frequently.

  3. #3
    Join Date
    Nov 2003
    Location
    Bangalore, INDIA
    Posts
    333

    Thumbs up

    Hi,

    This error is indicating that the most recent version of the block is NOT on disk. During media recovery it was expecting an specific SCN but found that the block itself has a different SCN so recovery was stuck.

    Check the ORA-600 3020 trace file to identify the Redo SCN, the SCN expected on block and the SCN on buffer.
    SATHISH .

Posting Permissions

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