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

5535
15
06-30-2014 09:52 AM
MarioRocha
New Contributor
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.
0 Kudos
15 Replies
AsrujitSengupta
Regular Contributor III
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
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
MarioRocha
New Contributor
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?
0 Kudos
MarioRocha
New Contributor
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
MarioRocha
New Contributor
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???
0 Kudos
VinceAngelo
Esri Esteemed Contributor
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
0 Kudos
MarioRocha
New Contributor
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?
0 Kudos
MarioRocha
New Contributor
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!
0 Kudos