Oracle-L: Re: Errors in Alert Log

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 13 Mar 2002 11:29:24 -0800
Message-ID: <F001.00427B85.20020313112924@fatcity.com>

Ramon,
Two items to consider.
1. look up error on Metalink. Problem appears to be with your networking. The resolution is to detailed to list here. 2. Your logs might be to small for the load that you were doing at the time. Look at the times listed. You completed archiving log#3 seq#736 and started log#1 seq# 738 and began archiving log#2 seq# 737 all in the 2-3 second time frame. The load completed and then the system was quiet for 6 hours plus before it switched to log#3 seq# 739

read the resolution on Metalink.
ROR mª¿ªm

>>> com.banilejas_at_codetel.net.do 03/13/02 11:03AM >>>
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

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: Ron Rogers
  INET: RROGERS_at_galottery.org

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 - 13:29:24 CST

Re: Errors in Alert Log - 12571