Oracle Session Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle Session Error

  1. #1
    Join Date
    Apr 2001
    Posts
    2

    Exclamation

    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

  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    There are many known reasons for this error. Plz refer to the docs. related to this error on Metalink.

  3. #3
    Join Date
    Aug 2000
    Posts
    462
    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.

  4. #4
    Join Date
    Apr 2001
    Posts
    2
    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

  5. #5
    Join Date
    Aug 2000
    Posts
    462
    Oracle maintains a large online help system called metalink. http://metalink.oracle.com

  6. #6
    Join Date
    Aug 2000
    Posts
    462
    Check some of these metalink document numbers:

    1020463.6
    1009295.6
    1003596.6


    Good luck!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width