共计 4319 个字符，预计需要花费 11 分钟才能阅读完成。
服务器环境：Red Hat Enterprise Linux 7
数据库环境：Oracle11.2.0.4
SDE 环境：64 位 ArcSDE9.3 for Oracle11g
1. 首先使用 xftp 软件将 sde 安装包拷贝到服务器上
这里拷贝到了 /home/oracle/soft 中
2. 修改系统变量
[oracle@localhost ~]$ vi .bash_profile
export SDEHOME=/sde/sdeexe93
export PATH=$PATH:$SDEHOME/bin:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib
使环境变量生效
source .bash_profile
3. 给安装包赋予权限, 并安装
[root@localhost oracle]# chmod -R 775 /home/oracle/soft/ArcSDEOracle11g64/
[oracle@localhost ArcSDEOracle11g64]$ ./install -load
ESRI is willing to license the software to you only if you accept and agree to the enclosed license agreement. If you have read and agree with the terms in the enclosed license agreement type ‘yes’ to continue the installation process,if not press <return> or type ‘no’ to exit installation process. [no] yes
Press <return> to take the default, ‘?’ for help, ‘^’ to return to the previous question, or ‘q’ to quit.
Enter CD-ROM mount point: [/cdrom] /home/oracle/soft/ArcSDEOracle11g64
Enter pathname to install directory: [/home/oracle/soft/ArcSDEOracle11g64] /home/oracle/sde ArcSDE version 9.3 for Oracle11g – Dec 23, 2008
————————————————-
ArcSDE Product
Package numbers to load: [all] all
Package selection complete
————————–
You have chosen the following packages to be loaded
ArcSDE Product
ArcSDE Server
Is this correct? [yes] yes
Total size of chosen packages in megabytes: 153.4
Available space in megabytes: 8900.0
List file names while loading? [no] no
Loading package(s), Please wait…
Finished loading package(s)
Exiting…
4. 检查依赖包
[oracle@localhost ~]$ cd $SDEHOME/bin
[oracle@localhost bin]$ ldd sdesetup
linux-vdso.so.1 => (0x00007fff999fe000)
libsdesetup.so => /home/oracle/sde/sdeexe93/lib/libsdesetup.so (0x00007fbb3d455000)
libsde.so => /home/oracle/sde/sdeexe93/lib/libsde.so (0x00007fbb3cf9f000)
libsg.so => /home/oracle/sde/sdeexe93/lib/libsg.so (0x00007fbb3ce4f000)
libpe.so => /home/oracle/sde/sdeexe93/lib/libpe.so (0x00007fbb3cb72000)
libXm.so.3 => not found
libXmu.so.6 => /lib64/libXmu.so.6 (0x00007fbb3c944000)
libXp.so.6 => not found
libXt.so.6 => /lib64/libXt.so.6 (0x00007fbb3c4d3000)
libSM.so.6 => /lib64/libSM.so.6 (0x00007fbb3c2cb000)
libICE.so.6 => /lib64/libICE.so.6 (0x00007fbb3c0af000)
libXext.so.6 => /lib64/libXext.so.6 (0x00007fbb3be9c000)
libX11.so.6 => /lib64/libX11.so.6 (0x00007fbb3bb5e000)
libg2c.so.0 => not found
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbb3b941000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fbb3b73d000)
libstdc++.so.5 => /lib64/libstdc++.so.5 (0x00007fbb3b462000)
libm.so.6 => /lib64/libm.so.6 (0x00007fbb3b15f000)
libc.so.6 => /lib64/libc.so.6 (0x00007fbb3ad9e000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fbb3ab88000)
libXau.so.6 => /lib64/libXau.so.6 (0x00007fbb3a983000)
libuuid.so.1 => /lib64/libuuid.so.1 (0x00007fbb3a77e000)
libxcb.so.1 => /lib64/libxcb.so.1 (0x00007fbb3a55d000)
/lib64/ld-linux-x86-64.so.2 (0x00007fbb3d59b000)
## 解决 libg2c.so.0
[root@localhost oracle]# yum install compat-libf2c-34-3.4.6-32.el7.x86_64
## 解决 libXp.so.6
[root@localhost oracle]# yum install libXp-1.0.2-2.1.el7.x86_64
#解决 libXm.so.3 下面这个包在 rhel6 里面
[root@localhost Packages]# rpm -ivh openmotif22-2.2.3-19.el6.x86_64.rpm –nodeps
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
更多 Oracle 相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12
本文永久更新链接地址：http://www.linuxidc.com/Linux/2017-11/148768.htm
