ORA-03113, ORA-12571 Issuing a Select Over a dblink Through a Firewall (Doc ID 1507098.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Net Services - Version 10.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Intermittently receiving the below error while doing a select over the dblink

ORA-03113: end-of-file on communication channel
ORA-12571: TNS:packet writer failure

Changes

Database is recently moved to different network or firewall rules are changed recently.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms