服务器环境:Red Hat Enterprise Linux 7
数据库环境:Oracle11.2.0.4
[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
使环境变量生效
[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)
[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
添加
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
数据库环境:Oracle11.2.0.4
SDE环境:9.3 ArcSDEOracle11g64
这里拷贝到了/home/oracle/soft中
[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
[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...
[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
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