arcsde9.3.1 for oracle10g and redhat_5.5_x64安装文档.doc

Arcsde 9.3.1 for oracle10204安装文档 适用区域中国区域产品名称Arcsde 9.3.1 for oracle10204安装文档使用对象现场工程师产品版本编写部门系统部资料版本V1.0适合产品Arcsde 9.3.1 for oracle10g安装文档拟 制：李强日 期：2010年10月10日审 核：日 期：审 核：日 期：批 准：日 期：修订记录日期修订版本描述作者2010-10-10V1.0李强2020-3-20第20页, 共20页目 录第一章系统环境41.1系统版本号41.2 创建用户41.3 环境变量51.4 验证环境变量生效51.5 检查系统中安装包6第二章Sde实例脚本62.1 创建脚本62.2 执行脚本82.3 验证8第三章安装arcgis93.1 准备arcgis软件93.2 开始安装93.3 常见报错日志11第四章安装sde oracle数据库144.1 安装sde144.2 启动sde服务164.3 安装license174.4 再启动sde服务17Arcsde 9.3.1 for oracle10204安装文档- redhat_as5.5_x64第一章 系统环境1.1系统版本号 rootszdb1 # uname -aLinux szdb1 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux1.2 创建用户使用root用户创建arcsde用户#useradd -g dba arcsde#passwd arcsde1.3 环境变量在终端上切换到arcsde#su - arcsdearcsdeszdb1 $ cat /.bash_profile # .bash_profile # Get the aliases and functionsif -f /.bashrc ; then . /.bashrcfi # User specific environment and startup programsPATH=$PATH:$HOME/binORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ;export ORA_NLS33ORACLE_BASE=/opt/oracle; export ORACLE_BASEORACLE_SID=noap; export ORACLE_SIDORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOMEPATH=$ORACLE_HOME/bin:$PATH; export PATHNLS_LANG=american_america.ZHS16GBK; export NLS_LANGSDEHOME=/home/arcsde/sdeexe93/;export SDEHOMELD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/libexport LD_LIBRARY_PATHPATH=$PATH:$HOME:$ORACLE_HOME/bin:$SDEHOME/binexport PATHPATH=/usr/bin:sbin:/bin:/usr/sbin:/opt/bin:/usr/local/bin:$ORACLE_HOME/bin:$SDEHOME/bin export PATHLANG=zh_CN.GBK;export LANG1.4 验证环境变量生效退出后运行 source /.bash_profile 使之立即生效执行 arcsdeszdb1 $ echo $PATH/usr/bin:sbin:/bin:/usr/sbin:/opt/bin:/usr/local/bin:/opt/oracle/product/10.2.0/db_1/bin:/home/arcsde/sdeexe93/bin1.5 检查系统中安装包安装arcsde软件，需要设置客户端字符集模式，直到能卡看到以下中文显示安装前需要检查系统中存在的包rootszdb1 # rpm -qa|grep compat-libf2c-34compat-libf2c-34-3.4.6-4compat-libf2c-34-3.4.6-4rootszdb1 # rpm -qa|grep openmotifopenmotif-2.3.1-2.el5_4.1openmotif-2.3.1-2.el5_4.1openmotif22-2.2.3-18openmotif22-2.2.3-18rootszdb1 # rpm -qa|grep compat-libf2ccompat-libf2c-34-3.4.6-4compat-libf2c-34-3.4.6-4-请用命令rpm ivh * 安装缺失的包第二章 Sde实例脚本2.1 创建脚本在oracle目录下，生成sde数据库的脚本oracleszdb1 $ cat createsdeoracle.sql grant execute on dbms_pipe to public;grant execute on dbms_lock to public; connect system/sznoap2010 #需要改密码create tablespace sde datafile +NOAPGD size 500M autoextend on; #深圳大运会noap数据库是用asm磁盘来做存储的，请酌情更改create user sde identified by sde default tablespace sde temporary tablespace temp;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 * 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.2 执行脚本以oracle用户登陆近数据库oracleszdb1 $sqlplus /as sysdbaSQL*Plus: Release .0 - Production on Fri Jul 16 09:27:48 2010Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL createsdeoracle.sql执行完应该无报错！2.3 验证从数据库查看sde实例是否存在，简单的方法是打开sqlplus看能否连接到sde实例第三章 安装arcgis 3.1 准备arcgis软件rootszdb1 #将arcsde9.3.1软件ESRI-gis_unix.iso拷贝到/tmp 下rootszdb1 #mount o loop /tmp/ESRI-gis_unix.iso /tmp/arcgisrootszdb1 #chown -R arcsde:arcsde /tmp/arcgisrootszdb1 # su arcsdearcsdeszdb1# cd /tmp/arcgis3.2 开始安装arcsdeszdb1 oracle10g_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点: /cdrom /tmp/arcgis/oracle10g_64 输入模块号码以安装该模块. 1 - /arcsde/hp/db2_64 2 - /arcsde/hp/informix 3 - /arcsde/hp/oracle10g_64 4 - /arcsde/hp/oracle9i_64 5 - /arcsde/hpia/oracle10g_64 6 - /arcsde/ibm/db2_64 7 - /arcsde/ibm/informix 8 - /arcsde/ibm/oracle10g_64 9 - /arcsde/ibm/oracle11g_64 10 - /arcsde/ibm/oracle9i_64 11 - /arcsde/linux/db2 12 - /arcsde/linux/informix 13 - /arcsde/linux/oracle10g 14 - /arcsde/linux/oracle10g_64 15 - /arcsde/linux/oracle11g 16 - /arcsde/linux/oracle11g_64 17 - /arcsde/linux/oracle9i 18 - /arcsde/linux/pg/arcsde 19 - /arcsde/solaris/db2_64 20 - /arcsde/solaris/informix 21 - /arcsde/solaris/oracle10g_64 22 - /arcsde/solaris/oracle11g_64 23 - /arcsde/solaris/oracle9i_64 输入希望安装的模块号码: 1 14 输入安装目录的路径名: /arcsde/linux/oracle10g_64 /home/arcsde/ ArcSDE version 9.3.1 for Oracle10g - Mar 10, 2009 - ArcSDE Product 将要安装的软件模块号: all 软件模块选择完毕- 你选择了安装下列软件模块 ArcSDE Product ArcSDE Server 这正确吗? yes 被选中的软件模块共占空间(兆字节): 160.5 剩余空间(兆字节): 3052.0 安装时列出文件名吗? no no 正在安装软件, 请等待. 软件安装完毕 退出.3.3 常见报错日志arcsdeszdb1 oracle10g_64$ 这是在系统缺少包的情况下，出现的报错日志： arcsdeszdb1 $ sdemon -o startsdemon: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory rootszdb1 # yum install libg2c.so.0 Loaded plugins: rhnplugin, securityThis system is not registered with RHN.RHN support will be disabled.rhel-debuginfo | 1.3 kB 00:00 Setting up Install ProcessResolving Dependencies- Running transaction check- Package compat-libf2c-34.i386 0:3.4.6-4 set to be updated- Finished Dependency Resolution Dependencies Resolved Package Arch Version Repository SizeInstalling: compat-libf2c-34 i386 3.4.6-4 rhel-debuginfo 52 k Transaction Summary Install 1 Package(s)Upgrade 0 Package(s) Total download size: 52 kIs this ok y/N: yDownloading Packages:Running rpm_check_debugRunning Transaction TestFinished Transaction TestTransaction Test SucceededRunning Transaction Installing : compat-libf2c-34 1/1 Installed: compat-libf2c-34.i386 0:3.4.6-4 Complete! rootszdb1 # yum install libXm.so.3Loaded plugins: rhnplugin, securityThis system is not registered with RHN.RHN support will be disabled.rhel-debuginfo | 1.3 kB 00:00 Setting up Install ProcessPackage openmotif22-2.2.3-18.i386 already installed and latest versionNothing to dorootszdb1 # yum install openmotif22Loaded plugins: rhnplugin, securityThis system is not registered with RHN.RHN support will be disabled.rhel-debuginfo | 1.3 kB 00:00 Setting up Install ProcessPackage openmotif22-2.2.3-18.i386 already installed and latest versionResolving Dependencies- Running transaction check- Package openmotif22.x86_64 0:2.2.3-18 set to be updated- Finished Dependency Resolution Dependencies Resolved = Package Arch Version Repository Size=Installing: openmotif22 x86_64 2.2.3-18 rhel-debuginfo 1.3 M Transaction Summary=Install 1 Package(s)Upgrade 0 Package(s) Total download size: 1.3 MIs this ok y/N: yDownloading Packages:Running rpm_check_debugRunning Transaction TestFinished Transaction TestTransaction Test SucceededRunning Transaction Installing : openmotif22 1/1 Installed: openmotif22.x86_64 0:2.2.3-18 Complete!第四章 安装sde oracle数据库4.1 安装sdearcsdeszdb1 bin$ sdesetup -o install -d ORACLE10G -p sde SES_iconv_open(UTF-8,zh_CN.euc) failed) Enter DBA password: SES_iconv_open(UTF-8,zh_CN.euc) failed) ESRI ArcSDE Server Setup Utility Thu Jul 15 16:45:43 2010- SES_iconv_open(UTF-8,zh_CN.euc) failed) Install or update ArcSDE, GDB schema objects: Are you sure? (Y/N): YCreating ArcSde schema.Error: Bad login user (-9).Error: SDE release install not completed. Check SDEHOMEetcsde_setup.log for more details.arcsdeszdb1 bin$ export LANG=C #修改字符显示arcsdeszdb1 bin$ sdesetup -o install -d ORACLE10G -p sde ESRI ArcSDE Server Setup Utility Thu Jul 15 16:46:06 2010-Install or update ArcSDE, GDB schema objects: Are you sure? (Y/N): yCreating ArcSde schema.To install your ArcSDE for Oracleservice, you will also have to grant the followingadditional permissions to the sde user to accomplishthe 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 OPERATORError: Insufficient permissions (-25). #提示权限不够，赋予sde DBA权限； grant dba to sde;Error: SDE release install not completed. Check SDEHOMEetcsde_setup.log for more details.arcsdeszdb1 bin$ sdesetup -o install -d ORACLE10G -p sde ESRI ArcSDE Server Setup Utility Thu Jul 15 16:47:46 2010-Install or update ArcSDE, GDB schema objects: Are you sure? (Y/N): YCreating ArcSde schema.Successfully created ArcSde schema. Installing locators.Successfully installed locators. Creating geodatabase schema.Successfully created GDB schema. Successfully installed ArcSDE components. Refer SDEHOMEetcsde_setup.log for more details.4.2 启动sde服务arcsdeszdb1 bin$ sdemon -o startPlease enter ArcSDE DBA password: -ArcSDE 9.3 for Oracle10g Build 546 Thu Sep 18 12:35:50 2008- ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for (sde) . . . Connected to instance . . . DBMS Connection established. Error (-327), No ArcSDE server license found. -需要注册后才能启动服务 Could not start ArcSDE - Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.arcsdeszdb1 bin$ sdesetup -o update_key -d ORACLE10G -l /home/oracle/ma.frank.license.ecp -u sde -p sdeError reading license information Error: (-8027) Text file not found. #不注册报错4.3 安装licensearcsdeszdb1 bin$ sdesetup -o update_key -d ORACLE10G -l /tmp/ma.frank.license.ecp -u sde -p sde ESRI ArcSDE Server Setup Utility Thu Jul 15 17:07:37 2010-Successfully updated authorization key.4.4 再启动sde服务arcsdeszdb1 bin$ sdemon -o startPlease enter ArcSDE DBA password: #输入SDE密码 -ArcSDE 9.3 for Oracle10g Build 546 Thu Sep 18 12:35:50 2008- ST_Geometry Schema Owner: (SDE) Type Release: 1007 Instance initialized for (sde) . . . Connected to instance . . . DBMS Connection established. RDBMS: OracleInstance Name: esri_sde IOMGR Process ID (PID): 18792 完毕！#以下为noap数据库，ASM磁盘组的管理维护办法，启动noap数据库前，需要先启动+ASM数据库，否则不能挂载ASM磁盘组。 ArcSDE Instance esri_sde started Thu Jul 15 17:08:26 2010oracleszdb1 $ export ORACLE_SID=+ASMoracleszdb1 $ set |grep -i sidORACLE_SID=+ASM_=ORACLE_SIDoracleszdb1 $ set |grep -i sidORACLE_SID=+ASMoracleszdb1 $ sqlplus /as sysdba SQL*Plus: Release .0 - Production on Thu Jul 15 17:37:11 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL startupASM instance started Total System Global Area 130023424 bytesFixed Size 2082208 bytesVariable Size 102775392 bytesASM Cache 25165824 bytesASM diskgroups mountedSQL exitDisconnected from Oracle Database 10g Enterprise Edition Release .0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsoracleszdb1 $ export ORACLE_SID=noaporacleszdb1 $ sqlplus /as sysdba SQL*Plus: Release .0 - Production on Thu Jul 15 17:37:35 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to an idle instance. SQL startupORACLE instance started. Total System Global Area 2.6223E+10 bytesFixed Size 2131424 bytesVariable Size 2684357152 bytesDatabase Buffers 2.3522E+10 bytesRedo Buffers 14643200 bytesDatabase mounted.Database opened.SQLlsnrctl start LSNRCTL for Linux: Version .0 - Production on 15-JUL-2010 17:39:00 Copyright (c) 1991, 2007, Oracle. All rights reserved. Starting /opt/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait. TNSLSNR for Linux: Version .0 - ProductionSy