ERROR

ORA-28575: unable to open an RPC connection to external procedure agent

Last Published: April 25, 2020

Error Message

Attempting to call an ST_Geometry function, such as ST_AsText, results in the following error:

"ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12
ORA-06512: at "SDE.ST_POLYFROMTEXT", line 58"

Cause

The Oracle listener is not running or has not been properly configured to use ST_Geometry functions.

Solution or Workaround

Properly configure the listener.ora and tnsnames.ora files on the server to use the ST_Geometry library.

Note:
Note whether the extproc key is the same in the tnsnames.ora and listener.ora files. See the link in the Related Information section below for specific steps to configure the Oracle listener.

    Article ID: 000009077

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Related Information

    Discover more on this topic

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options