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

Last updated on APRIL 17, 2023

Applies to:

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

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