Ora-03111 break received on communication channel

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.