After Apply Oracle WBP/DBRU 19.24 Gateway Database Link Failing with ORA-28511
(Doc ID 3045457.1)
Last updated on DECEMBER 06, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.24.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
After apply Oracle WBP / DBRU 19.24 to the oracle database home, the gateway stopped to work and failing with below error
An example of the query error:
SQL> select count(*) from "<table_name>"@<DBLINK>;
select count(*) from "<table_name>"@DBLINK
*
ERROR at line 1:
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))(CONNECT_DATA=(SERVICE_NAME=<sid>)))
ORA-02063: preceding line from DBLINK
Process ID: 2398485
Session ID: 30 Serial number: 25909
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |