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.
