ArcSDE92 for AIX安装手册.doc

ArcSDE92 for Unix安装手册 装机环境：操作系统：Solaris10，IBM AIX5.3主机：Sun和IBM服务器各一台主机名：Sun01，IBM01部署架构：如图所示：一、Sun01服务器上安装过程如下：root 用户要执行的安装步骤root用户下面需要创建ArcSDE的Unix系统管理员用户：1smc命令打开solaris管理控制台2进入到用户管理界面，增加一个sde用户User Name：arcsdeLogin Shell：C ShellPassword：dzsde92Path：/export/home/arcsde注意：不要用root 账号来安装ArcSDE。ArcSDE 用户的安装配置操作设置环境变量需要设置的变量有：-SDEHOME ORACLE_HOME ORACLE_SID TNS_ADMIN PATH $PATH:$SDEHOME/bin:$ORACLE_HOME/binLD_LIBRARY_PATH $SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/libTWO_TASK (如果 ArcSDE和 Oracle分别安装在不同的机器上)-提示：可以拷贝安装Oracle用户的Oracle Profile配制部分到sde profile文件中。配置完后退出再进入使配置生效具体的设置如下：环境变量设置：（arcsde用户下的.cshrc文件）setenv ORACLE_BASE /export/oraclesetenv ORACLE_HOME $ORACLE_BASE/102/db_1setenv ORACLE_SID orcl1setenv NLS_LANG AMERICAN_AMERICA.ZHS16GBK setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/datasetenv SDEHOME /export/home/arcsde/sdeexe92setenv LD_LIBRARY_PATH $SDEHOME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/lib:/usr/lib:/usr/ccs/lib:/libsetenv PATH /usr/bin:sbin:/bin:/usr/sbin:/opt/bin:/usr/local/bin:$ORACLE_HOME/bin:$SDEHOME/binsetenv LANG zh_CN.GBK其中LANG变量必须要设置，否则ArcSDE无法识别中文。然后执行命令：source .cshrc使环境变量生效在Oracle中创建sde用户、表空间和授权1修改%SDEHOME%/tools/oracle/createsdeoracle.sql文件(只需要修改两处地方)以下为文件内容:1） 给sys授权两个包的public角色，无需修改grant execute on dbms_pipe to public;grant execute on dbms_lock to public; 2）. 连接为system/以创建sde表空间和用户，这是需要修改的地方之一。connect system/oracle3）. 创建sde表空间，这是需要修改的地方之二create tablespace sde;4）. 创建sde用户，无需修改create user sde identified by sdedefault tablespace sde temporary tablespace temp;5）. 给该sde用户授权，无需修改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 UNLIMITED TABLESPACE to sde;grant CREATE ANY VIEW to sde;prompt * SELECT ANY TABLE is required for compressing the databaseprompt * This privilege needs to be granted whenever a compress is run.grant SELECT ANY TABLE to sde;prompt * * * * * * * * * * *prompt * ArcSDE UPGRADE *prompt * * * * * * * * * * *prompt * If upgrading please remove rem from each mpt * Granting the required privileges to the sde user.REM grant SELECT ANY TABLE to sde;REM grant SELECT ANY SEQUENCE to sde;REM grant EXECUTE ANY PROCEDURE to sde;REM grant ANALYZE ANY to sde;REM grant ALTER ANY INDEX to sde;REM grant ALTER ANY TABLE to sde;REM grant CREATE ANY SEQUENCE to sde;REM grant CREATE ANY TRIGGER to sde;REM grant CREATE ANY INDEX to sde;REM grant CREATE ANY PROCEDURE to sde;REM grant DROP ANY INDEX to sde;REM grant DROP ANY SEQUENCE to sde;REM grant DROP ANY TABLE to sde;REM grant DROP ANY VIEW to sde;REM grant DROP ANY PROCEDURE to sde;prompt * After upgrading you may revoke the following privilegesprompt * Please remove rem from each mpt * Revoking the upgrade privileges to the sde user.REM revoke SELECT ANY SEQUENCE from sde;REM revoke EXECUTE ANY PROCEDURE from sde;REM revoke ANALYZE ANY from sde;REM revoke ALTER ANY INDEX from sde;REM revoke ALTER ANY TABLE from sde;REM revoke CREATE ANY SEQUENCE from sde;REM revoke CREATE ANY TRIGGER from sde;REM revoke CREATE ANY INDEX from sde;REM revoke CREATE ANY PROCEDURE from sde;REM revoke DROP ANY INDEX from sde;REM revoke DROP ANY SEQUENCE from sde;REM revoke DROP ANY TABLE from sde;REM revoke DROP ANY VIEW from sde;REM revoke DROP ANY PROCEDURE from sde;exit;2运行脚本文件 将脚本文件拷贝到oracle用户目录下面 su oracle cp createsdeoracle.sql /export/oracle sqlplus sys/oracle as sysdba createsdeoracle.sqlArcSDE安装插入sde安装光盘%su arcsde然后进入光盘相应目录（有一个目录称为oracle_64），找到install命令，运行它：% ./install load然后按照提示安装，其中安装的目标路径为/export/home/arcsde第五步: 修改$SDEHOME/etc/services 和系统/etc/services说明：在系统$SDEHOME/etc/ services文件中添加 esri_sde 5151/tcp注意：需要使用root登陆(root access to change)在系统/etc/services文件中添加esri_sde 5151/tcp第六步：运行$SDEHOME/bin/sdesetupsdesetup -o install -d ORACLE10G -p sde第七步：更新许可 (视情况可选)如果第六步的sdesetup -o install后边的参数未指定-l , 则需要用到以下命令来载入许可文件或更新许可文件:例如:sdesetup -o update_key -l /export/home/arcsde/license.dat -u sde -p sde安装后的工作第八步: 启动sde服务sdemon -o startPlease enter ArcSDE DBA password: 键入：sde二、服务器IBM01上安装过程如下：root 用户要执行的安装步骤root用户下面需要创建ArcSDE的Unix系统管理员用户：新建一个sde用户User Name：arcsdeLogin Shell：C ShellPassword：dzsde92Path：/home/arcsde（这里我们将arcsde安装在共享盘阵上）Arcsde用户下的安装配置步骤打开arcsde用户下的.cshrc文件，将上面的环境变量拷贝到文件中：setenv ORACLE_BASE /oraclesetenv ORACLE_HOME $ORACLE_BASE/102/db_1setenv ORACLE_SID orcl1setenv NLS_LANG AMERICAN_AMERICA.ZHS16GBK setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/datasetenv SDEHOME /home/arcsde/sdeexe92setenv LD_LIBRARY_PATH $SDEHOME/lib:$ORACLE_HOME/lib32:$ORAC