ORA-3113 when issuing a select on a DBLINK
(Doc ID 2824407.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.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.
Connection using SHARED mode and a dblink results in ORA-3113
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
It requires the Connection to the source database be using shared servers and for encryption to be turned on in the sqlnet.ora file.
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