Create Enterprise Geodatabase fails. ORA-00955 name is already used by an exsisting object

798
3
Jump to solution
06-29-2021 07:10 AM
Labels (1)
EduardoC
New Contributor

Hi, I'm using Arcgis Pro 2.8, Oracle 19.8.0.0.0 and Arcgis Enterprise 10.7.1. When I run the geoprocess Create Enterprise Geodatabase, I get the following error:

EduardoC_0-1624975285716.png

 

[11:28:32.756] db_get_dbms_release:: Unknown DBMS Release (19.0.0.0.0) higher than 18c detected using DBMS_UTILITY.DB_VERSION.
[11:28:32.907] SGA_Param - Open_Cursors: 300
[11:28:32.908] Default value of Open_Cursors: (300) can cause cursor starvation!
[11:28:32.909]
ST_Geometry is not installed.[11:28:32.909] Instance initialized for ((SDE)) . . .

[11:28:33.525] VERSION table created...
[11:28:33.529] SPATIAL_REFERENCES table being created...
[11:28:33.830] SPATIAL_REFERENCES table created...
[11:28:33.833] GEOMETRY_COLUMNS table being created...
[11:28:34.117] GEOMETRY_COLUMNS table created...
[11:28:34.119] LAYERS table being created...
[11:28:34.358] LAYERS table created...
[11:28:34.361] METADATA table being created...
[11:28:34.673] METADATA table created...
[11:28:34.676] RASTER_COLUMNS table being created...
[11:28:35.053] RASTER_COLUMNS table created...
[11:28:35.056] TABLE_REGISTRY table being created...
[11:28:35.306] TABLE_REGISTRY table created...
[11:28:35.309] COLUMN_REGISTRY table being created...
[11:28:36.015] COLUMN_REGISTRY table created...
[11:28:36.018] STATES table being created...
[11:28:36.515] STATES table created...
[11:28:36.518] VERSIONS table being created...
[11:28:37.131] VERSIONS table created...
[11:28:37.134] MVTABLES_MODIFIED table being created...
[11:28:37.396] MVTABLES_MODIFIED table created...
[11:28:37.398] STATE_LINEAGES table being created...
[11:28:38.666] STATE_LINEAGES table created...
[11:28:38.669] LOCATORS table being created...
[11:28:38.947] LOCATORS table created...
[11:28:38.950] XML tables being created...
[11:28:40.631] XML tables created...
[11:28:40.633] Instances tables being created...
[11:28:41.051] Instances tables created...
[11:28:41.053] ARCHIVES table being created...
[11:28:41.345] ARCHIVES table created...
[11:28:41.347] LAYER_STATS table being created...
[11:28:41.588] LAYER_STATS table created...
[11:28:41.591] BRANCHES table being created...
[11:28:42.403] BRANCHES table created...
[11:28:42.407] BRANCH_TABLES_MODIFIED table being created...
[11:28:42.639] BRANCH_TABLES_MODIFIED table created...
[11:28:42.641] MULTIBRANCH_TABLES table being created...
[11:28:43.109] MULTIBRANCH_TABLES table created...
[11:28:43.112] TABLES_LAST_EDIT_TIME table being created...
[11:28:43.229] ERROR in creating TABLES_LAST_EDIT_TIME table.
Error: -901
[11:28:43.229] DBMS error code: 955
ORA-00955: este nombre ya lo está utilizando otro objeto existente

[11:28:43.229] SDE schema object install not completed.
[11:28:43.235] ERROR installing/upgrading ArcSDE, Error = -1

0 Kudos
1 Solution

Accepted Solutions
George_Thompson
Esri Frequent Contributor

Was there an SDE schema before running the tool?

Based on the Oracle error; http://www.dba-oracle.com/t_ora_00955_name_already_used_by_existing_object.htm, it seems that there were some previous objects in the SDE schema.

I would also try to make sure that you have the ST_Geometry library configured; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-orac...

I also see in your screenshot that the SDE user was already in the instance. Can you try on a brand new clean instance to see what you get?

--- George T.

View solution in original post

3 Replies
George_Thompson
Esri Frequent Contributor

Was there an SDE schema before running the tool?

Based on the Oracle error; http://www.dba-oracle.com/t_ora_00955_name_already_used_by_existing_object.htm, it seems that there were some previous objects in the SDE schema.

I would also try to make sure that you have the ST_Geometry library configured; https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-orac...

I also see in your screenshot that the SDE user was already in the instance. Can you try on a brand new clean instance to see what you get?

--- George T.
EduardoC
New Contributor

I deleted the SDE schema and the TABLESPACE created by Arcgis Pro, and this problem got solved, now I'm getting another error that I posted in here:

https://community.esri.com/t5/arcgis-pro-questions/failed-to-setup-st-geometry-type-unable-to-load-t...

 

Thank you.

0 Kudos
George_Thompson
Esri Frequent Contributor

Thanks for the update, mark the solution correct that fixed the issue.

I will take a look at your other post also.

--- George T.
0 Kudos