Error: Object INSTANCES_UTIL does not exist
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)."
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.
Note: 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.