Oracle Session Error

[gopalbalaj]

Hi all,
I am connected to the Oracle Server using SPX protocol,
after connection is established successfully, and when trying out some SQL queries, an Oracle error "#03113: End of file on communication Channel " is displayed and my session is terminated, my network is fine, can you tell me what might be the problem, i went through the Oracle doc., for the error message, but i am not able to arrive at any conclusion, i am also connected to another Oracle server using a TCP/IP protocol this works fine.
Thanks

[Halo]

There are many known reasons for this error. Plz refer to the docs. related to this error on Metalink.

[kmesser]

It's more likely related to a logical error in your code than any network problem. I've seen this when a user improperly manages memory resources even in SQL*PLUS, such as cursor processing or PL/SQL tables. Halo has good advice. Check Metalink.

[gopalbalaj]

Hi halo & kmesser,
the statments i use are basic select statements, just try tried to get the count of records some basic stuff like that, i dont know where the memory comes into play, can u tell me what do you mean by Metalink

[kmesser]

Oracle maintains a large online help system called metalink. http://metalink.oracle.com

[kmesser]

Check some of these metalink document numbers:

1020463.6
1009295.6
1003596.6


Good luck!