My Oracle Support Banner

ORA-28575 when Executing External Procedure (Doc ID 1011994.102)

Last updated on JANUARY 15, 2018

Applies to:

PL/SQL - Version 11.2.0.1.0 and later
Oracle Net Services - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Listener fails to load the extproc agent which will result in the following error while running external procedure. 

ORA-28575 "unable to open RPC connection to external procedure agent"
*Cause Initialization of a network connection to the extproc agent did not succeed.
 This can be caused by network problems, incorrect listener configuration or incorrect transfer code.
*Action Check listener configuration in LISTENER.ORA and TNSNAMES.ORA or Oracle Names Server.

 

The NAMES.DEFAULT_DOMAIN=WORLD parameter exists in the sqlnet.ora file. However, there is no .world extension on the listener.ora and tnsnames.ora entries.

The same external procedure runs fine when this line is removed from the sqlnet.ora file.

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.