title: No more data to read from socket error using dblink - Oracle
body: <p>I'm getting this error (No more data to read from socket) even when I try to do the simple query like:</p>
  
  <pre><code>SELECT 
  T."ID" as user_id FROM "TEST"@DBLINK T where rownum&lt;10
  </code></pre>
  
  <p>I already looked for more details in tracelog and got this: </p>
  
  <p><code>Thu Jul 02 11:23:46 2015
  Archived Log entry 431583 added for thread 1 sequence 451623 ID 0x8ae0db51 dest 1:
  Thu Jul 02 11:30:32 2015
  HS:  Lost RPC connection to remote Agent...
  HS:  ... Agent SID = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.173)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=cf))), NCR status = -2147385341
  Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7FFF351D7F40] [PC:0x20E0101, kxsffir()+193] [flags: 0x0, count: 1]
  Errors in file /u01/app/oracle/diag/rdbms/bfdwbr/BFDWBR/trace/BFDWBR_ora_25533.trc  (incident=1197429):
  ORA-07445: exception encountered: core dump [kxsffir()+193] [SIGSEGV] [ADDR:0x7FFF351D7F40] [PC:0x20E0101] [Address not mapped to object] []
  ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.173)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=cf)))
  ORA-02063: preceding line from CF
  Incident details in: /u01/app/oracle/diag/rdbms/bfdwbr/BFDWBR/incident/incdir_1197429/BFDWBR_ora_25533_i1197429.trc
  Use ADRCI or Support Workbench to package the incident.
  See Note 411.1 at My Oracle Support for error and packaging details.</code></p>
  
  <p>Anyone there is any idea how to solve this?</p>
  
  <p>Thanks!</p>