Database Networking (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center