AnsweredAssumed Answered

ST_GEOMETRY problem

Question asked by algabit on Jul 1, 2015
Latest reply on Jul 7, 2015 by algabit

Hi guys,

 

I get following error when try to select from gdb_items_vw:

select * from gdb_items_vw;
ERROR:
ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 1339
ORA-06512: at "SDE.ST_GEOM_UTIL", line 760

select st_point(0,0,0) from dual
ERROR at line 1:
ORA-28595: Extproc agent : Invalid DLL Path
ORA-06512: at "SDE.ST_GEOMETRY_SHAPELIB_PKG", line 12
ORA-06512: at "SDE.ST_POINT", line 176

 

We have Oracle Database 11.2.0.3 installed at RHEL and ArcSDE 10SP5 at Windows.

 

After some reading get confused how should I point to correct user library, the current shows this:

SELECT * FROM USER_LIBRARIES;
LIBRARY_NAME       FILE_SPEC  D STATUS
------------------------------ -------------------------------------------------- - -------
ST_SHAPELIB       C:\ArcSDE\ArcSDE\ora11gexe\bin\st_shapelib.dll  Y VALID

 

Should i download ArcSDE for Linux and extract from it Linux versions of library files and put it at Linux Server where Oracle database is?

OR just update extproc.ora with C:\ArcSDE\ArcSDE\ora11gexe\bin\st_shapelib.dll, because it didn't worked - the same result???

Outcomes