配置環境：《Linux上安裝ArcGIS 10_02安裝Oracle 11gR2》中配置的虛擬機 Red Hat Enterprise Linux 5_5 64-bit+Oracle11gR2.zip
安裝人員： xubobo
安裝時間： 2012-12-20
安裝介質： ArcSDE10_UNIX_121100.iso 2.53G(選擇其中的linux/oracle11g_64)
ArcSDE安裝賬戶： arcsde/arcsde, 隸屬於oinstall組。
數據庫實例： orcl.
數據庫上的sde賬戶：sde/sde。
虛擬機版本：Red Hat Enterprise Linux 5_5 64-bit+Oracle11gR2+ArcSDE10+ArcGISServer10.zip
說明：主要參考 http://www.linuxidc.com/Linux/2014-04/99801.htm，按照實際安裝過程更改而來，同時增加有關依賴項的內容。
=====================================================
Linux上安裝ArcGIS 10安裝系列文章：
Linux上安裝ArcGIS 10_01安裝Linux虛擬機及yum源配置 http://www.linuxidc.com/Linux/2014-04/99796.htm
Linux上安裝ArcGIS 10_02安裝Oracle11gR2 http://www.linuxidc.com/Linux/2014-04/99797.htm
Linux上安裝ArcGIS 10_03安裝ArcSDE 10 http://www.linuxidc.com/Linux/2014-04/99798.htm
Linux上安裝ArcGIS 10_04安裝ArcGIS Server 10 http://www.linuxidc.com/Linux/2014-04/99799.htm
Linux上安裝ArcGIS 10.1_01安裝ArcGIS Server 10.1 http://www.linuxidc.com/Linux/2014-04/99800.htm
=====================================================
1：以oracle用戶啟動監聽器，連接數據庫，並啟動orcl數據庫。
[root@localhost ~]$ su - oracle //切換到oracle用戶
[oracle@localhost ~]$ lsnrctl start //啟動監聽器[oracle@localhost ~]$ sqlplus sys/admin as sysdba //連接數據庫
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 22 10:59:05 2012
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> startup //啟動數據庫
2.創建操作系統級別的arcsde用戶，密碼設置為arcsde
[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.
[root@localhost ~]# su - arcsde //切換到roacle用戶
[arcsde@localhost ~]$
3. 創建SDE的用戶、表空間、賦予權限。
查看一下相關的SQL文件.注意登錄的用戶名和密碼，以及dbf文件的位置（所在目錄需存在）。
整理後的sql文件（create.sql）下載地址為：
免費下載地址在 http://linux.linuxidc.com/
用戶名與密碼都是www.linuxidc.com
具體下載目錄在 /2014年資料/4月/9日/Linux上安裝ArcGIS 10_03安裝ArcSDE 10
下載方法見 http://www.linuxidc.com/Linux/2013-07/87684.htm
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 sys/admin@orcl as sysdba
prompt * Create the sde tablespace.
prompt * Before you run this script update LOCATION for the desired datafile pathname.
//創建SDE表空間，路徑需要注意
create tablespace sde datafile '/home/oracle/app/oracle/oradata/ORCL/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;
exit;
以oracle用戶登錄連接數據庫後，執行該SQL文件（執行語法SQL->@ /home/arcsde/create.sql,注意查看oracle用戶對該文件是否有相關權限），創建的用戶為sde，密碼為sde。
[oracle@localhost ~]$ sqlplus <span data-mce-mark="1">sys/admin</span>@orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 22 11:44:53 2012
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> @<span data-mce-mark="1"> home/arcsde/create.sql</span>;
* 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 Wed Feb 22 11:46:18 2012
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>
3. 安裝相關的ArcSDE軟件
首先將ArcSDE光盤插入光驅，使用mount命令，如果條件允許也可以SSH工具直接傳入
[root@localhost ~]# mount /dev/cdrom /mnt/cdrom
mount: block device /dev/cdrom is write-protected, mounting read-only
mount: /dev/cdrom already mounted or /mnt/cdrom busy
mount: according to mtab, /dev/hdc is already mounted on /mnt/cdrom
[root@localhost ~]# cd /mnt/cdrom
[root@localhost sde]# ls
documentation_server htm install_db2.htm install_oracle.htm linux solaris
hpia ibm install_informix.htm install_postgresql.htm quickstart.htm
然後我們執行安裝命令，安裝過程中會提示用戶軟件安裝介質在什麼位置，這些軟件需要安裝到什麼位置
[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] /mnt/cdrom/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]#
4. 設置環境變量
根據用戶軟件安裝的位置以及Oracle軟件安裝的信息，添加arcsde用戶的環境變量
[arcsde@localhost ~]$ vi .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=/home/oracle/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export TNS_ADMIN=$ORACLE_HOME/network/admin
export SDEHOME=/home/arcsde/sdeexe100
export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib
export PATH=$PATH:$HOME:$ORACLE_HOME/bin:$SDEHOME/bin
修改完畢環境變量，使之生效，然後測試一下是否生效
[arcsde@localhost ~]$ vi .bash_profile
[arcsde@localhost ~]$ . ./.bash_profile // 也可使用 source .bash_profile使其生效
[arcsde@localhost ~]$ echo $SDEHOME
/home/arcsde/sdeexe100
[arcsde@localhost sdeexe100]$
5.修改配置文件參數
在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 $ */
# s
# ESRI SDE Remote Protocol
# Note: uncomment the line below to use ESRI's default port
#
esri_sde 5151/tcp
在root用戶下/etc/services文件一樣添加 esri_sde 5151/tcp
[root@localhost ~]# vi /etc/services
