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

[spicysudhi]

Hi

I am getting ORA-03113: end-of-file on communication channel error when I run a procedure.

It is not bcoz of network connectivity, since I am running the procedure on the server itself.

Suddenly it started today. can someone help me where to look for this.

regards,
sudhi

 

[spesknight]

It seems your connection to the db is dropped after you launch the procedure, or you opened your session before a restart of the db.
There could also be a problem in the db engine, try to look at the alert.log file

 

[spicysudhi]

procedure runs for sometime and then disconnects the session.

DB is not restarted, other sessions are alive and working.

alert log has no message except archive logs.

regards,
sudhi