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: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:
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
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@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
