Hi bros,
Today, We worked with the customer, They told with us the process how to active the enterprise geodatabase as below:
Step 1:
Create new database
Step 2:
Create the tablespace for owner user.
Ex:
create tablespace sde datafile '+DATA' size 1G autoextend on next 10M maxsize unlimited logging extent management local segment space management auto;
create tablespace sde datafile '+DATA' size 1G autoextend on next 10M maxsize unlimited logging extent management local segment space management auto;
Step 3:
Create the SDE user
Ex:
create user sde identified by xxxxxxx default tablespace sde temporary tablespace temp;
Step 4:
Grant sde user as below:
GRANT EXECUTE ON DBMS_PIPE TO PUBLIC;
GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;
GRANT EXECUTE ON DBMS_LOB TO PUBLIC;
GRANT EXECUTE ON DBMS_UTILITY TO PUBLIC;
GRANT EXECUTE ON DBMS_SQL TO PUBLIC;
GRANT EXECUTE ON UTL_RAW TO PUBLIC;
GRANT EXECUTE ON DBMS_CRYPTO TO SDE;
ALTER USER SDE QUOTA UNLIMITED ON SDE;
GRANT CREATE SESSION TO SDE;
GRANT CREATE TABLE TO SDE;
GRANT CREATE TRIGGER TO SDE;
GRANT CREATE SEQUENCE TO SDE;
GRANT CREATE PROCEDURE TO SDE;
GRANT CREATE INDEXTYPE TO SDE;
GRANT CREATE LIBRARY TO SDE;
GRANT CREATE OPERATOR TO SDE;
GRANT CREATE PUBLIC SYNONYM TO SDE;
GRANT CREATE TYPE TO SDE;
GRANT CREATE VIEW TO SDE;
GRANT DROP PUBLIC SYNONYM TO SDE;
GRANT ADMINISTER DATABASE TRIGGER TO SDE;
GRANT UNLIMITED TABLESPACE TO SDE;
GRANT ALTER SYSTEM TO SDE;
GRANT SELECT_CATALOG_ROLE TO SDE;
GRANT INHERIT ANY PRIVILEGES TO SDE;
GRANT CREATE ANY VIEW,
CREATE ANY TRIGGER,
CREATE ANY INDEX,
CREATE TYPE,
CREATE TABLE,
CREATE INDEXTYPE,
CREATE LIBRARY,
CREATE PUBLIC SYNONYM,
CREATE OPERATOR,
SELECT ANY TABLE,
DROP ANY VIEW,
DROP ANY INDEX,
DROP PUBLIC SYNONYM,
ALTER ANY INDEX,
ADMINISTER DATABASE TRIGGER,
CREATE SESSION,
CREATE TRIGGER,
CREATE PROCEDURE,
CREATE VIEW,
CREATE SEQUENCE
TO SDE;
Step 5:
Copy and Import Schema Active GEO - ORACLE 12C
impdp system/xxxxxxx@GISINS directory=DUMP dumpfile=GISTEST_SDE_EXP.dmp logfile=GISTEST_DP1.log full=y cluster=n;
ALTER VIEW SDE.GDB_ITEMS_VW COMPILE;
ALTER VIEW SDE.GDB_ITEMRELATIONSHIPS_VW COMPILE;
Step 6:
Check Schema import
select object_name from dba_objects where status <> 'VALID' and owner = 'SDE';
Our customer was using this solution as the ESRI's advise because They couldn't activate the enterprise geodatabse through the ArcMap application.
Here is the schema file.
12C_Schema.zip - Google Drive
