Red Hat Enterprise Linux 7(RHEL7)安装64位ArcSDE9.3(2)

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

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/bf44496e2fb1b52ec3501305167260dd.html