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