Error Message
Running the Create Enterprise Geodatabase geoprocessing tool on an Oracle database fails with the following errors:
"Failed to create stored procedures in the geodatabase. Error (-51)
DBMS error code: 4043
ORA-04043: object INSTANCES_UTIL does not exist
See the setup log in the following location for additional error information:
C:\Users\davi2346\AppData\Local\Temp\sde_setup.log
Could not create geodatabase tables and stored procedures.
Failed to execute (CreateEnterpriseGeodatabase)."
"Failed to create stored procedures in the geodatabase. Error (-51)
DBMS error code: 4043
ORA-04043: object INSTANCES_UTIL does not exist
See the setup log in the following location for additional error information:
C:\Users\davi2346\AppData\Local\Temp\sde_setup.log
Could not create geodatabase tables and stored procedures.
Failed to execute (CreateEnterpriseGeodatabase)."
Cause
This error is returned when the Create Enterprise Geodatabase tool is run more than once in the same ArcCatalog session to create master sde geodatabases.
This error does not occur when creating user-schema geodatabases from the same ArcCatalog session.
This error does not occur when creating user-schema geodatabases from the same ArcCatalog session.
Solution or Workaround
To create more than one enterprise geodatabase in Oracle, start a new ArcCatalog session for each run. For example, to create two independent enterprise geodatabases in Oracle:
- Start ArcCatalog and run the Create Enterprise Geodatabase geoprocessing tool to create the first geodatabase in Oracle.
- Close ArcCatalog (if ArcCatalog was launched from ArcMap, close ArcMap too).
- Start ArcCatalog again, and run the Create Enterprise Geodatabase geoprocessing tool to create the second geodatabase in Oracle.
