topic Re: How to Configure ST_GEOMETRY by Configuring the Oracle extproc to access the geodatabase with SQL? in Developers Questions

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

HareshPanchal — Fri, 18 Sep 2015 06:15:44 GMT

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_SHAPELIB

c:\program files\arcgis\desktop10.3\DatabaseSupport\Oracle\Windows64\st_shapelib.dll

VALID

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

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

George_Thompson — Fri, 18 Sep 2015 16:46:33 GMT

Haresh,

The path has a space in it at "Program Files".

If Oracle is on the same machine place the .dll's in the %ORACLE_HOME%\bin folder then update the path on the EXTPROC.ora and SDE user_libraries for the geodatabase.

Configure the Oracle extproc to access the geodatabase with SQL—Help | ArcGIS for Desktop

That should take care of the issue.....

-George

Geodatabase Enterprise GIS

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

HareshPanchal — Wed, 30 Sep 2015 10:40:17 GMT

Steps to Configure ST_GEOMETRY by Configuring the Oracle extproc to access the geodatabase with SQL.

Regards,

Pranav M. Pastagia

Torrent Power Ltd., Surat, Gujarat, INDIA.