环境:
OS:AIX 5300 09-06-1013 64bit
DB:Oracle 11G R1 (11.1.1.6.0)
SDE:9.3 for oralce11G x64
1、新建arcsde用户
用root用户登陆,新建arcsde用户
2、设置环境变量
在root用户状态中,/home/arcsde/目录下,.profile配置文件
#cd /home/arcsde
#vi .profile
SDEHOME=/usr/arcsde/sdeexe93
export SDEHOME
ORACLE_HOME=/oracle/product/11g
export ORACLE_HOME
ORACLE_SID=hzdb
export ORACLE_SID
TNS_ADMIN=/oracle/product/11g/network/admin
export TNS_ADMIN
LIBPATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib
export LIBPATH
NLS_LANG=american_america.ZHS16GBK
export NLS_LANG
PATH=$PATH:$SDEHOME/bin:$SDEHOME/lib:$ORACLE_HOME/bin:/usr/bin:/usr/ucb:/etc:/ho
me/sde/sdeexe93/bin
export PATH
3、安装SDE
$ ./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 or type 'no' to exit installation process. [no] yes
Press to take the default, '?' for help, '^' to return to
the previous question, or 'q' to quit.
Enter CD-ROM mount point: [/cdrom] /home/arcsde/oracle11g_64/
Enter pathname to install directory: [/home/arcsde/oracle11g_64] /usr/arcsde
ArcSDE version 9.3 for Oracle11g - May 15, 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: 237.9
Available space in megabytes: 2901.2
List file names while loading? [no] no
Loading package(s), Please wait...
Finished loading package(s)
Exiting...
4、修改 /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
#
5、创建SDE表空间和SDE用户
在oracle中创建sde用户和表空间
如果第一次安装sde,则需要执行这步操作;
如果在oracle中sde表空间和数据都存在就跳过此步骤
此处注意SDE用户的权限问题,本人将DBA角色赋予SDE用户,另外SDE的默认表空间要设置为SDE表空间
6、sys用户执行
GRANT EXECUTE ON DBMS_PIPE TO PUBLIC;
GRANT EXECUTE ON DBMS_LOCK TO PUBLIC;
7、sdesetup //执行PostInstall并添加授权文件
$ sdesetup -o install -d ORACLE11G -u sde -p sde -i esri_sde -l /home/arcsde/oracle11g_64/ArcSDE9.3.ecp
ESRI ArcSDE Server Setup Utility Wed May 12 16:41:39 2010
----------------------------------------------------------------
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.
8、启动SDE服务
$ sdemon -o start -i esri_sde -p sde
-------------------------------------------------------
ArcSDE 9.3 for Oracle11g 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): 503908
ArcSDE Instance esri_sde started Wed May 12 16:49:44 2010
$
===================================END==============================