topic Unable to Enable Enterprise Geodatabase (10.4.1) in Data Management Questions

Unable to Enable Enterprise Geodatabase (10.4.1)

MonicaRuiz — Tue, 06 Dec 2016 15:21:16 GMT

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

Oracle 11gR2 64 bits is installed
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.

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

AdamZiegler1 — Tue, 06 Dec 2016 15:44:05 GMT

Hi Mónica,

Would it be correct to assume that you do not have the sys password to your database? The geodatabase administrator account that you are connecting as will need some additional privileges. Can you verify that your geodatabase administrator account has the following:

CREATE SESSION
CREATE TABLE
CREATE VIEW
CREATE TRIGGER
CREATE SEQUESNCE
CREATE PROCEDURE
CREATE TYPE

The following must also be granted to public:

GRANT EXECUTE ON dbms_pipe TO public;
GRANT EXECUTE ON dbms_lock TO public;
GRANT EXECUTE ON dbms_lob TO public;
GRANT EXECUTE ON dbms_utility TO public;
GRANT EXECUTE ON dbms_sql TO public;
GRANT EXECUTE ON utl_raw TO public;

Your geodatabase user account also needs privileges to the tablespace you are trying to write objects to as well.

Adam Z

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

MonicaRuiz — Tue, 06 Dec 2016 17:07:57 GMT

Hi Adam,

is correct that I do not have the sys password because I am not the DBA.

The user SDE has all the grants you described.

I am not sure about: "Your geodatabase user account also needs privileges to the tablespace you are trying to write objects to as well." <--- What grant does the user SDE needs? The user SDE also has the SDE tablespace as default.

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

Robert_LeClair — Tue, 06 Dec 2016 17:17:04 GMT

You will need to use a DBA connection (username/password) to the Enterprise Geodatabase to run this GP tool. A SDE connection (username/password) will not work and will throw an error message.

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

MonicaRuiz — Tue, 06 Dec 2016 17:24:24 GMT

Thanks Robert.

So, which GP tool do I need to run? And, as I am not the DBA, which privileges does this user need?

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

Robert_LeClair — Tue, 06 Dec 2016 17:28:16 GMT

This is the only GP tool that will spatially enable a database. Is your DBA accessible? If so, he/she can create a database connection via the Catalog window in ArcMap (may want to uncheck save username/password) and use that connection in the Enable Enterprise Geodatabase GP tool to successfully run the GP tool.

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

Asrujit_SenGupta — Tue, 06 Dec 2016 17:33:01 GMT

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-9e80cb613d16&searchIndex=0‌ https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=21478c82-3052-424c-8ad9-8124b7c56e4b&searchIndex=1‌

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

Asrujit_SenGupta — Tue, 06 Dec 2016 17:38:09 GMT

I am not sure if a DBA connection is actually required! Considering the Tablespace and SDE user is already created and the DBA has granted the listed permissions to SDE as well, one can just create a new Database Connection file using the SDE user and use that in the Enable Enterprise Geodatabase tool.

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

Robert_LeClair — Tue, 06 Dec 2016 17:45:16 GMT

Asrujit - I believe you're correct! In reviewing the Help - "Provide the path and connection file name for the database in which you want to enable geodatabase functionality. You must connect as a user that qualifies as a geodatabase administrator."

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

AdamZiegler1 — Tue, 06 Dec 2016 17:57:11 GMT

Asrujit - I second Robert in you being correct. I had initially reviewed the two GP tools closely to understand what the difference between the two were. Where the Create Enterprise Geodatabase requires a DBA connection, the Enable Enterprise Geodatabase does not as long as the database, geodatabase administrator and tablespace have been created. I believe the only thing missing is the unlimited tablespace grant to SDE....or a properly sized tablespace....or a tablespace with an ability to grow.

Does ST_Geometry need to be installed separately now? Here's a link on that....

ST_Geometry in Oracle—Help | ArcGIS for Desktop

-Adam Z

Re: Unable to Enable Enterprise Geodatabase (10.4.1)

MonicaRuiz — Wed, 07 Dec 2016 14:26:25 GMT

Adam, this was what I had to change:

GRANT UNLIMITED TABLESPACE TO SDE;

Thanks to all of you for all your comments and help!