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

[BrunoMendes]

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.

[MagalyC_]

Hi !

Have you found the solution ? I have the same problem.

Thanks a lot.

[BirajaNayak]

As per article, query is as per below:

SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_OWNER='MDSYS' AND REFERENCED_NA

ME = 'ST_GEOMETRY' AND REFERENCED_TYPE = 'TYPE' AND TYPE='TABLE';

Please run the above query as it is using "sys" login. This may help.

Thanks,

Biraja

[MagalyC_]

Hi, this query returns nothing.

With this query :

SELECT OWNER, NAME, TYPE, REFERENCED_NAME, REFERENCED_TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME = 'ST_GEOMETRY';

I have this result (see attachement)

Thanks.

[BirajaNayak]

Please run the below query and let us know your result:

SELECT OWNER, NAME, TYPE FROM DBA_DEPENDENCIES WHERE REFERENCED_NAME  = 'ST_GEOMETRY' AND REFERENCED_TYPE  = 'TYPE' AND TYPE = 'TABLE';

[MagalyC_]

Hi,

This query return nothing.

[zhenzhang1]

I have the same problem,how to solve it? 

thanks

[MartinFörster]

A customer has the same problem. Did you find a solution?
Thank you in advance!