Error: ORA-28575: unable to open an RPC connection to external procedure agent
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"
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 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.
- 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)