Re: ORA-03113/ORA-03114

From what I can tell, they are kind of the catch-all of Oracle errors. Plainly, the connection between the client and the server has been interrupted, and the client doesn't know why.

For example, this is one case when we received these errors: Two PC's were accidentally configured with the same IP address. Because we were using the TCP/IP protocol with SQL*Net, every so often the two machines would lock up if they were used similtaneously (which of course, since it was during a test, :) they were). In this case, the underlying network would get confused and cause a disruption in the SQL*Net connection.

This is not the only reason for these errors, I'm sure. We have had to, in the past, connect to a remote database via TCP/IP. At times, when the links were very slow, the connection would time out, and the 3113 error would reappear. But, generically, I think that the connection between the Server and the Client has been interrupted due to reasons outside of the Oracle software.

Hope this helps,
Ed
dominio_at_domnet.com.br wrote:

> Does anyone know something about Oracle error messages
>ORA-03113 e ORA-03114?
> What could it be their causes?
 

> Daniela
> dominio_at_domnet.com.br
Received on Tue Sep 24 1996 - 00:00:00 CEST