Linux（centos6.4）下ArcSDE10.0安装文档

来源：互联网发布：h5与后端数据库编辑：程序博客网时间：2024/06/06 21:17

1.首先检查oracle是否启动

[oracle@localhost ~]$ sqlplus sys/sys@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 12 15:48:56 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

然后启动数据库服务

SQL>startup
SQL>quit

如果提示已经启动则进行第二步，如果不确定LISTENER是否启动执行

lsnrctl stop

lsnrctl start

2.创建arcsde用户（如果对方允许我们在oracle的用户操作，则可以不创建arcsde用户，直接使用oracle用户即可，因为我是测试机所以直接用oracle用户）

[root@localhost ~]# useradd -d /home/arcsde -G oinstall -m arcsde
[root@localhost ~]# passwd arcsde
Changing password for user arcsde.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

3．上传安装文件

解压ArcSDE的iso文件得到如下目录：

我们只是安装linux下的oracle11g_64，因此，只上传linux文件下的oracle11g_64到服务器。

例如我把此文件上传至/media/目录

[root@oracledb ~]# cp -a /mnt/hgfs/shares/oracle11g_64/ /media/

[root@oracledb ~]#

[root@oracledb ~]# cp -a /mnt/hgfs/shares/oracle11g_64/ /media/

[root@oracledb ~]#
[root@oracledb ~]#chmod –R 777 /media/ oracle11g_64

4．创建SDE的用户、表空间、赋予权限，查看一下相关的SQL文件

首先切换到oracle用户

[root@oracledb ~]#su - oracle

其实创建这些东西不需要我们自己去做的，经查实在oracle11g_64目录下面有一个02.tar的包，解压包有一个createsdeoracle .sql文件：

[root@oracledb ~]# su - oracle
[oracle @oracledb ~]$ ll /media/oracle11g_64/
total 153916
-rwxrwxrwx 1 root root 18699 May 21 2010 01.toc

-rwxrwxrwx 1 root root 157460480 May 21 2010 02.tar
-rwxrwxrwx 1 root root 5366 May 21 2010 b5.nls
-rwxrwxrwx 1 root root 8648 May 21 2010 en.nls
-rwxrwxrwx 1 root root 52923 May 21 2010 install
-rwxrwxrwx 1 root root 9015 May 21 2010 ja.nls
-rwxrwxrwx 1 root root 9011 May 21 2010 jp.nls
-rwxrwxrwx 1 root root 10786 May 21 2010 ko.nls
-rwxrwxrwx 1 root root 7776 May 21 2010 th.nls
-rwxrwxrwx 1 root root 5366 May 21 2010 tw.nls
-rwxrwxrwx 1 root root 5335 May 21 2010 zh.nls

[oracle @oracledb ~]$ tar –xvf /media/oracle11g_64/02.tar

默认解压在主目录的sdeexe100目录中

[oracle @oracledb ~]$ ll sdeexe100/tools/oracle/

total 20
-rw-r--r-- 1 oracle oinstall 979 Mar 30 2010 arcsde_database_startup.sql
-rw-r--r-- 1 oracle oinstall 5118 Apr 27 2010 createsdeoracle.sql
-rw-r--r-- 1 oracle oinstall 1389 Mar 30 2010 xml_lob_block_distribution.sql
-rw-r--r-- 1 oracle oinstall 2351 Mar 30 2010 xml_lob_cache_size.sql
[oracle@oracledb ~]$

打开这个文件进行编辑，主要修改一下几个地方我标记为红色的地方：<password>改为你的密码，LOCATION改为你的路径，前面创建的orcl表空间位置

[oracle @oracledb ~]$ vim sdeexe100/tools/oracle/createsdeoracle.sql

prompt * CREATESDEORACLE.SQL script *
prompt * *
prompt * Purpose: *
prompt * *
prompt * To create the SDE tablespace, the SDE Oracle user *
prompt * and grant privileges to the SDE user *
prompt * *
prompt * NOTES: 1. Before running this script *
prompt * Replace the word LOCATION with the pathname for *
prompt * the sde.dbf datafile to be created. *
prompt * *
prompt * 2. If upgrading remove rem from the grants and *
prompt * revokes in the upgrade section *
prompt * *
prompt * 3. Please use the sys user to run this script. *
prompt * You will also need the system user password *
prompt * *
prompt * Example: *
prompt * % sqlplus "sys as sydba" @createsdeoracle.sql *
prompt * *
prompt * *
prompt **************************************************************
rem /****************************************************************
rem *
rem *
rem *
rem *:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
rem *
rem * COPYRIGHT 1992-2010 ESRI
rem *
rem * TRADE SECRETS: ESRI PROPRIETARY AND CONFIDENTIAL
rem * Unpublished material - all rights reserved under the
rem * Copyright Laws of the United States.
rem *
rem * For additional information, contact:
rem * Environmental Systems Research Institute, Inc.
rem * Attn: Contracts Dept
rem * 380 New York Street
rem * Redlands, California, USA 92373
rem *
rem * email: contracts@esri.com
rem *
rem *
rem *:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
rem ***********************************************************************
prompt * Granting of permissions by the SYS user in Oracle, on two packages
prompt * to the public role.
grant execute on dbms_pipe to public;
grant execute on dbms_lock to public;
prompt * * * * * * * * * * * * * * *
prompt * ArcSDE NEW INSTALLATION *
prompt * * * * * * * * * * * * * * *
prompt * Connect as system/<password> to create the sde
prompt * tablespace and user.
connect system/<password>
prompt * Create the sde tablespace.
prompt * Before you run this script update LOCATION for the desired datafile pathname.
create tablespace sde
datafile '/LOCATION/sde.dbf' size 400M
extent management local uniform size 512K;
prompt * Create the sde user
prompt * The password for the sde user is set to "sde". You may
prompt * change this if you wish.
create user sde identified by sde
default tablespace sde temporary tablespace temp;
prompt * Granting the required privileges to the sde user.
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 CREATE VIEW to sde;
prompt * UNLIMITED TABLESPACE is not required. Grant this privilege
prompt * if you do not wish to explicitly manage and grant tablespace quota to SDE user.
grant UNLIMITED TABLESPACE to sde;
prompt * ADMINISTER DATABASE TRIGGER can be revoked after install
grant ADMINISTER DATABASE TRIGGER to sde;
prompt * * * * * * * * * * *
prompt * ArcSDE UPGRADE *
prompt * * * * * * * * * * *
prompt * If upgrading please remove rem from each grant.
prompt * Granting the required privileges to the sde user.
REM grant ADMINISTER DATABASE TRIGGER to sde;
REM grant SELECT ANY TABLE to sde;
REM grant ALTER ANY INDEX to sde;
REM grant CREATE ANY TRIGGER to sde;
REM grant CREATE ANY INDEX to sde;
REM grant DROP ANY INDEX to sde;
REM grant CREATE ANY VIEW to sde;
REM grant DROP ANY VIEW to sde;
prompt * After upgrading you may revoke the following privileges
prompt * Please remove rem from each revoke.
prompt * Revoking the upgrade privileges to the sde user.
REM revoke ADMINISTER DATABASE TRIGGER from sde;
REM revoke SELECT ANY TABLE from sde;
REM revoke ALTER ANY INDEX from sde;
REM revoke CREATE ANY TRIGGER from sde;
REM revoke CREATE ANY INDEX from sde;
REM revoke DROP ANY INDEX from sde;
REM revoke CREATE ANY VIEW from sde;
REM revoke DROP ANY VIEW from sde;
prompt * Revoking privileges may cause ARCSDE objects to become invalid.
prompt * Remove rem and run the following command to recompile ArcSDE objects.
REM exec dbms_utility.compile_schema( 'SDE', compile_all => FALSE );
exit;

执行此sql文件，创建所有的信息：

[oracle@localhost ~]$ sqlplus sys/oracle@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 12 16:46:25 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> @ /sdeexe100/tools/oracle/ createsdeoracle.sql;
* CREATESDEORACLE.SQL script *
* *
* Purpose: *
* *
* To create the SDE tablespace, the SDE Oracle user *
* and grant privileges to the SDE user *
* *
* NOTES: 1. Before running this script *
* Replace the word LOCATION with the pathname for *
* the sde.dbf datafile to be created. *
* *
* 2. If upgrading remove rem from the grants and *
* revokes in the upgrade section *
* *
* 3. Please use the sys user to run this script. *
* You will also need the system user password *
* *
* Example: *
* % sqlplus "sys as sydba" @createsdeoracle.sql *
* *
* *
**************************************************************
* Granting of permissions by the SYS user in Oracle, on two packages
* to the public role.
Grant succeeded.
Grant succeeded.
* * * * * * * * * * * * * * *
* ArcSDE NEW INSTALLATION *
* * * * * * * * * * * * * * *
* Connect as system/<password> to create the sde
* tablespace and user.
Connected.
* Create the sde tablespace.
* Before you run this script update LOCATION for the desired datafile pathname.
Tablespace created.
* Create the sde user
* The password for the sde user is set to "sde". You may
* change this if you wish.
User created.
* Granting the required privileges to the sde user.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
Grant succeeded.
* UNLIMITED TABLESPACE is not required. Grant this privilege
* if you do not wish to explicitly manage and grant tablespace quota to SDE user .
Grant succeeded.
* ADMINISTER DATABASE TRIGGER can be revoked after install
Grant succeeded.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Pr oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options

测试sde是否连的通：

[oracle@localhost ~]$ sqlplus sde/sde@orcl
SQL*Plus: Release 11.2.0.1.0 Production on Mon May 12 16:49:32 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>

5．安装arcsde

创建安装目录,并把安装文件复制过去（是用root用户安装）

[root@oracledb ~]#mkdir –p /opt/sde

[root@oracledb ~]#cp –a /media/oracle11g_64 /opt/sde

cd到目录进行安装

[root@oracledb ~]#cd /opt/sde/oracle11g_64

[root@localhost~]# cd /opt/sde/oracle11g_64
[root@localhost oracle11g_64]# ./install -load
你可以读懂本行文字吗?
Is the previous statement legible in your native language? [yes]
Continue installation with the selected language interaction? [yes]
如果你已阅读并同意所附许可协议中的条款,请输入'yes'继续安装过程, 否则按<回车>键或输入'no'退出安装过程. [no] yes
敲回车选择默认项, '?'帮助, '^'返回到
上一个问题, 或'q'退出.
输入CD-ROM mount点: [/mediamnt] /opt/sde/linux/oracle11g_64/
输入安装目录的路径名: [/opt/sde/linux/oracle11g_64] /home/arcsde/
ArcSDE version 10.0 for Oracle11g - May 20, 2010
--------------------------------------------------
ArcSDE Product
将要安装的软件模块号: [all]
软件模块选择完毕
--------------------------
你选择了安装下列软件模块
ArcSDE Product
ArcSDE Server
这正确吗? [yes]
安装时列出文件名吗? [no]
正在安装软件, 请等待...
软件安装完毕
退出...
[root@localhost oracle11g_64]#

6．修改环境变量

[oracle@localhost ~]$ vim .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
export PATH=$PATH:$HOME/bin
export ORACLE_BASE=/opt/oracle/app
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID=orcl
export TNS_ADMIN=$ORACLE_HOME/network/admin
export SDEHOME=/opt/sde/oracle11g_64/sdeexe100
export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib
export PATH=$PATH:$HOME:$ORACLE_HOME/bin:$SDEHOME/bin:/usr/lib64

使之生效

[oracle@localhost ~]$ source .bash_profile

7．修改配置文件

修改配置文件参数，在ArcSDE用户下修改$SDEHOME/etc/services.sde文件添加实例名和端口号

[arcsde@localhost etc]$ vi services.sde
[arcsde@localhost etc]$ more services.sde
/* $Id: services.sde,v 1.2 1999/01/22 01:01:35 donna Exp $ */
#
# ESRI SDE Remote Protocol
# Note: uncomment the line below to use ESRI's default port
#
esri_sde 5151/tcp

在Root用户下/etc/services文件一样添加

[root@localhost ~]# vi /etc/services

执行sdesetup命令出错

[oracle@localhost ~]$ sdesetup -o
-bash: sdesetup command not found

查看一下sde软件的安装目录

[oracle@localhost sdeexe100]$ ll
总计 20
drwxr-xr-x 2 root root 4096 02-22 13:34 bin
drwxr-xr-x 2 root root 4096 02-22 13:48 etc
drwxr-xr-x 2 root root 4096 02-22 13:34 lib
drwxr-xr-x 4 10018 kmem 4096 2010-01-09 locale
drwxr-xr-x 3 root root 4096 02-22 13:34 tools

这么目录应该为arcsde用户所属oinstall组，切换到root用户执行以下

[root@localhost ~]# chown -R arcsde:oinstall /opt/sde/oracle11g_64
[root@localhost ~]# chmod -R 755 /opt/sde/oracle11g_64
[root@localhost ~]# su - arcsde
[oracle@localhost ~]$ cd $SDEHOME
[oracle@localhost sdeexe100]$ ll
总计 20
drwxr-xr-x 2 arcsde oinstall 4096 02-22 13:34 bin
drwxr-xr-x 2 arcsde oinstall 4096 02-22 13:48 etc
drwxr-xr-x 2 arcsde oinstall 4096 02-22 13:34 lib
drwxr-xr-x 4 arcsde oinstall 4096 2010-01-09 locale
drwxr-xr-x 3 arcsde oinstall 4096 02-22 13:34 tools

8．创建SDE的Schema

[oracle@localhost ~]$ sdesetup -o install -d oracle11g -p sde
ESRI ArcSDE Server Setup Utility Mon May 12 17:18:10 2014
----------------------------------------------------------------
Install or update ArcSDE, GDB schema objects: Are you sure? (Y/N): y
Checking INSTALL privileges for geodatabase ...
Current user has privilege to install geodatabase instance.
Checking geodatabase XML datatype support...
Underlying RDBMS database instance supports XML data type.
Creating ArcSDE schema.....
Successfully created ArcSDE schema.
Installing St_Geometry ....
Successfully installed St_Geometry.
Creating geodatabase schema.....
Successfully created GDB schema.
Successfully installed ArcSDE components.
Refer SDEHOME\etc\sde_setup.log for more details.

9．更新相关的lic，注意lic文件的所属用户，所属组以及读写权限(注意这个sde 10.ecp为我自己编写的，发现之前的问题，里面只需要一条记录就ok了)

[oracle@localhost ~]$ sdesetup -o update_key -d oracle11g -l /media/sde\ 10.ecp -u sde -p sde -N
ESRI ArcSDE Server Setup Utility Wed Feb 22 14:41:41 2012
----------------------------------------------------------------
Successfully updated authorization key.

10．启动ArcSDE服务

[oracle@oracledb ~]$ sdemon -o start

Please enter ArcSDE DBA password:

-------------------------------------------------------

ArcSDE 10.0 for Oracle11g Build 685 Fri May 14 12:05:43 2010

-------------------------------------------------------

ST_Geometry Schema Owner: (SDE) Type Release: 1007

Instance initialized for ((sde)) . . .

Connected to instance . . .

DBMS Connection established...

RDBMS: "Oracle"

Instance Name: "esri_sde"