Dear Tom
I have Oracle EBS 12.8 with Oracle 12C. I upgraded my database to 19C with the latest patches, and everything is working fine, except my DBlink with another MS SQL server. Note that it was working before the upgrade. I dropped the DBlink and re-created it, but I have no luck connecting.
The Oracle gateway I installed in my SQL server is 11G.
When I connect, I get the following error:
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=wapps24)(PORT=1521))(CONNECT_DATA=(SID=VestioOracleFinIntegration)))
ORA-02063: preceding line from VESTIOORACLEFININTEGRATION
Process ID: 42099
My DBlink setup is
OWNER PUBLIC
DB_LINK VESTIOORACLEFININTEGRATION.WAFRA.LOCAL
USERNAME OracleFin
HOST VESTIOORACLEFININTEGRATION
CREATED 16-APR-25
HIDDEN NO
SHARD_INTERNAL NO
VALID YES
INTRA_CDB NO
This is a generic error, so there could be many causes. There are a few MOS notes that discuss this (e.g. 1331919.1, 1988866.1). One critical point is;
(1) Ensure that the gateway version is exactly the same as the Oracle Server version whenever this is possible. i.e. Oracle Server version 10g is only supported with 11g gateways. Hence they will not be at the same level until the Oracle 10g Server is upgraded to 11g.
REASON: Keep the HS server code and HS client code at the same level. When the HS server code is not at the same level as the HS client code the percentage of ORA-28511 errors increases. The amount of increase is dependent on how much of a gap their is between the HS server and client code.
So as it seems you have a large version drift:
The Oracle gateway I installed in my SQL server is 11G.
Try upgrading the gateway to 19c too.
If this doesn't help, then I recommend reaching out to support.