Spatial Data Server / ORA-06512

[Ganael_Jatteau]

All,

I'am trying out the new component Spatial Data Server with an Oracle database that has a SDE server (which actually works fine with Arcgis Server and Desktop).

Deploying services (through Arcmap) on SDS works fine but I'm having difficulties to get the query operation to work on a REST layer.

I first had:

28595 : ORA-28595: Extproc agent : Invalid DLL Path ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 216 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 109

Which I solved following the doc at: http://resources.arcgis.com/en/help/main/10.1/index.html#//006z0000001w000000

And now the error has changed to look like:

28575 : ORA-28575: unable to open RPC connection to external procedure agent ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 216 ORA-06512: at "SDE.ST_GEOMETRY_OPERATORS", line 109

It seems that SDS can go 1 step further but still has some issues with DLL.

When I run

select * from ALL_LIBRARIES  where library_name like 'ST_SHAPELIB'

it appears that shapelib is loaded with the correct path.

Any help appreciated! Thanks

[ForrestJones]

Hi Ganael,

One thing to check is if the oracle listener is started...