topic Re: Create Enterprise Geodatabase failure: Failed to setup st_geometry type.Failed to create the ST_Geometry metadata tables during install. in Data Management Questions

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

BrunoMendes — Thu, 05 Mar 2015 16:02:06 GMT

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:

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

Both of them returns nothing.

MagalyC_ — Wed, 03 Aug 2016 12:41:18 GMT

Hi !

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

Thanks a lot.

BirajaNayak — Wed, 03 Aug 2016 15:02:01 GMT

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_ — Thu, 04 Aug 2016 05:24:26 GMT

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 — Thu, 04 Aug 2016 16:23:02 GMT

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_ — Mon, 08 Aug 2016 05:08:19 GMT

Hi,

This query return nothing.

zhenzhang1 — Sun, 03 Dec 2017 14:30:52 GMT

I have the same problem,how to solve it?

thanks

MartinFörster — Wed, 23 Oct 2024 09:23:42 GMT

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