Unable to Enable Enterprise Geodatabase (10.4.1)

4127
10
12-06-2016 07:21 AM
MonicaRuiz
New Contributor

Hi all, I am having an issue trying to enable the geodatabase (10.4.1):

  1. Oracle 11gR2 64 bits is installed
  2. I could connect from ArcCatalog to the database

But when I try to use the enable tool the message shown is:

            

Executing: EnableEnterpriseGeodatabase "Database Connections\Connection to gistorde.sde" Z:\keycodes

Start Time: Fri Nov 25 10:51:11 2016

Validated authorization file.

User has required privileges for geodatabase setup.

XML support is enabled for the database instance.

[Underlying DBMS error]

See the setup log in the following location for additional error information:

C:\Users\yterum\AppData\Local\Temp\sde_setup.log

Could not create  geodatabase tables and stored procedures.

Failed to execute (EnableEnterpriseGeodatabase).

Failed at Fri Nov 25 10:51:13 2016 (Elapsed Time: 1,40 seconds)

And the sde_setup.log says:

[Fri Nov 25 10:51:12 2016]

ST_Geometry is not installed.[Fri Nov 25 10:51:12 2016] Instance initialized for ((sde)) . . .

 

[Fri Nov 25 10:51:12 2016] Error creating VERSION table. (-51)

DBMS error code: 1950

ORA-01950: no existen privilegios en tablespace 'SDE'

 

[Fri Nov 25 10:51:12 2016] SDE schema object install not completed.

[Fri Nov 25 10:51:12 2016] ERROR installing/upgrading ArcSDE, Error = -51

Can anyone help me?

Thanks in advance,

Mónica.

0 Kudos
10 Replies
Asrujit_SenGupta
MVP Regular Contributor

The Enable Enterprise geodatabase requires that you already have the necessary Tablespace & 'SDE' user created and have granted the SDE schema the necessary permissions. This seems to have been done as reported by you.

Suggest your DBA to grant the SDE user permission on the Tablespace and then try again. It will be something like this:

GRANT UNLIMITED TABLESPACE TO SDE;

ORA-01950: no privileges on tablespace tips 

https://community.esri.com/groups/geodatabase?sr=search&searchId=59e6691a-03c7-467d-b9ae-9e80cb613d1...https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=21478c82-3052-424c-8ad9-8...