Oracle-L: Errors in Alert Log

From: Ramon E. Estevez <com.banilejas_at_codetel.net.do>
Date: Wed, 13 Mar 2002 08:03:49 -0800
Message-ID: <F001.004274CF.20020313080349@fatcity.com>

Hi List,

Checking the alert log file I found this error

ARC2: Completed archiving log# 3 seq# 736 Mon Mar 11 07:46:18 2002
Thread 1 advanced to log sequence 738
Mon Mar 11 07:46:18 2002
ARC1: Beginning to archive log# 2 seq# 737 Mon Mar 11 07:46:18 2002
Current log# 1 seq# 738 mem# 0: D:\ORACLE\REDO01.LOG Current log# 1 seq# 738 mem# 1: D:\ORACLE\REDO01A.LOG Mon Mar 11 07:46:19 2002
Errors in file D:\Oracle\admin\IBOR\trace\udump\ORA02316.TRC:

Mon Mar 11 07:46:20 2002
ARC1: Completed archiving log# 2 seq# 737 Mon Mar 11 07:46:48 2002
Errors in file D:\Oracle\admin\IBOR\trace\udump\ORA01440.TRC:

Mon Mar 11 14:19:22 2002
Thread 1 advanced to log sequence 739
Current log# 3 seq# 739 mem# 0: D:\ORACLE\ORADATA\IBOR\REDO03.LOG Mon Mar 11 14:19:22 2002

In the user trace file found this

Redo thread mounted by this instance: 1

Oracle process number: 21

Windows thread id: 1440, image: ORACLE.EXE

2002-03-11 07:46:48.427
SESSION ID:(57.1472) 2002-03-11 07:46:48.302 FATAL ERROR IN TWO-TASK SERVER: error = 12571
2002-03-11 07:46:48.443 ksedmp: internal or fatal error Current SQL statement for this session: INSERT INTO RECEPCION(GRUPO,COMPANIA,VENDEDOR,AGENCIA,RECEPCION,FECHA,FACTURADA) VALUES (:1,:2,:3,:4,:5,:6,:7) RETURNING ROWID,GRUPO,COMPANIA,VENDEDOR,AGENCIA,RECEPCION,FECHA,FACTURADA INTO :8,:9,:10,:11,:12,:13,:14,:15 ----- Call Stack Trace ----- calling call entry argument values in hex location type point (? means dubious value) -------------------- -------- -------------------- -
_ksedmp+a8 CALLrel _ksedst+0

0BE47C

_opitsk+f50                      CALLrel  _ksedmp+0                        2
_opiino+50c                      CALLrel  _opitsk+0                        0
_opiodr+506                      CALLreg  00000000

3C 4

B0BFBF8

_opidrv+384                      CALLrel  _opiodr+0

3C 4

B0BFBF8

                                                                           0
_sou2o+19                        CALLrel  _opidrv+0
_opimai+10c                      CALLrel  _sou2o+0
_OracleThreadStart_at_4+49f         CALLrel  _opimai+0                        2

B0BFE74
77E87587                         CALLreg  00000000

----- Argument/Register Address Dump ----- Argument/Register addr=b0be47c.
Dump of memory from 0xB0BE43C to 0xB0BE57C

Thinking of adding other redo log group.

What do you think ?

Ramon

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ramon E. Estevez
  INET: com.banilejas_at_codetel.net.do

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Mar 13 2002 - 10:03:49 CST

Errors in Alert Log - 12571