AnsweredAssumed Answered

How to Configure ST_GEOMETRY by Configuring the Oracle extproc to access the geodatabase with SQL?

Question asked by tpsrtgis on Sep 17, 2015
Latest reply on Sep 30, 2015 by tpsrtgis

How to Configure ST_GEOMETRY by Configuring the Oracle extproc to access the geodatabase with SQL?

 

Environment:

     Server : Windows Server 2008 R2.

     ArcGIS Server :   ArcGIS Server 10.3 Basic + Oracle 12c Standard (both on same Server)

 

               I have tried to configure the same but getting error as below.

 

ORA-28595: Extproc agent : Invalid DLL Path

ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12

ORA-06512: at "SDE.ST_POINT", line 181

28595. 00000 -  "Extproc agent : Invalid DLL Path"

*Cause:    The path of DLL supplied for the extproc execution is invalid.

*Action:   Check if the DLL path is set properly using the EXTPROC_DLLS

           environment variable.

 

when I tried to execute the SQL: SELECT * FROM USER_LIBRARIES; from Client side, I got the result as following.

ST_SHAPELIBc:\program files\arcgis\desktop10.3\DatabaseSupport\Oracle\Windows64\st_shapelib.dllYVALID0

 

currently I have configured the extproc.ora file as

 

C:\Program Files\ArcGIS\Server\DatabaseSupport\Oracle\Windows64\st_shapelib.dll;C:\Program Files\ArcGIS\Server\DatabaseSupport\Oracle\Windows64\libst_raster_ora.dll

Outcomes