SDE命令行安装配置

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

十、启动服务