ORA-03113 End of file on communication channel

[KevinRyan]

Yesterday everything was fine.

Today whenever ANY of the developers here try to create or replace an object with PL/SQL Developer we are presented with the "End of file on communication channel." error.

Basically whenever we try to create or replace ANY object we are kicked out of Oracle promptly.

Regular DDL works fine via the PL/SQL Developer as I have experimented with Inserts, Deletes and updates without this problem.

Our DBA group has checked and found no strange triggers which might cause this problem.

I have been using this program successfully for quite some time now and have never found a problem.

Today, all of our developers have this problem.

Can anyone shed any light on this problem? The DBA group does not think that anything major had changed since yesterday.

-- Kevin Ryan

------------------
Kevin Ryan

Senior Computer Programmer / Analyst

 

[Marco Kalter]

Perhaps this topic applies? The symptoms are different, but the cause may be the same.

------------------
Marco Kalter
Allround Automations

 

[gaddyms@atscorporation.co]

I have had the same problem. It tends to be when I connect to databases I manage over a WAN link, and only when I compile certain packages. When this happens, I have another tool I use that will compile the package fine everytime. It does appear to be the tool in my situation. Any thoughts anyone?

 

[Marco Kalter]

Did you verify the preference setting I mentioned in my previous reply?

Compilations, in general, are no big deal. PL/SQL Developer simply sends the "create or replace ..." statement to the server. If this fails in mysterious ways, and other tools compile without a problem, I always suspect the "Add debug information" preference.

------------------
Marco Kalter
Allround Automations

 

[gaddyms@atscorporation.co]

The preference mentioned about fixed my problem. Is there any technical explanation as to why?

Stacy

 

[Marco Kalter]

The technical "explanation" is that this is an Oracle bug. The "Add debug information when compiling" preference executes the following statement:

alter session set plsql_debug=true

Apparently the PL/SQL compiler of the Oracle Server cannot cope with this session setting in some situations, and causes a PLS-00801 or ORA-03113 on compilation.

------------------
Marco Kalter
Allround Automations

 

[MarcioElizeu]

Originally posted by mkalter:
Perhaps this topic applies? The symptoms are different, but the cause may be the same.

This work very well. Thanks.