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

来源:互联网 发布:p城办事处优化器 编辑:程序博客网 时间:2024/06/06 17:09
服务器环境:Red Hat Enterprise Linux 7
数据库环境:Oracle11.2.0.4

SDE环境:9.3 ArcSDEOracle11g64


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
0 0