ora-03114 Not connected to oracle

[twaranch]

When compiling pl/sql packages we are getting disconnected from oracle. The system returns the following message: ora-03114 Not connected to oracle. Until being disconnected, I am able to view pl/sql code and write queries. I seem to be able to compile using sql Plus.
I am suspcious of the network team.
Any suggestions?

 

[Marco Kalter]

Perhaps this FAQ applies? The symptoms are slightly different, but it may have the same cause.

 

[Maarten Deen]

I remember the same problem some years ago. This seemed to be realated to one of the Oracle 8.0 versions. Upgrading to a newer Oracle (still 8.0) resolved the problem.
At the same time we always had to log in twice when changing sessions (in Session|Log on), after the first login we always received a 'not connected' error.

Which version of Oracle do you have?

 

[twaranch]

We are on: Oracle9i Enterprise Edition Release 9.2.0.3.0.
The suggestion to turn automatic debugging off worked. We are able to compile without disconnecting.
At 2PM we were able to compile. At 3PM we were not able to compile. The db team is not aware of any changes much less changes that would cause this problem. I will update these notes when we figure out what happened.
We appreciate the help. Thank you.

 

[Marjan Livk]

I'e the same problems with oracle 9205 (os390) and client 920 (win xp). It work fine with version 9204. Turning "Add debug information when compiling" off worked. We use diferent versions of PLSQLDeveloper (my is 5.1.6.747) and we all have the same problems.