AnsweredAssumed Answered

Creating Oracle User Schema Geodatabase

Question asked by mousaem on Nov 18, 2011
Latest reply on Dec 18, 2011 by mousaem
Hi,

I am trying to create a user schema Geodatabase in ArcSDE 10 Geodatabase. I have followed the steps in the attached PDF file, i have granted the oracle user the required privileges:
GRANT ADMINISTER DATABASE TRIGGER TO SSDGEO;
GRANT CREATE LIBRARY TO SSDGEO;
GRANT UNLIMITED TABLESPACE TO SSDGEO;
GRANT CREATE INDEXTYPE TO SSDGEO;
GRANT CREATE PROCEDURE TO SSDGEO;
GRANT CREATE TRIGGER TO SSDGEO;
GRANT CREATE OPERATOR TO SSDGEO;
GRANT CREATE SEQUENCE TO SSDGEO;
GRANT CREATE VIEW TO SSDGEO;
GRANT CREATE PUBLIC SYNONYM TO SSDGEO;
GRANT CREATE TABLE TO SSDGEO;
GRANT CREATE SESSION TO SSDGEO;
GRANT CREATE TYPE TO SSDGEO;
GRANT DROP PUBLIC SYNONYM TO SSDGEO;

In Addition to the following:
grant execute on DBMS_LOCK to public;

grant execute on DBMS_PIPE to public;

However when i execute the sdesetup command:
sdesetup -o install -d ORACLE11G -i 5151:SSDGEO -u SSDGEO -l /apps/arcsde/sde_10_auth/authorization.ecp

I receive the following Error:

ESRI ArcSDE Server Setup Utility Sat Nov 19 06:35:26 2011
----------------------------------------------------------------
ERROR: The geodatabase already exists. If you want to upgrade the geodatabase,
see the ArcSDE installation guide for instructions.
ERROR: Geodatabase install not completed.

i have attached snapshots of my command output, and sdestup.log errors.

When i view the user schema, i find the "system tables" has been created successfully !!

However, under SDE schema "INSTANCE" system table, i don't see that the child geodatbase has been added.

Regards,
Emad

Outcomes