The ODBC should be configured to success. But your isql can remote connection MySQL,
But Oracle connection MySQL, perform the DBLink Select error, error message the next time,

Doubt is Oracle or use the other port, because it has minimum policy on Linux, excuse me this kind of situation, which ports are need to open?

CodePudding user response:

Error message:
ORA - 28511: lost RPC connection to heterogeneous remote agent using
SID=ORA - 28511: lost RPC connection to heterogeneous remote agent using

CodePudding user response:

8511. In 00000 - "lost the RPC connection to heterogeneous remote agent using SID=% s"
* Cause: A fatal error occurred in one of the following places
- the connection between the ORACLE server and the agent
- the heterogeneous services remote agent itself
- the connection to the non - Oracle system
This error occurred after the communication had been established
Successfully.
* Action: Check for network problems and remote host crashes. The problem is
Probably in the agent software. If so, contact a customer support
The representative of the agent vendor.

CodePudding user response:

What is your configuration to connect mysql, oracle can't directly match, need to configure transparent gateway configuration to connect mysql again

CodePudding user response:

The building Lord DBLink connection MySQL how you configure the Oracle configuration of success?