nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Enable Enterprise Geodatabase to new user's schem doesn't work

MarioRocha

Hi!
I've tried to Enable Geodatabase to existing user, but the ArcGIS show me: "Executing: EnableEnterpriseGeodatabase "Database Connections\RNCET - GIS2.sde" "C:\Program Files (x86)\ESRI\License10.2\sysgen\keycodes"
Start Time: Mon Jun 30 14:48:38 2014
WARNING 000152: Geodatabase instance already exists.
Succeeded at Mon Jun 30 14:48:38 2014 (Elapsed Time: 0.14 seconds)"

I have already two users SDE(SYSTEM TABLES) and GIS(FEATURES), but I want to use a MULTIGEODATABASE with the same oracle instance.

Configuration:
ArcGIS 10.2 64 bits, Windows 7 64 bits, Oracle 11g R2.

Find more posts tagged with

Accepted answers

All comments

DavidColey

I would have to agree with Vince on this. I can tell you that when you set up your SDE repositories (at least in SQL) as either SDE or DBO (depending on your model) sde or dbo will own the system tables. For example, since we use direct-connect, DBO owns all the SDE system objects. But once you add a headless user, and assign object-ownership rights to that user through your rdbms, all user GIS data will then be owned by that user as you 1: connect to your user dbs as the headless owner, and 2: then load data (featurdatasets, featureclasses, tables). This way, all user-schema changes have to be performed as the data owner while administrative tasks are performed as SDE (or dbo) protecting integrity and performance-
David

VinceAngelo

I'm afraid that I can't help you. I suggest you contact Tech Support, explain to them
what you're trying to accomplish, and heed their advice on how to accomplish it.

- V

MarioRocha

I've created in excess of 10,000 geodatabase instances in the past 18 years. I've never
had difficulty creating multiple users in a single instance, then creating and registering
tables with the geodatabase as those users. "Enable Enterprise Geodatabase" only happens
once, and the rest is just basic administration. If users can't create tables, that's a database
administration issue (missing required permissions).

- V

But the other users has the same SDE privilegies, Can you explain the step-to-step to do it?

MarioRocha

Thank you for your attention!
Only SDE user-schem has the system tables, and the best pratice says to separate two instances, ok!
But if I don't have another option, Can I do a SDE like master administrator scheme and a GIS with GDB,COLUMN_REGISTRY,TABLE_REGISTRY tables? If answer yes, so how can I do it?

DavidColey

I'm sorry but this seems like a solution that is looking for a problem. Per best practices (and you can ask Mike Jensen at ESRI), in ANY rdbms, you should be creating and using a headless data owner in your rdbms, then assigning privileges appropriate to that owner. DBO or SDE should never own the data or schema, and unless each of your users is an sde administrator themselves capable of understanding and managing sde geodatabase objects, versioning, states, etc. they should never own data either.

For example, on our production geodatabase, GIS owns all data. Users and AD groups are placed in view-only roles. Our production geodatabase is actually the child gdb of our 11 edit user database instances, to which we replicate data weekly. In each of our edit database instances, each utilizes a headless data owner and users are assigned to editor roles with view, create, update and delete privileges.
Thanks
David

VinceAngelo

I've created in excess of 10,000 geodatabase instances in the past 18 years. I've never
had difficulty creating multiple users in a single instance, then creating and registering
tables with the geodatabase as those users. "Enable Enterprise Geodatabase" only happens
once, and the rest is just basic administration. If users can't create tables, that's a database
administration issue (missing required permissions).

- V

MarioRocha

Thank's!
But I don't have another way, I have only one instance and I don't have DBA(SYS) privilegies, so I have to solve it anyway!

MarioRocha

I'm not DBA, so I don't have all privilegies.
I created SDE and GIS users in Oracle, after I Enable Enterprise Geodatabase to SDE Connection created.
I understood that I can only one master geodatabase, but why doesn't work GDB tables in another user in the same instance?

VinceAngelo

No, I mean two different users with tables in ONE geodatabase. Unless you've
got hundreds or thousands of tables in each user, and need to be able to upgrade
one instance before the other, then you're trying to apply a very sophisticated
solution to a mundane problem. User-schema instances won't give you that
level of independence anyway, so it's far better to fall back to the "two instances"
solution if you need independence.

- V

MarioRocha

As noted in the referenced thread, you cannot create two independent "master"
geodatabases in the same Oracle 11g instance. You could just use two different
users in a single instance, or you could use the same owner name in two Oracle
instances. It would be unwise to use the same tablespace(s) in the former
configuration.

- V

"You could just use two different users in a single instance" So I have tried it, but no sucess!!!
When I try on the second user connection to "Enable Enterprise Geodatabase", it doesn't work!
I using sdo_geometry type, isn't it problem???

VinceAngelo

As noted in the referenced thread, you cannot create two independent "master"
geodatabases in the same Oracle 11g instance. You could just use two different
users in a single instance, or you could use the same owner name in two Oracle
instances. It would be unwise to use the same tablespace(s) in the former
configuration.

- V

MarioRocha

This thread http://forums.arcgis.com/threads/8782-multiple-geodatabase-at-oracle

MarioRocha

Sorry guys!
So let's go!
I need to create a scenario using "Production and Publication Geodatabases", but only one instance Oracle 11g R2, in the same tablespace.
Following steps below:
1) In Oracle, I created the SDE user with privileges for CRATING an SDE master geodatabase. In ArcGIS > ArcCatalog > Data Management > Enable Enterprise Geodatabase > SDE Connection;(OK)
2) In Oracle, I created the GIS user with privileges for UPGRADING an SDE master geodatabase. (OK)
3) In Oracle, I created the SDE2 user with privileges for CRATING an SDE master geodatabase. In ArcGIS > ArcCatalog > Data Management > Enable Enterprise Geodatabase > SDE Connection;(ERROR)

Why the third step doesn't work?

VinceAngelo

You'd need to give us all the parameters you're providing (less passwords, of course) in order
for us to tell why you're getting this response.

I do have to object to wanting to implement user-schema geodatabases with only one user.
There are a number of quirks to the way that user-schema geodatabases operate, and not
many business rules that call for them, even with scores of users and tens of thousands of
tables, so I do wonder if you might be borrowing trouble in this case.

- V

AsrujitSengupta

Have a look at the below links:

Creating a geodatabase in a user's schema in Oracle:
http://resources.arcgis.com/en/help/main/10.2/index.html#//002n0000000s000000

Connections to user-schema geodatabases in Oracle:
http://resources.arcgis.com/en/help/main/10.2/index.html#//002n00000031000000

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.