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:
Both of them returns nothing.
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.
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';