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

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.

Related Information

• Configuring Oracle Net Services to use SQL functions (ArcSDE 9.3/9.3.1)
• Configuring the Oracle listener to access the geodatabase with SQL (ArcSDE 10.0)