AnsweredAssumed Answered

Create Enterprise Geodatabase failure: Failed to setup st_geometry type.Failed to create the ST_Geometry metadata tables during install.

Question asked by bmnds on Mar 5, 2015
Latest reply on Dec 3, 2017 by zhangzhen

I'm trying to create an Enterprise Geodatabse in Oracle 11g hosted in an Exadata environment.

 

The message printed by the tool is: Failed to setup st_geometry type.Failed to create the ST_Geometry metadata tables during install.

 

The log generated is attached as sde_setup.log.

 

I've already checked the knowledgebade and based on this article I've run two sql queries:

  1. SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME  = 'ST_GEOMETRY' AND REFERENCED_TYPE  = 'TYPE' AND TYPE = 'TABLE';
  2. SELECT OWNER, TABLE_NAME, COLUMN_NAME FROM DBA_TAB_COLUMNS WHERE DATA_TYPE = 'ST_GEOMETRY'.

Both of them returns nothing.

Attachments

Outcomes