Error: Ora-03111 break received on communication channel
Cause:
a. Network/Firewall timeout between application server and database server.
eg. If firewall timeout is 1 min then query takes more than 1 min to give result to application, then it will throw that
error.
b. SQL Query cross the specified timeout value from web services like IIS connection.
Analysis
run same query from plsql developer/Toad and Application at machine or server at Data Center.
Action/Solution
Increase the Network/Firewall timeout if any.
Increase any IIS timeout if any.
if issue still exists, then please raise the SR to Oracle Global Support.
