topic Re: Enable Enterprise Geodatabase to new user's schem doesn't work in Data Management Questions

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

MarioRocha — Mon, 30 Jun 2014 16:52:46 GMT

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.

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

AsrujitSengupta — Mon, 30 Jun 2014 17:15:42 GMT

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

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

VinceAngelo — Mon, 30 Jun 2014 17:32:49 GMT

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

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

MarioRocha — Mon, 30 Jun 2014 18:24:04 GMT

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?

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

MarioRocha — Mon, 30 Jun 2014 18:29:34 GMT

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

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

VinceAngelo — Mon, 30 Jun 2014 18:49:13 GMT

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

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

MarioRocha — Mon, 30 Jun 2014 18:54:39 GMT

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???

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

VinceAngelo — Mon, 30 Jun 2014 19:27:17 GMT

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

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

MarioRocha — Mon, 30 Jun 2014 19:28:29 GMT

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?

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

MarioRocha — Mon, 30 Jun 2014 19:32:19 GMT

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!

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

VinceAngelo — Mon, 30 Jun 2014 19:39:24 GMT

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

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

DavidColey — Tue, 01 Jul 2014 13:00:21 GMT

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

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

MarioRocha — Tue, 01 Jul 2014 19:59:09 GMT

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?

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

MarioRocha — Tue, 01 Jul 2014 20:16:25 GMT

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?

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

VinceAngelo — Tue, 01 Jul 2014 20:53:25 GMT

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

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

DavidColey — Wed, 02 Jul 2014 15:10:30 GMT

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