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

[EduardoC]

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:

[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

[George_Thompson · Accepted solution]

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?

[EduardoC]

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.

[George_Thompson]

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

I will take a look at your other post also.

[JoshuaDalton]

I've just encountered the same thing after a failed install for Oracle TEXT, then fixing Oracle TEXT, and getting a CTXSYS error about OIDCINDEXCREATE
,EXT_Error = 29855
,EXT_ERROR1 = ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drepopen
ORA-04063: package body "CTXSYS.DRVDML" has errors
ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML"

So then running GRANT EXECUTE ON UTL_HTTP TO CTXSYS;

ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

left me with this error:

[01:15:19.841] MULTIBRANCH_TABLES table being created...
[01:15:19.946] MULTIBRANCH_TABLES table created...
[01:15:19.995] TABLES_LAST_EDIT_TIME table being created...
[01:15:20.074] ERROR in creating TABLES_LAST_EDIT_TIME table.
Error: -901
[01:15:20.074] DBMS error code: 955
ORA-00955: name is already used by an existing object

[01:15:20.074] SDE schema object install not completed.
[01:15:20.129] ERROR installing/upgrading ArcSDE, Error = -1

This statement below should resolve the issue.  This is probably reportable as a bug in the post-failure cleanup for the Enable Enterprise Geodatabase tool, as the sequence isn't being deleted after a failure.

DROP SEQUENCE LAST_EDIT_ID_GENERATOR;

Also the following may linger after a failure to create or enable a geodatabase:

[01:32:19.068] ERROR setting up st_geometry type.
[01:32:19.068] Failed to create the ST_Geometry metadata tables during install.
[01:32:19.068] DBMS error code: 955
ORA-00955: name is already used by an existing object
Do the following to resolve:

DROP SEQUENCE LAST_EDIT_ID_GENERATOR;

drop operator st_dwithin;

drop type body st_geometry;

drop type st_geometry;

[George_Thompson]

Have you tried to drop the Oracle SID and re-run the process?

What version of Oracle and ArcGIS Pro are you using?

Did you verify that the Oracle SID / SDE user were configured per our documentation before running the Enable EGDB GP tool?

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/setup-geodatabase-orac...

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-oracle/privileges-oracle.htm

[JoshuaDalton]

Sorry, to be clear, I resolved the issue using the commands I posted. 

There were some additional objects left behind by the failed first run of the Enable Enterprise Geodatabase tool.  I really ran it 3 times to encounter the problem.

Try #1: Oracle TEXT package was missing.  I installed Oracle Text package by following steps as the oracle OS userid:

	at shell: sqlplus -nolog
	in sqlplus: connect / as sysdba
	in sqlplus: @$ORACLE_HOME/ctx/admin/catctx.sql temp1password SYSAUX TEMP NOLOCK;
	in sqlplus: alter user ctxsys identified by better2password;
	in sqlplus: connect CTXSYS/better2password
	in sqlplus: @$ORACLE_HOME/ctx/admin/defaults/drdefus.sql;

Try #2: Failed because one of the CTXSYS packages didn't compile correctly during TEXT install. 

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML" 

Fixed using following:

in os shell: sqlplus -nolog
in sqlplus: connect / as sysdba
in sqlplus: GRANT EXECUTE ON UTL_HTTP TO CTXSYS;
in sqlplus: ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

Try #3 and beyond started failing because the Enable Enterprise Geodatabase left some objects behind after failing on try #2.  For me these objects were the LAST_EDIT_ID_GENERATOR sequencer, some ST_GEOMETRY operators, types, and type bodies.  I resolved this issue by dropping the objects that still existed for SDE.  note TYPE BODYs and OPERATORs must be dropped before dropping the ST_GEOMETRY type itself.  So, I ran these commands in SQL using the SDE login: 

DROP SEQUENCE LAST_EDIT_ID_GENERATOR;
DROP OPERATOR ST_DWITHIN;
DROP TYPE BODY ST_GEOMETRY;
DROP TYPE ST_GEOMETRY;

You can get a list of commands to run to drop remnants left by failed runs of the Enable Enterprise Geodatabase tool using this command:

select 'DROP '||object_type||' SDE.'||object_name||';' from dba_objects where owner='SDE' and object_type<>'LIBRARY'
order by decode(object_type, 'PACKAGE BODY',1, 'PACKAGE',2, 'FUNCTION',3,
'SEQUENCE',4, 'TRIGGER',5, 'VIEW',6, 'LOB',7, 'INDEX',8, 'TABLE',9,
'INDEXTYPE',10, 'OPERATOR',11, 'TYPE BODY',12, 'TYPE',13, 14);

For anyone dealing with this issue, it may be simpler to do this than drop the whole SDE user and remake it with needed permissions, quotas, and roles granted, but that would work too.

Since this tool enables Geodatabase function on an existing database, which in this case had a ton of data already present in other user schemas, dropping the SID and starting all over would be significant overkill. The above SELECT command gets you a list of all things left behind that are preventing installation that need to be dropped so the tool will run to completion.