locked
ora-03111: break received on communication channel RRS feed

  • Question

  • User-1141190189 posted

    iam using visual studio 2012 to develop a WCF web service that connects to remote database on another server.

    but when trying to call the function; the following error appears:

    ora-03111: break received on communication channel

    i have tried to use oledb  provider but the same exception appears

    any advise please?

    Friday, May 5, 2017 6:38 PM

All replies

  • User-2057865890 posted

    Hi Sanfoor,

    Sanfoor

    ora-03111: break received on communication channel

    I suggest you could refer to the follow simple steps:

    • First make sure that your query can be completed within the timeout that you have specified. If you consistently face this exception, try increasing your timeout (CommandTimeout and ConnectionTimeout).
    • That might help to get rid of the exception, but not the root cause. The root cause usually is a database that is not optimized for the query that you are executing or a bad network.
    • To find out if its the database that is the issue, try executing the same query in a host closer to the network. Or try executing the same query hitting the database from a different network. If you are convinced the database is the issue, try to tune it.
    • To find if it is the network that is having the issue, try to do a tcpdump and analyze if there are any out of order deliver of packets. Or dropped packets. If yes, then try to fix the network.

    More details, please check this blog: 

    http://royontechnology.blogspot.sg/2009/06/mysterious-ora-03111-error.html

    Best Regards,
    Chris

    Disclaimer: This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Monday, May 8, 2017 2:54 AM