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

[HareshPanchal]

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

Y

VALID

0

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

[George_Thompson · Accepted solution]

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

[HareshPanchal]

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.