Tuesday 21 January 2014

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

This error pretty much means that your connection has clutched its chest and died.

For some reason, your client machine and the database server are acting like an old married couple and have stopped talking to each other.

That reason could be one of a rather long list:
  1. Has your server crashed?   -  Try to ping the server
  2. Has someone pulled out your network cable?   -  Try to ping the server
  3. Was your process killed at the O/S level?   - Contact your Sys Admin
  4. Is your Windows log full?  -  Check yourself or Contact your Sys Admin
  5. Maybe there is an Oracle internal error?  - Need to check Alert log , if you are a DBA check it yourself to ask your DBA for HELP!!
My advice is this do not overlook the obvious.

This error is sometimes caused by the simplest of things.

If, however, it is caused by an Oracle internal error, look to your alert log for further information.

Solution:- Wait for some time and try again

No comments:

Post a Comment