Saturday, July 4, 2020

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.

No comments:

Post a Comment

Followers