Verify an Oracle Enterprise Geodatabase in configured properly with spatial libraries.

514
0
09-27-2021 06:43 AM
AndresCastillo
MVP Regular Contributor
0 0 514

Here are some quick snippets to verify your oracle database is configured properly with spatial libraries.

--LIBST_RASTER VALID:
--/app/oracle/product/19.10.0.0.210119/lib/libst_raster_ora.so
--ST_SHAPELIB VALID:
--/app/oracle/product/19.10.0.0.210119/lib/libst_shapelib.so
SELECT * FROM USER_LIBRARIES;


--10.4.1 Geodatabase
SELECT * FROM SDE.VERSION;


--PMIGISD5.FPL.COM
select * from global_name;


--"Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
--Version 19.10.0.0.0"
SELECT * FROM v$version;

 


--POINT ( 10.00000000 10.00000000)

select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;

https://support.esri.com/en/technical-article/000011293

 

If extproc is not configured, properly, follow this article:
https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm

 


Also verified working with existing fc in the gdb in an ArcGIS Desktop client, and

Verify creating and editing a fc in an ArcGIS Desktop works as expected.

Tags (2)
About the Author
I am really interested in Programming. GeoNet MVP.
Labels