Geodatabase must be enabled as geodatabase admin user

9269
15
Jump to solution
10-22-2015 01:58 AM
Highlighted
Occasional Contributor II

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.

Clip_23.jpg

Clip_24.jpg

Reply
0 Kudos
1 Solution

Accepted Solutions
Highlighted
Occasional Contributor II

"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/00...

View solution in original post

Reply
0 Kudos
15 Replies
Highlighted
Occasional Contributor II

"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/00...

View solution in original post

Reply
0 Kudos
Highlighted
Occasional Contributor II

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,

Clip_25.jpg

Clip_26.jpg

Clip_27.jpg

Reply
0 Kudos
Highlighted
Esri Contributor

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

Privileges for geodatabases in Oracle—Help | ArcGIS for Desktop

Highlighted
Occasional Contributor II

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!

Reply
0 Kudos
Highlighted
Occasional Contributor II

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:

Clip_31.jpg

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

Reply
0 Kudos
Highlighted
Regular Contributor III

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.

Reply
0 Kudos
Highlighted
Occasional Contributor II

Dear Asrujit,

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

Clip_1190.jpg

Clip_1191.jpg

Reply
0 Kudos
Highlighted
Esri Frequent Contributor

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

--- George T.
Reply
0 Kudos
Highlighted
Occasional Contributor II

Hi George,

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

Best,

Reply
0 Kudos