arcsde for oracle 11gecp,ArcSDE9.3 for AIX 安装

环境:

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==============================