hepeng 2017-11-21
服务器环境: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