ORA-3113

building reports webintelligence
1

Hi Team,

I have a report which is not working and gives ORA-3113-end of communication file error and the other reports are working fine.

Please help me out… :hb: :reallymad:

Regards,
Sai

saikrishnag21 :india: (BOB member since 2011-02-10)

2

The ORA-03113: end-of-file on communication channel error is a generic error. The ORA-03113 error when connecting suggests that the connection was established, but lost later, like a timeout.

There are many possible causes for the ORA-03113 error. It is a “catch-all” type error which means “I cannot communication with the Oracle shadow process.” This usually happens when the Oracle server process has died for some reason.

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
etc… etc… etc… - a lot of possible causes !!

How do I fix this ORA-03113 error?

Answer: Use the oerr utility to get the details for the ORA-03113 error:

ORA-03113: end-of-file on communication channel

Cause: The connection between Client and Server process was broken.

Action: There was a communication error that requires further investigation.

First, check for network problems and review the SQL*Net setup.
Also, look in the alert.log file for any errors.
Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

data_guy :us: (BOB member since 2006-08-19)

3

Thank You for the reply.

If only one report is not working fine does that mean that there is a problem in the SQLquery of the report.

Thanks,
Sai

saikrishnag21 :india: (BOB member since 2011-02-10)