Oracle MSSQL heterogeneous Oracle Database Gateway
Hi,
I've a database link from an Oracle 19c RU 24 to a MSSQL database server 2016 using Oracle Databae Gateways version 12.2.0.1.0. Two days after the installation of Oracle 19c RU 24 we started to see ORA-28511 errors. The are no network problems (that is checked) also no DNS issues. So I'm suspecting that the 19c RU 24 may be the cause of this ORA-28511. The issue also happens intermittently. When accessing a mssql table from sqplus via the dblink it can for example fails but a second execute of the select goes fine.
Tracing has been enabled and it shows this error:
HOA 09/01 07:57:47.314000000: (hotker_ExecuteRpcs) Network error 1003: NCR-01003: NCRS: Read error.