ora-03113

[Ruudbern]

One of our applications running fine on oracle 8 runs in to ora-03113 (end of file on communication channel) errors on different places on different sql's when used with a oracle 9 server.

Sometimes after 1 minute sometimes after 20 minutes. This happens on more tahn 1 oracle 9 server.

Any idea where to look?

 

[Marco Kalter]

ORA-03113 usually means that the Oracle Server process for the current session has crashed. Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03113 error? Usually you will see an ORA-00600 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me?

 

[Ruudbern]

It took me some time to reproduce the error again. All morning every thing went wel. This afternoon i got the error 3 times in 10 minutes.

There is no trace file writen in the udump directory. But in the cdump directory somthing is added to the core.log. Is that of any use for u. It starts with:

Oracle9i Release 9.2.0.1.0 - Production
Process Id: 0x00000f94 Thread Id : 0x00000be8 Time : Fri Feb 18 13:07:11
Excp. Code: 0xc0000005 Excp. Type: ACCESS_VIO Flags: 0x00000000

------------------- Registers ----------------------------
eip = 004fb137 esp = 052cd730 ebp = 052cd764 edi = 00000c06 esi = 052f4141

etc.etc.