SDE命令行安装配置

一、创建相关表空间

创建sde表空间

create tablespace sde datafile '%oracle_base%\oradata\acf\sde_01.dbf' size 401m uniform size 1m;

创建sde_mvgdb表空间

create tablespace sde_mvgdb datafile '%oracle_base%\oradata\acf\sde_mvgdb_01.dbf' size 201m uniform size 4m;

 

二、创建sde用户

create user sde identified by sde default tablespace sde;

 

三、为sde用户赋予相应权限

1、为sde用户赋角色

GRANT CONNECT,RESOURCE TO SDE;

2、为sde用户赋系统权限

GRANT CREATE INDEXTYPE  TO SDE;
GRANT CREATE LIBRARY  TO SDE;
GRANT CREATE OPERATOR TO SDE;
GRANT CREATE PROCEDURE TO SDE;
GRANT CREATE PUBLIC SYNONYM  TO SDE;
GRANT CREATE SEQUENCE TO SDE;
GRANT CREATE SESSION TO SDE;
GRANT CREATE SYNONYM TO SDE;
GRANT CREATE TABLE  TO SDE;
GRANT CREATE TRIGGER TO SDE;
GRANT CREATE TYPE TO SDE;
GRANT CREATE VIEW TO SDE;
GRANT DROP PUBLIC SYNONYM TO SDE;
GRANT SELECT ANY TABLE TO SDE;
GRANT UNLIMITED TABLESPACE TO SDE;

3、为sde用户赋对象权限

GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "SDE";
GRANT EXECUTE ON "SYS"."DBMS_PIPE" TO "SDE";

 

四、安装sde软件

 

五、配置存储

##DATA_DICTIONARY
ATTRIBUTE_BINARY  "BLOB"
B_STORAGE               "PCTFREE 0 INITRANS 4 TABLESPACE sde STORAGE (INITIAL 40K)"
B_INDEX_ROWID           "PCTFREE 0 INITRANS 4 TABLESPACE sde STORAGE (INITIAL 40K) NOLOGGING"
B_INDEX_USER            "PCTFREE 0 INITRANS 4 TABLESPACE sde STORAGE (INITIAL 40K) NOLOGGING"
STATES_TABLE            "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 1M)"
STATES_INDEX            "INITRANS 5 TABLESPACE sde_mvgdb STORAGE (INITIAL 128K) NOLOGGING"
STATE_LINEAGES_TABLE    "PCTFREE 0 INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 7M)"
STATE_LINEAGES_INDEX    "PCTFREE 0 INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 5M) NOLOGGING"
VERSIONS_TABLE          "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 256K)"
VERSIONS_INDEX          "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 128K) NOLOGGING"
MVTABLES_MODIFIED_TABLE "INITRANS 4 TABLESPACE sde_mvgdb STORAGE (INITIAL 2M)"
MVTABLES_MODIFIED_INDEX "INITRANS 4 TABLESPACE sde_mvgdb  STORAGE (INITIAL  2M) NOLOGGING"
XML_INDEX_TAGS_TABLE    "INITRANS 4
#                        TABLESPACE <XML_INDEX_TAGS table tablespace name>
                         STORAGE (INITIAL 1M)"
XML_INDEX_TAGS_INDEX    "INITRANS 5
#                        TABLESPACE <XML_INDEX_TAGS table's index tablespace name>
                         STORAGE (INITIAL 1M)"
END

 

六、创建资料库

sdesetup -o install -d oracle10g -u sde -p sde

 

七、授权

sdesetup -o update_key -d oracle10g -p sde -l E:\license.txt

 

八、创建服务

sdeservice -o create -d oracle10g,acf -p sde

 

九、修改相关服务文件
C:\WINDOWS\system32\drivers\etc\services和
%sdehome%\etc\services中添加   esri_sde 5151/tcp

 

十、启动服务