My Oracle Support Banner

ORA-3113 when issuing a select on a DBLINK (Doc ID 2824407.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and later
Information in this document applies to any platform.
The connection to the Source database is via a shared server connection.
Encryption is turned on in the SQLNET.ORA file.

Symptoms

Issue

Connection using SHARED mode and a dblink results in ORA-3113

Example

SQL> select * from dual@DBLINKNAME;
select * from dual@dblinkname
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 177517
Session ID: 769 Serial number: 49746

Changes

 It requires the Connection to the source database be using shared servers and for encryption to be turned on in the sqlnet.ora file.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.