Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What if the MGW_GATEWAY view shows LAST_ERROR_MSG of “ORA-28575: unable to open RPC connection to external procedure agent?

April 26, 2017connection external last_error_msg mgw_gateway RPC shows view

0

Posted

What if the MGW_GATEWAY view shows LAST_ERROR_MSG of “ORA-28575: unable to open RPC connection to external procedure agent?

1 Answer

0

Posted

Verify that the listener has been started. If listener.ora has been modified, the listener must be stopped and restarted before the changes will take effect. tnsnames.ora must have a net service name entry named MGW_AGENT. This entry is not needed for Messaging Gateway on Windows NT. The SID value specified for CONNECT_DATA of the MGW_AGENT net service name in tnsnames.ora must match the SID_NAME value of the SID_DESC entry in listener.ora. If the MGW_AGENT net service name is set up for an IPC connection, the KEY values for ADDRESS in tnsnames.ora and listener.ora must match. Verify that other values in tnsnames.ora or listener.ora are correct.