ORA-03113 End-of-file... with test script

[RobBlom]

I see many postings with this issue but no solutions to it. :^(

I have a database with several test schemas. When I use PlSql Developer to debug any procedure on one specific schema I always get "ORA-03113 End-of-file on communication channel". I never get this problem on any other schema in the same database.

This problem schema is a copy of a schema from a live site. When trying to us PlSql Developer to debug any procedure on the live site (on a totally separate database) then I get the exact same error.

Clearly there is something about this schema causing a problem with PL/SQL Developers "Test Script" facility.

Please assist as it is very important that we be able to debug on this schema.

 

[Marco Kalter]

Note that ORA-03113 is a very generic error message, so you will see it a lot. It implies that the server process for the session has crashed, and there is a plethora of Oracle Bugs that can cause this.

Can you check if a user trace dump file exist on the database server that corresponds to this ORA-03113 error? Usually you will see an ORA-00600 error here, with some error codes that may help us find the cause of the problem. If it does, can you send it to me?

 

[BWendling]

Normally it helps to update to the latest patchset. Which version are you on (v$instance)?