topic Re: Geodatabase must be enabled as geodatabase admin user in Geodatabase Questions

Geodatabase must be enabled as geodatabase admin user

HaniDraidi — Thu, 22 Oct 2015 08:58:17 GMT

I've connected to an existing Oracle enterprise database, and I am trying to Geo-enable it by using the "enable enterprise geodatabase" tool. However I get the following error: "Geodatabase must be enabled as geodatabase admin user. Failed to execute (EnableEnterpriseGeodatabase)."

I got confused, because I am connecting to this database as administrator, but I don't know why I am not able to geo-enable it.

Re: Geodatabase must be enabled as geodatabase admin user

Pieter_Geertvan_den_Beukel — Thu, 22 Oct 2015 09:59:32 GMT

"I am connecting to this database as administrator"

De geodatabase administrator is not the same as the Oracle administrator. You have to run this tool as the SDE user. See http://resources.arcgis.com/en/help/main/10.1/index.html#/The_geodatabase_administrator_in_Oracle/002n0000002q000000/

Re: Geodatabase must be enabled as geodatabase admin user

HaniDraidi — Thu, 22 Oct 2015 10:27:19 GMT

Many thanks Pieter for the prompt input,

I am now connecting to the geodatabase using the "sys" user (which is the Oracle administrator, and not the one that should be used to enable the database to enterprise geodatabase), I've read that I should create an "sde" user that can administer the geodatabase itself. However, I am trying to create this "sde" user by right clicking the "sys" database connection and choosing "create user", but when i name the user as "sde", an error that says:

file:///C:/Users/Administrator/AppData/Roaming/ESRI/Desktop10.3/ArcToolbox/Dlg/MdDlgContent.htm#ERROR 000198

This tool cannot be used to create the geodatabase administrator user ‘sde’.

May you please elaborate more how can I create this "sde" user?

Best,

Re: Geodatabase must be enabled as geodatabase admin user

Anonymous User — Thu, 22 Oct 2015 10:46:35 GMT

Just create the sde user in Oracle and assign it the proper privileges:

Privileges for geodatabases in Oracle—Help | ArcGIS for Desktop

Re: Geodatabase must be enabled as geodatabase admin user

AsrujitSengupta — Thu, 22 Oct 2015 12:48:41 GMT

Use the 'Create Enterprise Geodatabae' tool. It can create the SDE user, table space, grant necessary permissions all by itself.

Also check out the two tools to get the use of each.

Re: Geodatabase must be enabled as geodatabase admin user

HaniDraidi — Fri, 23 Oct 2015 17:57:16 GMT

Thank you Richard for the valuable contribution,

I've explored the resource you provided above, but actually, I am new to Oracle DB and don't know how to create this "sde" user and how to grant these previlliges. I've installed Oracle Server, client, and SQL Navigator on the machine, but don't know how to create users with them.

May you please elaborate more how can I create this user using this environment?

Your help is highly appreciated!

Re: Geodatabase must be enabled as geodatabase admin user

HaniDraidi — Fri, 23 Oct 2015 18:05:10 GMT

Dear Asrujit,

I tried your suggestion. However, the "create enterprise geodatabase" tool ended with the error below:

Re: Geodatabase must be enabled as geodatabase admin user

George_Thompson — Fri, 23 Oct 2015 18:09:22 GMT

That is an error when connecting to the Oracle database. Are you using TNSNAMES for connecting or EZConnect?

Try something like this: ServerName/SID (Server name that Oracle is installed on/Oracle SID Name)

That should get you past that error.

-George

Re: Geodatabase must be enabled as geodatabase admin user

HaniDraidi — Sat, 24 Oct 2015 07:59:16 GMT

Hi George,

I am using TNSNAMES. Also, I tried using "ServerName/SID", but the same error appeared again!

Best,

Re: Geodatabase must be enabled as geodatabase admin user

AsrujitSengupta — Sat, 24 Oct 2015 13:20:57 GMT

Use the syntax that was used to connect with SYS user.

Provide a screenshot of the "Connection Properties" of NPROP_PTDT.sde connection file.

Re: Geodatabase must be enabled as geodatabase admin user

HaniDraidi — Mon, 26 Oct 2015 06:13:33 GMT

Hi Richard,

I've created the ''sde'" user, and assigned the required privileges except some privileges that I could not grant. In the screenshot below:

Can anyone help how I can grant them to this user?

Re: Geodatabase must be enabled as geodatabase admin user

Anonymous User — Mon, 26 Oct 2015 09:17:51 GMT

With the SYS user you should be able to use the "Enable Enterprise Geodatabase". However, you should assign the required package privileges before. Connect to Oracle with SQL*Plus using SYS, and execute the following:

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;