topic Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered. in ArcGIS Pro Questions

Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered.

EduardoC — Wed, 30 Jun 2021 19:55:10 GMT

I'm creating an Enterprise Geodatabase using the following systems:

Arcgis Pro 2.8

Oracle Datablase version 19.8.0.0.0

Arcgis Enterprise 10.8.1

I configured the st_shapelib.so library in the Oracle Linux Server, by setting its path in the Exproc.ora as:

SET EXTPROC_DLLS=ONLY:/u/app/oracle/product/19.0.0/dbhome_1/lib/libst_shapelib.so

And I'm getting the following error in Arcgis Pro:

[11:34:58.075] db_get_dbms_release:: Unknown DBMS Release (19.0.0.0.0) higher than 18c detected using DBMS_UTILITY.DB_VERSION.
[11:34:58.208] SGA_Param - Open_Cursors: 1200
[11:34:58.209]
ST_Geometry is not installed.[11:34:58.209] Instance initialized for ((sde)) . . .

[11:34:58.911] VERSION table created...
[11:34:58.913] SPATIAL_REFERENCES table being created...
[11:34:59.261] SPATIAL_REFERENCES table created...
[11:34:59.264] GEOMETRY_COLUMNS table being created...
[11:34:59.872] GEOMETRY_COLUMNS table created...
[11:34:59.875] LAYERS table being created...
[11:35:00.143] LAYERS table created...
[11:35:00.146] METADATA table being created...
[11:35:00.427] METADATA table created...
[11:35:00.430] RASTER_COLUMNS table being created...
[11:35:00.621] RASTER_COLUMNS table created...
[11:35:00.623] TABLE_REGISTRY table being created...
[11:35:00.863] TABLE_REGISTRY table created...
[11:35:00.865] COLUMN_REGISTRY table being created...
[11:35:01.754] COLUMN_REGISTRY table created...
[11:35:01.757] STATES table being created...
[11:35:02.406] STATES table created...
[11:35:02.409] VERSIONS table being created...
[11:35:02.859] VERSIONS table created...
[11:35:02.862] MVTABLES_MODIFIED table being created...
[11:35:03.070] MVTABLES_MODIFIED table created...
[11:35:03.073] STATE_LINEAGES table being created...
[11:35:04.329] STATE_LINEAGES table created...
[11:35:04.331] LOCATORS table being created...
[11:35:04.620] LOCATORS table created...
[11:35:04.623] XML tables being created...
[11:35:05.997] XML tables created...
[11:35:06.000] Instances tables being created...
[11:35:06.306] Instances tables created...
[11:35:06.309] ARCHIVES table being created...
[11:35:06.438] ARCHIVES table created...
[11:35:06.440] LAYER_STATS table being created...
[11:35:06.527] LAYER_STATS table created...
[11:35:06.529] BRANCHES table being created...
[11:35:06.645] BRANCHES table created...
[11:35:06.647] BRANCH_TABLES_MODIFIED table being created...
[11:35:06.677] BRANCH_TABLES_MODIFIED table created...
[11:35:06.679] MULTIBRANCH_TABLES table being created...
[11:35:06.712] MULTIBRANCH_TABLES table created...
[11:35:06.714] TABLES_LAST_EDIT_TIME table being created...
[11:35:07.039] TABLES_LAST_EDIT_TIME table created...
[11:35:11.088] LOGFILE_POOL tables being created...
[11:35:11.090] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='MINSTANDALONELOGS' >
[11:35:11.092] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='MAXSTANDALONELOGS' >
[11:35:11.093] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='LOGFILEPOOLSIZE' >
[11:35:11.095] SQL Stmt: <UPDATE SDE.SERVER_CONFIG set num_prop_value = 0 WHERE prop_name='ALLOWSESSIONLOGFILE' >
[11:35:11.576] LOGFILE_POOL tables created...
[11:35:13.765] DBTUNE table being created...
[11:35:14.031] DBTUNE table created...
[11:35:14.033] SERVER_CONFIG tables being created...
[11:35:14.615] SERVER_CONFIG tables created...
[11:35:14.616] SDENUMTAB type being created...
[11:35:14.998] SDENUMTAB type created...
[11:35:15.842] db_verify_st_geom_mismatch - Select SRID metadata.[11:35:15.844] db_verify_legacy_auth_srid_0 - Check for SRID 0 case.[11:35:15.846] S_get_gdb_items_srid_info - Select GDB_ITEMS metadata.[11:35:16.374] DBMS stored procedures being created or updated...
[11:35:27.607] DBMS stored procedures created or updated...
[11:35:37.671] TABLES_LAST_EDIT_TIME table registered as hidden...
[11:35:37.807]
Successfully installed ArcSde.

[11:35:37.876] db_get_dbms_release:: Unknown DBMS Release (19.0.0.0.0) higher than 18c detected using DBMS_UTILITY.DB_VERSION.
[11:35:38.126] SGA_Param - Open_Cursors: 1200
[11:35:38.132]
ST_Geometry is not installed.[11:35:38.277] Instance initialized for ((sde)) . . .

[11:35:38.668] St_Geometry type being installed or updated...
[11:35:40.570] SQL Stmt: <DROP PUBLIC SYNONYM USER_ST_GEOMETRY_COLUMNS>
[11:35:40.686] SQL Stmt: <DROP PUBLIC SYNONYM ALL_ST_GEOMETRY_COLUMNS>
[11:35:41.204] SQL Stmt: <DROP PUBLIC SYNONYM USER_ST_GEOM_INDEX>
[11:35:46.431] SQL Stmt: </* $Id: spx_util.sps,v 1.11.1.69, 2016-06-14 19:35:54Z, Kevin Watt$
$NoKeywords$ */
CREATE OR REPLACE Package spx_util Authid current_user
/***********************************************************************
*
*n {spx_util.sps} -- utility procs/funct for st_spatial_index.
*
*:

.... <<<<<<<I OMITED THE FUNCTION DETAILS>>>>>>

End spx_util;
>
[11:35:46.432] Unable to load Type spx_util, underlying DBMS error encountered.
[11:35:47.125] SQL Stmt: <drop type stgeom_aggr_union>
[11:35:47.128] SQL Stmt: <drop type stgeom_aggr_intersection>
[11:35:47.131] SQL Stmt: <drop type stgeom_aggr_convexhull>
[11:35:47.134] SQL Stmt: <drop function st_aggr_union>
[11:35:47.136] SQL Stmt: <drop function st_aggr_intersection>
[11:35:47.139] SQL Stmt: <drop function st_aggr_convexhull>
[11:35:47.689] SQL Stmt: <DISASSOCIATE STATISTICS FROM TYPES SDE.ST_GEOMETRY>
[11:35:47.691] SQL Stmt: <DISASSOCIATE STATISTICS FROM INDEXTYPES SDE.st_spatial_index>
[11:35:47.694] SQL Stmt: <DISASSOCIATE STATISTICS FROM PACKAGES SDE.st_domain_operators>
[11:35:47.696] SQL Stmt: <DISASSOCIATE STATISTICS FROM PACKAGES SDE.st_relation_operators>
[11:35:47.699] SQL Stmt: <DROP INDEXTYPE SDE.ST_SPATIAL_INDEX>
[11:35:47.702] SQL Stmt: <DROP PUBLIC SYNONYM ST_EnvIntersects>
[11:35:47.704] SQL Stmt: <DROP OPERATOR SDE.ST_EnvIntersects>
[11:35:47.707] SQL Stmt: <drop operator SDE.st_contains>
[11:35:47.710] SQL Stmt: <drop operator SDE.st_within>
[11:35:47.713] SQL Stmt: <drop operator SDE.st_intersects>
[11:35:47.716] SQL Stmt: <drop operator SDE.st_overlaps>
[11:35:47.718] SQL Stmt: <drop operator SDE.ST_GeomCollection>
[11:35:47.721] SQL Stmt: <drop operator SDE.st_touches>
[11:35:47.724] SQL Stmt: <drop operator SDE.st_crosses>
[11:35:47.727] SQL Stmt: <drop operator SDE.st_orderingequals>
[11:35:47.730] SQL Stmt: <drop operator SDE.st_equals>
[11:35:47.732] SQL Stmt: <drop operator SDE.st_disjoint>
[11:35:47.735] SQL Stmt: <drop operator SDE.st_distance>
[11:35:47.738] SQL Stmt: <drop operator SDE.st_relate>
[11:35:47.741] SQL Stmt: <drop operator SDE.ST_AsText>
[11:35:47.744] SQL Stmt: <drop operator SDE.ST_AsBinary>
[11:35:47.747] SQL Stmt: <drop operator SDE.ST_GeomFromWkb>
[11:35:47.750] SQL Stmt: <drop operator SDE.ST_PointFromWkb>
[11:35:47.753] SQL Stmt: <drop operator SDE.ST_LineFromWkb>
[11:35:47.756] SQL Stmt: <drop operator SDE.ST_PolyFromWkb>
[11:35:47.759] SQL Stmt: <drop operator SDE.ST_MPointFromWkb>
[11:35:47.761] SQL Stmt: <drop operator SDE.ST_MLineFromWkb>
[11:35:47.764] SQL Stmt: <drop operator SDE.ST_MPolyFromWkb>
[11:35:47.767] SQL Stmt: <drop operator SDE.ST_Boundary>
[11:35:47.770] SQL Stmt: <drop operator SDE.ST_CoordDim>
[11:35:47.773] SQL Stmt: <drop operator SDE.ST_Dimension>
[11:35:47.775] SQL Stmt: <drop operator SDE.ST_Envelope>
[11:35:47.778] SQL Stmt: <drop operator SDE.ST_Geometry>
[11:35:47.781] SQL Stmt: <drop operator SDE.ST_Is3D>
[11:35:47.784] SQL Stmt: <drop operator SDE.ST_IsMeasured>
[11:35:47.786] SQL Stmt: <drop operator SDE.ST_IsClosed>
[11:35:47.789] SQL Stmt: <drop operator SDE.ST_IsEmpty>
[11:35:47.792] SQL Stmt: <drop operator SDE.ST_IsRing>
[11:35:47.795] SQL Stmt: <drop operator SDE.ST_IsSimple>
[11:35:47.798] SQL Stmt: <drop operator SDE.ST_Area>
[11:35:47.800] SQL Stmt: <drop operator SDE.ST_Buffer>
[11:35:47.803] SQL Stmt: <drop operator SDE.ST_Centroid>
[11:35:47.806] SQL Stmt: <drop operator SDE.ST_ConvexHull>
[11:35:47.809] SQL Stmt: <drop operator SDE.ST_StartPoint>
[11:35:47.812] SQL Stmt: <drop operator SDE.ST_EndPoint>
[11:35:47.815] SQL Stmt: <drop operator SDE.ST_PointOnSurface>
[11:35:47.818] SQL Stmt: <drop operator SDE.ST_ExteriorRing>
[11:35:47.821] SQL Stmt: <drop operator SDE.ST_InteriorRingN>
[11:35:47.824] SQL Stmt: <drop operator SDE.ST_NumInteriorRing>
[11:35:47.827] SQL Stmt: <drop operator SDE.ST_NumGeometries>
[11:35:47.830] SQL Stmt: <drop operator SDE.ST_GeometryN>
[11:35:47.833] SQL Stmt: <drop operator SDE.ST_GeometryType>
[11:35:47.835] SQL Stmt: <drop operator SDE.ST_Difference>
[11:35:47.838] SQL Stmt: <drop operator SDE.ST_Union>
[11:35:47.841] SQL Stmt: <drop operator SDE.ST_SymmetricDiff>
[11:35:47.844] SQL Stmt: <drop operator SDE.ST_PointN>
[11:35:47.847] SQL Stmt: <drop operator SDE.ST_Intersection>
[11:35:47.850] SQL Stmt: <drop operator SDE.ST_Transform>
[11:35:47.853] SQL Stmt: <drop operator SDE.ST_Entity>
[11:35:47.856] SQL Stmt: <drop operator SDE.ST_Numpoints>
[11:35:47.859] SQL Stmt: <drop operator SDE.ST_MinX>
[11:35:47.861] SQL Stmt: <drop operator SDE.ST_MaxX>
[11:35:47.863] SQL Stmt: <drop operator SDE.ST_MinY>
[11:35:47.866] SQL Stmt: <drop operator SDE.ST_MaxY>
[11:35:47.869] SQL Stmt: <drop operator SDE.ST_MinZ>
[11:35:47.871] SQL Stmt: <drop operator SDE.ST_MaxZ>
[11:35:47.875] SQL Stmt: <drop operator SDE.ST_MinM>
[11:35:47.877] SQL Stmt: <drop operator SDE.ST_MaxM>
[11:35:47.880] SQL Stmt: <drop operator SDE.ST_Length>
[11:35:47.883] SQL Stmt: <drop operator SDE.ST_Perimeter>
[11:35:47.886] SQL Stmt: <drop operator SDE.ST_Srid>
[11:35:47.888] SQL Stmt: <drop operator SDE.ST_X>
[11:35:47.891] SQL Stmt: <drop operator SDE.ST_Y>
[11:35:47.894] SQL Stmt: <drop operator SDE.ST_Z>
[11:35:47.896] SQL Stmt: <drop operator SDE.ST_M>
[11:35:47.899] SQL Stmt: <drop operator SDE.ST_Verify>
[11:35:47.902] SQL Stmt: <drop operator SDE.ST_Buffer_Intersects>
[11:35:47.905] SQL Stmt: <DROP OPERATOR sdexmltotext FORCE>
[11:35:47.907] SQL Stmt: <DROP OPERATOR st_geohash FORCE>
[11:35:47.910] SQL Stmt: <DROP OPERATOR ST_PointFromGeoHash FORCE>
[11:35:47.913] SQL Stmt: <DROP OPERATOR ST_GeomFromGeoHash FORCE>
[11:35:47.916] SQL Stmt: <DROP OPERATOR st_geosquare FORCE>
[11:35:47.919] SQL Stmt: <DROP OPERATOR ST_PointFromGeosquare FORCE>
[11:35:47.922] SQL Stmt: <DROP OPERATOR ST_GeomFromGeosquare FORCE>
[11:35:47.925] SQL Stmt: <DROP OPERATOR st_geohexcode FORCE>
[11:35:47.927] SQL Stmt: <DROP OPERATOR st_geohextriangle FORCE>
[11:35:47.931] SQL Stmt: <DROP OPERATOR ST_GeometryFromGeohexTri FORCE>
[11:35:47.933] SQL Stmt: <DROP OPERATOR ST_GeohexCodeFromTriangleCode FORCE>
[11:35:47.936] SQL Stmt: <DROP OPERATOR ST_PointFromGeohexTri FORCE>
[11:35:47.939] SQL Stmt: <DROP OPERATOR ST_PointFromGeohexTriangle FORCE>
[11:35:47.942] SQL Stmt: <DROP OPERATOR ST_GeometryFromGeohexTriangle FORCE>
[11:35:47.944] SQL Stmt: <DROP OPERATOR ST_GeometryFromTriangleCode FORCE>
[11:35:49.315] SQL Stmt: <drop type SDE.sp_grid_info>
[11:35:49.479] SQL Stmt: <drop table SDE.st_geometry_columns>
[11:35:49.482] SQL Stmt: <drop sequence SDE.st_gcol_seg>
[11:35:49.558] SQL Stmt: <drop table SDE.st_spatial_references>
[11:35:50.064] SQL Stmt: <drop type SDE.st_domain_stats>
[11:35:50.066] SQL Stmt: <drop type SDE.st_funcs_array>
[11:35:50.069] SQL Stmt: <drop type SDE.st_domain_methods>
[11:35:50.071] SQL Stmt: <drop package SDE.st_geometry_operators>
[11:35:50.073] SQL Stmt: <drop package SDE.st_relation_operators>
[11:35:50.075] SQL Stmt: <drop package SDE.st_domain_operators>
[11:35:50.078] SQL Stmt: <drop type SDE.st_geomfromtext>
[11:35:50.080] SQL Stmt: <drop type SDE.st_mpolyfromtext>
[11:35:50.083] SQL Stmt: <drop type SDE.st_polyfromtext>
[11:35:50.085] SQL Stmt: <drop type SDE.st_mlinefromtext>
[11:35:50.088] SQL Stmt: <drop type SDE.st_linefromtext>
[11:35:50.091] SQL Stmt: <drop type SDE.st_mpointfromtext>
[11:35:50.093] SQL Stmt: <drop type SDE.st_pointfromtext>
[11:35:50.096] SQL Stmt: <drop type SDE.st_multipolygon>
[11:35:50.099] SQL Stmt: <drop type SDE.st_multilinestring>
[11:35:50.102] SQL Stmt: <drop type SDE.st_multisurface>
[11:35:50.105] SQL Stmt: <drop type SDE.st_multicurve>
[11:35:50.108] SQL Stmt: <drop type SDE.st_multipoint>
[11:35:50.111] SQL Stmt: <drop type SDE.st_polygon>
[11:35:50.115] SQL Stmt: <drop type SDE.st_linestring>
[11:35:50.118] SQL Stmt: <drop type SDE.st_geomcollection>
[11:35:50.121] SQL Stmt: <drop type SDE.st_surface>
[11:35:50.126] SQL Stmt: <drop type SDE.st_curve>
[11:35:50.129] SQL Stmt: <drop type SDE.st_point>
[11:35:50.132] SQL Stmt: <drop type SDE.st_geometry>
[11:35:50.135] SQL Stmt: <drop package SDE.st_type_export>
[11:35:50.969] SQL Stmt: <drop package SDE.st_geometry_shapelib_pkg>
[11:35:51.236] ERROR setting up st_geometry type.
[11:35:51.236] Unable to load Type spx_util, underlying DBMS error encountered.

[11:35:51.236] DBMS error code: 4043
ORA-04043: el objeto ST_GEOMETRY_SHAPELIB_PKG no existe

[11:35:51.241] ERROR setting up St_Geometry, Error = -521

Re: Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered.

ThomasVanyi — Tue, 21 Sep 2021 14:56:29 GMT

Hello Eduardo, did you find a resolution for this error? I am seeing something similar when attempting to Enable Geodatabase.

[09:25:18.613] Unable to load Type st_type_export, underlying DBMS error encountered.
[09:25:18.613] SQL Stmt: <drop trigger SDE.DB_EV_RENAME_ST_METADATA>
[09:25:18.613] SQL Stmt: <drop trigger SDE.DB_EV_DROP_ST_METADATA>
[09:25:18.613] SQL Stmt: <drop trigger SDE.DB_EV_ALTER_ST_METADATA>
[09:25:18.613] SQL Stmt: <drop type stgeom_aggr_union>
[09:25:18.613] SQL Stmt: <drop type stgeom_aggr_intersection>
[09:25:18.613] SQL Stmt: <drop type stgeom_aggr_convexhull>
[09:25:18.613] SQL Stmt: <drop function st_aggr_union>
[09:25:18.613] SQL Stmt: <drop function st_aggr_intersection>
[09:25:18.613] SQL Stmt: <drop function st_aggr_convexhull>
[09:25:18.614] SQL Stmt: <drop package SDE.st_geometry_shapelib_pkg>
[09:25:18.614] SQL Stmt: <DISASSOCIATE STATISTICS FROM TYPES SDE.ST_GEOMETRY>
[09:25:18.614] SQL Stmt: <DISASSOCIATE STATISTICS FROM INDEXTYPES SDE.st_spatial_index>
[09:25:18.614] SQL Stmt: <DISASSOCIATE STATISTICS FROM PACKAGES SDE.st_domain_operators>
[09:25:18.614] SQL Stmt: <DISASSOCIATE STATISTICS FROM PACKAGES SDE.st_relation_operators>
[09:25:18.614] SQL Stmt: <DROP INDEXTYPE SDE.ST_SPATIAL_INDEX>
[09:25:18.614] SQL Stmt: <DROP PUBLIC SYNONYM ST_EnvIntersects>
[09:25:18.614] SQL Stmt: <DROP OPERATOR SDE.ST_EnvIntersects>
[09:25:18.614] SQL Stmt: <drop operator SDE.st_contains>
[09:25:18.614] SQL Stmt: <drop operator SDE.st_within>
[09:25:18.614] SQL Stmt: <drop operator SDE.st_intersects>
[09:25:18.614] SQL Stmt: <drop operator SDE.st_overlaps>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_GeomCollection>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_touches>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_crosses>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_orderingequals>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_equals>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_disjoint>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_distance>
[09:25:18.615] SQL Stmt: <drop operator SDE.st_relate>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_AsText>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_AsBinary>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_GeomFromWkb>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_PointFromWkb>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_LineFromWkb>
[09:25:18.615] SQL Stmt: <drop operator SDE.ST_PolyFromWkb>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_MPointFromWkb>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_MLineFromWkb>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_MPolyFromWkb>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_Boundary>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_CoordDim>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_Dimension>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_Envelope>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_Geometry>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_Is3D>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_IsMeasured>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_IsClosed>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_IsEmpty>
[09:25:18.616] SQL Stmt: <drop operator SDE.ST_IsRing>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_IsSimple>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_Area>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_Buffer>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_Centroid>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_ConvexHull>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_StartPoint>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_EndPoint>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_PointOnSurface>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_ExteriorRing>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_InteriorRingN>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_NumInteriorRing>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_NumGeometries>
[09:25:18.617] SQL Stmt: <drop operator SDE.ST_GeometryN>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_GeometryType>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_Difference>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_Union>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_SymmetricDiff>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_PointN>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_Intersection>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_Transform>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_Entity>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_Numpoints>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_MinX>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_MaxX>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_MinY>
[09:25:18.618] SQL Stmt: <drop operator SDE.ST_MaxY>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_MinZ>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_MaxZ>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_MinM>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_MaxM>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_Length>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_Perimeter>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_Srid>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_X>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_Y>
[09:25:18.619] SQL Stmt: <drop operator SDE.ST_Z>
[09:25:18.620] SQL Stmt: <drop operator SDE.ST_M>
[09:25:18.620] SQL Stmt: <drop operator SDE.ST_Verify>
[09:25:18.620] SQL Stmt: <drop operator SDE.ST_Buffer_Intersects>
[09:25:18.620] SQL Stmt: <DROP OPERATOR sdexmltotext FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR st_geohash FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR ST_PointFromGeoHash FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR ST_GeomFromGeoHash FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR st_geosquare FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR ST_PointFromGeosquare FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR ST_GeomFromGeosquare FORCE>
[09:25:18.620] SQL Stmt: <DROP OPERATOR st_geohexcode FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR st_geohextriangle FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR ST_GeometryFromGeohexTri FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR ST_GeohexCodeFromTriangleCode FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR ST_PointFromGeohexTri FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR ST_PointFromGeohexTriangle FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR ST_GeometryFromGeohexTriangle FORCE>
[09:25:18.621] SQL Stmt: <DROP OPERATOR ST_GeometryFromTriangleCode FORCE>
[09:25:18.621] SQL Stmt: <DROP PUBLIC SYNONYM USER_ST_GEOMETRY_COLUMNS>
[09:25:18.621] SQL Stmt: <DROP PUBLIC SYNONYM ALL_ST_GEOMETRY_COLUMNS>
[09:25:18.621] SQL Stmt: <DROP PUBLIC SYNONYM USER_ST_GEOM_INDEX>
[09:25:18.621] SQL Stmt: <drop table SDE.st_units_of_measure>
[09:25:18.621] SQL Stmt: <drop view SDE.user_st_geom_index_v>
[09:25:18.621] SQL Stmt: <drop trigger SDE.tg_st_geomindex_name>
[09:25:18.622] SQL Stmt: <drop table SDE.st_geometry_index>
[09:25:18.622] SQL Stmt: <drop type SDE.st_funcs_array>
[09:25:18.622] SQL Stmt: <drop type SDE.sp_grid_info>
[09:25:18.622] SQL Stmt: <drop view SDE.all_st_geometry_columns_v>
[09:25:18.622] SQL Stmt: <drop view SDE.user_st_geometry_columns_v>
[09:25:18.622] SQL Stmt: <drop trigger SDE.tg_gcol_name>
[09:25:18.622] SQL Stmt: <drop table SDE.st_geometry_columns>
[09:25:18.622] SQL Stmt: <drop sequence SDE.st_gcol_seg>
[09:25:18.622] SQL Stmt: <drop trigger SDE.tg_st_spatial_ref_srid>
[09:25:18.622] SQL Stmt: <drop table SDE.st_spatial_references>
[09:25:18.622] SQL Stmt: <drop sequence SDE.st_spref_seq>
[09:25:18.622] SQL Stmt: <drop trigger SDE.tg_st_cref_sys>
[09:25:18.623] SQL Stmt: <drop table SDE.st_coordinate_systems>
[09:25:18.623] SQL Stmt: <drop sequence SDE.ST_GEOM_ID_SEQ>
[09:25:18.623] SQL Stmt: <drop type SDE.flt_array_tab>
[09:25:18.623] SQL Stmt: <drop type SDE.int_array_tab>
[09:25:18.623] SQL Stmt: <drop type SDE.bnd_rowid_tab>
[09:25:18.623] SQL Stmt: <drop type SDE.blob_array_tab>
[09:25:18.623] SQL Stmt: <drop type SDE.st_domain_stats>
[09:25:18.623] SQL Stmt: <drop type SDE.st_funcs_array>
[09:25:18.623] SQL Stmt: <drop type SDE.st_domain_methods>
[09:25:18.623] SQL Stmt: <drop package SDE.st_geometry_operators>
[09:25:18.623] SQL Stmt: <drop package SDE.st_relation_operators>
[09:25:18.623] SQL Stmt: <drop package SDE.st_domain_operators>
[09:25:18.624] SQL Stmt: <drop type SDE.st_geomfromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_mpolyfromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_polyfromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_mlinefromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_linefromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_mpointfromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_pointfromtext>
[09:25:18.624] SQL Stmt: <drop type SDE.st_multipolygon>
[09:25:18.624] SQL Stmt: <drop type SDE.st_multilinestring>
[09:25:18.624] SQL Stmt: <drop type SDE.st_multisurface>
[09:25:18.624] SQL Stmt: <drop type SDE.st_multicurve>
[09:25:18.624] SQL Stmt: <drop type SDE.st_multipoint>
[09:25:18.625] SQL Stmt: <drop type SDE.st_polygon>
[09:25:18.625] SQL Stmt: <drop type SDE.st_linestring>
[09:25:18.625] SQL Stmt: <drop type SDE.st_geomcollection>
[09:25:18.625] SQL Stmt: <drop type SDE.st_surface>
[09:25:18.625] SQL Stmt: <drop type SDE.st_curve>
[09:25:18.625] SQL Stmt: <drop type SDE.st_point>
[09:25:18.625] SQL Stmt: <drop type SDE.st_geometry>
[09:25:18.625] SQL Stmt: <drop package SDE.st_type_export>
[09:25:18.625] SQL Stmt: <drop package SDE.spx_util>
[09:25:18.625] SQL Stmt: <drop package SDE.st_cref_util>
[09:25:18.625] SQL Stmt: <drop package SDE.st_spref_util>
[09:25:18.625] SQL Stmt: <drop package SDE.st_geom_cols_util>
[09:25:18.626] SQL Stmt: <drop package SDE.st_geom_util>
[09:25:18.626] SQL Stmt: <drop package SDE.st_type_util>
[09:25:18.626] SQL Stmt: <drop package SDE.st_type_user>
[09:25:18.626] SQL Stmt: <drop package SDE.st_geometry_shapelib_pkg>
[09:25:18.626] SQL Stmt: <drop library SDE.st_shapelib>
[09:25:18.626] ERROR setting up st_geometry type.
[09:25:18.626] Unable to load Type st_type_export, underlying DBMS error encountered.

Re: Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered.

Anonymous User — Mon, 07 Mar 2022 21:38:54 GMT

@EduardoC, @ThomasVanyi ,

Were either of you able to resolve this issue? If so, do you know what the cause/resolution was? I'd appreciate any help!

Thanks,

Mike

Re: Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered.

NorlizaAbdul_Rahman — Wed, 18 May 2022 01:45:57 GMT

I managed to get rid of this error by installing the geodatabase via Python. I have ArcGIS Server running on Linux, so I running the python script on that Linux server.

The script and installation here for 10.7.1:

https://desktop.arcgis.com/en/arcmap/10.7/manage-data/gdbs-in-oracle/setup-geodatabase-oracle.htm

Re: Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered.

EugenGass1 — Tue, 14 Jun 2022 10:52:02 GMT

I've a similar issue on upgrading ArcSDE from 10.7.1 to 10.9.1

[13:14:16.722] Unable to load Type st_type_export, underlying DBMS error encountered.
[13:14:16.722] ERROR setting up st_geometry type.
[13:14:16.722] Unable to load Type st_type_export, underlying DBMS error encountered.

[13:14:16.723] DBMS error code: 3135
ORA-03135: connection lost contact
Process ID: 236080
Session ID: 466 Serial number: 30865

[13:14:16.723] ERROR setting up St_Geometry, Error = -521

Re: Failed to setup st_geometry type.Unable to load Type spx_util, underlying DBMS error encountered.

MartinKrál — Fri, 29 Aug 2025 06:28:06 GMT

Hello @EugenGass1

It seems that we have similar issue here. Please were you able to resolve this problem with upgrade in your environement?

Thanks