VERIFIED SOLUTION i
X

Resolve 'ORA-03113: end-of-file on communication channel' in Confirm

Issue

You receive the error 'ORA-03113: end-of-file on communication channel' either from the Confirm® host application or within Confirm's error log files.

This error may well be accompanied by other errors such as:

ORA-01041 internal error. hostdef extension doesn't exist
ORA-03114 not connected to ORACLE
ORA-01012 not logged on  

Confirm Technical support will need as much information as possible to determine what caused the error.

Cause

The connection between Client and Server process was broken, however ORA-03113 is a more generic error.

For example, ORA-03113 could be signaled for any of these scenarios:
  • Server machine crashed.
  • Your server process was killed at O/S level.
  • Network problems.
  • Oracle internal errors / aborts on the server.
  • Client incorrectly handling multiple connections.

Resolution

UPDATED: June 23, 2017


Further investigation will almost inevitably be required, however, at Oracle/Database Administrator (DBA) level:
  1. Firstly check for network problems and troubleshoot Oracle SQL*Net connnectivity.
  2. Look in the Oracle alert.log file for any errors.
  3. Test to see whether the server process is dead and whether a trace file was generated at failure time.
  4.  Check for a trace file from the failed session in Oracle's USER_DUMP_DEST and BACKGROUND_DUMP_DEST directories. Does a particular statement reproduce this problem or is it random?
  5. Use SQL_TRACE on the session to find the problem statement. Again does a particular statement reproduce this problem or is it random?

Environment Details

Product affected: Confirm®
Product feature: Application Infrastructure
 

Downloads

  • No Downloads