ORA-03113: end-of-file on communication channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-03113: end-of-file on communication channel

  1. #1
    Join Date
    Jul 2005
    Posts
    4

    ORA-03113: end-of-file on communication channel

    I've got a slightly strange issue that I am struggling to trace ...

    using sqlplus or pls/developer connecting to one of our remote customers keeps coming up with this error when selecting from any fairly large table or trying to recompile any function / procedure

    ORA-03113: end-of-file on communication channel

    If I connect to any other remote customer (dozens of different servers all in different facilities) and access a large table or compile any routine there are no issues at all.

    There are two servers in the same facility and I have the same issue connecting to databases on either server which suggests its not a database or listener issue (cant see any errors in the listener.log). I've rebooted both servers and I can use sqlplus or pl/sql developer on the servers and can access the data with no problems.

    I can connect to the servers via NetSupport and transfer files fine and the Apache server in the same facility can be accessed with no issues so it only seems to be oracle network traffic that is the issue.

    Has anyone experienced anything similar ... any ideas how to even trace where it's breaking down?

    cheers
    Robert

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,478

    Cool sqlnet.log?

    And what does sqlnet.log say?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    In my book that's a clean cut case of CNCS(*); your offending facility is experiencing an accute case of CNCS.

    (*) Crappy Network Connectivity Syndrome
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  4. #4
    Join Date
    Jul 2005
    Posts
    4
    Nothing in the logs ...

    CNCS is correct!!

    After some (read lots!) of time talking and testing with the network engineers the problem resolved to a firewall setting!! This is their response for what it's worth

    "I have removed an SQL fixup due to a limitation on the packet reassembly
    buffer - this explains why smaller queries were ok and larger ones were
    failing."

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