End-of-file on communication channel with Ora9iR2

[a_kassabian]

I have used PL/SQL Developer in the past with Ora9i and Ora10g and never had a problem. However, at my new job, I keep getting "not conneted to Oracle" or "end-of-file on communication channel" every time I try to alter, create, or drop an object. The same operation in SQL*Plus succeeds with no problem. I also get the same problem when I try to export some objects (using Tools -> Export User Objects).

Here are all the version numbers:
PL/SQL Developer 6.0.5.931

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production (on Solaris)
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

Client version is 9.2.0.1.0

Don't know if there is a trace file on the server side as I don't have access to the server itself but I can get it if necessary.

My company is considering using PL/SQL Developer as an alternative to SQL Navigator but I can't honestly recommend it until this is fixed.

 

[Joachim Rupik]

Hello,

That means that everytime you received "not connected" or "end of file" your session server process (when dedicated) disappeared (probably core dump + trace in user dump destination). In trace probably exists ora 600 error message.
As always, every ora-600 and every memory dump is an Oracle bug.

Greetings,
Joachim Rupik

 

[a_kassabian]

Agreed,however, it is weird that this only happens in PL/SQL Developer. Does PL/SQL Dev do anything other than submit the ALTER statement? That might give me a clue about what is going on.

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.