5.客户端连接oracle创建用户表空间后sys连接授权
GRANT EXECUTE ON dbms_pipe TO public;
GRANT EXECUTE ON dbms_lock TO public;
grant CREATE SESSION to sde;
grant CREATE TABLE to sde;
grant CREATE PROCEDURE to sde;
grant CREATE SEQUENCE to sde;
grant CREATE TRIGGER to sde;
grant CREATE TYPE to sde;
grant CREATE LIBRARY to sde;
grant CREATE PUBLIC SYNONYM to sde;
grant CREATE OPERATOR to sde;
grant CREATE INDEXTYPE to sde;
grant DROP PUBLIC SYNONYM to sde;
grant UNLIMITED TABLESPACE to sde;
grant CREATE VIEW to sde;
grant SELECT ANY TABLE to sde;
grant ADMINISTER DATABASE TRIGGER to sde;
6.修改配置
[root@localhost ~]# vi /etc/services
添加
esri_sde 5151/tcp # ArcSDE service on pinetree
[root@localhost ~]# vi $SDEHOME/etc/services.sde
添加
esri_sde 5151/tcp # ArcSDE service on pinetree
[oracle@localhost ~]$ vi $SDEHOME/etc/dbinit.sde
添加
set ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
set ORACLE_SID=orcl
set SDEUSER=sde
7.创建sde服务。sde93.ecp是授权文件
sdesetup -o install -d ORACLE11G -u sde -p sde -i esri_sde -l /home/oracle/soft/sde93.ecp
8.其他操作
更新sde授权:
sdesetup -o update_key -d oracle11g -l /home/oracle/soft/sde93.ecp -p sde
sde启动和停止
sdemon -o start
sdemon -o shutdown