sde 安装
http://blog.csdn.net/jx0923/article/details/4581546
sde安装 步骤
========================================================
1、设置环境变量
export SDEHOME=/opt/sde/sdeexe93
export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
export ORACLE_SID=fngt
export PATH=.:$JAVA_HOME/bin:$PATH:$HOME/bin:$SDEHOME/bin:$ORACLE_HOME/bin
export JAVA_HOME=/usr/java/jdk1.5.0_15
export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib32
==============================================================================
2、安装sde
[sde@fngt1 oracle10g]$ ./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] /opt/install/sde/oracle10g
Enter pathname to install directory: [/opt/install/sde/oracle10g] /opt/sde
ArcSDE version 9.3 for Oracle10g - May 14, 2008
-------------------------------------------------
ArcSDE Product
Package numbers to load: [all]
Package selection complete
--------------------------
You have chosen the following packages to be loaded
ArcSDE Product
ArcSDE Server
Is this correct? [yes]
Total size of chosen packages in megabytes: 169.7
Available space in megabytes: 136344.0
List file names while loading? [no]
=============================================================================================
3、修改 /opt/sde/sdeexe93/etc/service.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
#
~
===========================================================================================
4、创建表空间和用户
CREATE TABLESPACE tbs_sde
LOGGING
DATAFILE '/opt/oracle/oradata/fngt/sde_2g_01.dbf' SIZE 1024M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE TABLESPACE tbs_sde_idx
LOGGING
DATAFILE '/opt/oracle/oradata/fngt/sde_idx_2g_01.dbf' SIZE 1024M
EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
CREATE USER sde
IDENTIFIED BY sde
DEFAULT TABLESPACE tbs_sde
TEMPORARY TABLESPACE temp
QUOTA UNLIMITED ON tbs_sde
QUOTA UNLIMITED ON tbs_sde_idx
PROFILE DEFAULT;
GRANT CONNECT TO sde;
GRANT RESOURCE TO sde;
ALTER USER sde DEFAULT ROLE ALL;
REVOKE UNLIMITED TABLESPACE FROM sde;
============================================================================================
5、sys用户执行
GRANT EXECUTE ON DBMS_PIPE TO PUBLIC;
GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;
=========================================================================================
6、sdesetup
[sde@fngt1 ~]$ sdesetup -o install -d ORACLE10G -u sde -p sde -i esri_sde -l /opt/install/sde/sde93.ecp
ESRI ArcSDE Server Setup Utility Wed Sep 23 21:14:00 2009
----------------------------------------------------------------
Install or update ArcSDE, GDB schema objects:
Are you sure? (Y/N): y
Creating ArcSde schema.....
To install your ArcSDE for Oracle
service, you will also have to grant the following
additional permissions to the sde user to accomplish
the install:
CREATE SESSION
CREATE TABLE
CREATE VIEW
CREATE PROCEDURE
CREATE SEQUENCE
CREATE TRIGGER
CREATE TYPE
CREATE INDEXTYPE
CREATE LIBRARY
CREATE PUBLIC SYNONYM
DROP PUBLIC SYNONYM
ADMINISTER DATABASE TRIGGER
CREATE OPERATOR
Error: Insufficient permissions (-25).
Error: SDE release install not completed.
Check SDEHOME/etc/sde_setup.log for more details.
=============================================================================================================
8、grant 权限
sys 用户
grant CREATE SESSION to sde;
grant CREATE TABLE to sde;
grant CREATE VIEW to sde;
grant CREATE PROCEDURE to sde;
grant CREATE SEQUENCE to sde;
grant CREATE TRIGGER to sde;
grant CREATE TYPE to sde;
grant CREATE INDEXTYPE to sde;
grant CREATE LIBRARY to sde;
grant CREATE PUBLIC SYNONYM to sde;
grant DROP PUBLIC SYNONYM to sde;
grant ADMINISTER DATABASE TRIGGER to sde;
grant CREATE OPERATOR to sde;
==================================================================================================================
9、重新sdesetup
[sde@fngt1 ~]$ sdesetup -o install -d ORACLE10G -u sde -p sde -i esri_sde -l /opt/install/sde/sde93.ecp
ESRI ArcSDE Server Setup Utility Wed Sep 23 21:16:09 2009
----------------------------------------------------------------
Install or update ArcSDE, GDB schema objects:
Are you sure? (Y/N): y
Creating ArcSde schema.....
Successfully created ArcSde schema.
Installing locators.....
Successfully installed locators.
Creating geodatabase schema.....
Successfully created GDB schema.
Registering authorization key.....
Successfully registered authorization key.
Successfully installed ArcSDE components.
Refer SDEHOME/etc/sde_setup.log for more details.
==================================================================================================================
10、启动 sde
[sde@fngt1 ~]$ sdemon -o start
Please enter ArcSDE DBA password:
-------------------------------------------------------
ArcSDE 9.3 for Oracle10g Build 508 Thu Apr 17 12:23:18 2008
-------------------------------------------------------
ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((sde)) . . .
Connected to instance . . .
DBMS Connection established...
RDBMS: "Oracle"
Instance Name: "esri_sde"
IOMGR Process ID (PID): 30855
ArcSDE Instance esri_sde started Wed Sep 23 21:23:49 2009
=======================================================================================================================
安装完成！！
