ORA-03113 end of file comm. error - Why???

2001-07-16 Thread Csillag Zsolt



Hi,

I have a program that converts records from d-base to Oracle 8.1.7.

I works perfectly but about once a week it gives the Ora-03113 error
and the whole Oracle freezes, we have to restart the whole server.

There is no logic in it since if I repeat the converting procedure 100 times
with the same data, maybe all 100 will be good, but there is a chance that
e.g. the 97-th will give this error.

Thank you

Zsolt Csillag,
Hungary

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Csillag Zsolt
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



RE: ORA-03113 end of file comm. error - Why???

2001-07-16 Thread MacGregor, Ian A.

The Ora-3113 is because the database crashed; your client machine no longer had a 
database to communicate with.  You should find errors in the databases alert log; a 
trace file and a core dump should have been produced.

It could be an OS software problem, an Oracle software problem or possibly a hardware  
problem.The trace files are instrumental in determining  what went wrong.

Were there any OS system events captured at the same time?

Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]  
  
-Original Message-
Sent: Monday, July 16, 2001 5:06 PM
To: Multiple recipients of list ORACLE-L




Hi,

I have a program that converts records from d-base to Oracle 8.1.7.

I works perfectly but about once a week it gives the Ora-03113 error
and the whole Oracle freezes, we have to restart the whole server.

There is no logic in it since if I repeat the converting procedure 100 times
with the same data, maybe all 100 will be good, but there is a chance that
e.g. the 97-th will give this error.

Thank you

Zsolt Csillag,
Hungary

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Csillag Zsolt
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).