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

Arcsde 9.3.1 for oracle10g安装文档修订记录目录第一章系统环境 (4)1.1系统版本号 (4)1.2 创建用户 (4)1.3 环境变量 (4)1.4 验证环境变量生效 (5)1.5 检查系统中安装包 (5)第二章Sde实例脚本 (6)2.1 创建脚本 (6)2.2 执行脚本 (8)2.3 验证 (8)第三章安装arcgis (8)3.1 准备arcgis软件 (8)3.2 开始安装 (8)3.3 常见报错日志 (11)第四章安装sde oracle数据库 (13)4.1 安装sde (13)4.2 启动sde服务 (15)4.3 安装license (16)4.4 再启动sde服务 (16)Arcsde 9.3.1 for oracle10204安装文档--- redhat_as5.5_x64第一章系统环境1.1系统版本号[root@szdb1 ~]# 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 - arcsde[arcsde@szdb1 ~]$ 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_HOME PATH=$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:$SDEHOM E/binexport PATHLANG=zh_CN.GBK;export LANG1.4 验证环境变量生效退出后运行source ~/.bash_profile 使之立即生效执行[arcsde@szdb1 ~]$ echo $PATH/usr/bin:sbin:/bin:/usr/sbin:/opt/bin:/usr/local/bin:/opt/oracle/product/10.2.0/db_1/bin:/hom e/arcsde/sdeexe93//bin1.5 检查系统中安装包安装arcsde软件，需要设置客户端字符集模式，直到能卡看到以下中文显示安装前需要检查系统中存在的包[root@szdb1 ~]# rpm -qa|grep compat-libf2c-34compat-libf2c-34-3.4.6-4compat-libf2c-34-3.4.6-4[root@szdb1 ~]# 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-18[root@szdb1 ~]# rpm -qa|grep compat-libf2ccompat-libf2c-34-3.4.6-4compat-libf2c-34-3.4.6-4---请用命令rpm –ivh * 安装缺失的包第二章Sde实例脚本2.1 创建脚本在oracle目录下，生成sde数据库的脚本[oracle@szdb1 ~]$ cat createsdeoracle.sqlgrant 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 grant.prompt * 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 privileges prompt * Please remove rem from each grant.prompt * 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用户登陆近数据库[oracle@szdb1 ~]$sqlplus '/as sysdba'SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jul 16 09:27:48 2010 Copyright (c) 1982, 2007, Oracle. All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>@ createsdeoracle.sql……执行完应该无报错！2.3 验证从数据库查看sde实例是否存在，简单的方法是打开sqlplus看能否连接到sde实例第三章安装arcgis3.1 准备arcgis软件[root@szdb1 ~]#将arcsde9.3.1软件ESRI-gis_unix.iso拷贝到/tmp 下[root@szdb1 ~]#mount –o loop /tmp/ESRI-gis_unix.iso /tmp/arcgis[root@szdb1 ~]#chown -R arcsde:arcsde /tmp/arcgis[root@szdb1 ~]# su – arcsde[arcsde@szdb1]# cd /tmp/arcgis3.2 开始安装[arcsde@szdb1 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_642 - /arcsde/hp/informix3 - /arcsde/hp/oracle10g_644 - /arcsde/hp/oracle9i_645 - /arcsde/hpia/oracle10g_646 - /arcsde/ibm/db2_647 - /arcsde/ibm/informix8 - /arcsde/ibm/oracle10g_649 - /arcsde/ibm/oracle11g_6410 - /arcsde/ibm/oracle9i_6411 - /arcsde/linux/db212 - /arcsde/linux/informix13 - /arcsde/linux/oracle10g14 - /arcsde/linux/oracle10g_6415 - /arcsde/linux/oracle11g16 - /arcsde/linux/oracle11g_6417 - /arcsde/linux/oracle9i18 - /arcsde/linux/pg/arcsde19 - /arcsde/solaris/db2_6420 - /arcsde/solaris/informix21 - /arcsde/solaris/oracle10g_6422 - /arcsde/solaris/oracle11g_6423 - /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 ProductArcSDE Server这正确吗? [yes]被选中的软件模块共占空间(兆字节): 160.5剩余空间(兆字节): 3052.0安装时列出文件名吗? [no] no正在安装软件, 请等待...软件安装完毕退出...3.3 常见报错日志[arcsde@szdb1 oracle10g_64]$这是在系统缺少包的情况下，出现的报错日志：[arcsde@szdb1 ~]$ sdemon -o startsdemon: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory[root@szdb1 ~]# yum install libg2c.so.0Loaded plugins: rhnplugin, securityThis system is not registered with RHN.RHN support will be disabled.rhel-debuginfo | 1.3 kB 00:00Setting up Install ProcessResolving Dependencies--> Running transaction check---> Package compat-libf2c-34.i386 0:3.4.6-4 set to be updated--> Finished Dependency ResolutionDependencies ResolvedPackage Arch Version RepositorySizeInstalling:compat-libf2c-34 i386 3.4.6-4 rhel-debuginfo52 kTransaction SummaryInstall 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 TransactionInstalling : compat-libf2c-341/1Installed:compat-libf2c-34.i386 0:3.4.6-4Complete![root@szdb1 ~]# 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:00Setting up Install ProcessPackage openmotif22-2.2.3-18.i386 already installed and latest versionNothing to do[root@szdb1 ~]# yum install openmotif22Loaded plugins: rhnplugin, securityThis system is not registered with RHN.RHN support will be disabled.rhel-debuginfo | 1.3 kB 00:00Setting 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 ResolutionDependencies Resolved=================================================================== =============================Package Arch Version Repository Size=================================================================== =============================Installing:openmotif22 x86_64 2.2.3-18 rhel-debuginfo 1.3 MTransaction 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 TransactionInstalling : openmotif221/1Installed:openmotif22.x86_64 0:2.2.3-18Complete!第四章安装sde oracle数据库4.1 安装sde[arcsde@szdb1 bin]$ sdesetup -o install -d ORACLE10G -p sdeSES_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 SDEHOME\etc\sde_setup.log for more details. [arcsde@szdb1 bin]$ export LANG=C ####修改字符显示[arcsde@szdb1 bin]$ sdesetup -o install -d ORACLE10G -p sdeESRI 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 SESSIONCREATE TABLECREATE VIEWCREATE PROCEDURECREATE SEQUENCECREATE TRIGGERCREATE TYPECREATE INDEXTYPECREATE LIBRARYCREATE PUBLIC SYNONYMDROP PUBLIC SYNONYMADMINISTER DATABASE TRIGGERCREATE OPERATORError: Insufficient permissions (-25).####提示权限不够，赋予sde DBA权限；grant dba to sde; Error: SDE release install not completed.Check SDEHOME\etc\sde_setup.log for more details. [arcsde@szdb1 bin]$ sdesetup -o install -d ORACLE10G -p sdeESRI 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 SDEHOME\etc\sde_setup.log for more details.4.2 启动sde服务[arcsde@szdb1 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: 1007Instance 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.[arcsde@szdb1 bin]$ sdesetup -o update_key -d ORACLE10G -l/home/oracle/ma.frank.license.ecp -u sde -p sdeError reading license informationError: (-8027) Text file not found.. #####不注册报错4.3 安装license[arcsde@szdb1 bin]$ sdesetup -o update_key -d ORACLE10G -l/tmp/ma.frank.license.ecp -u sde -p sdeESRI ArcSDE Server Setup Utility Thu Jul 15 17:07:37 2010----------------------------------------------------------------Successfully updated authorization key.4.4 再启动sde服务[arcsde@szdb1 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: 1007Instance initialized for ((sde)) . . .Connected to instance . . .DBMS Connection established...RDBMS: "Oracle"Instance Name: "esri_sde"IOMGR Process ID (PID): 18792完毕！！###################################################################### 以下为noap数据库，ASM磁盘组的管理维护办法，启动noap数据库前，需要先启动+ASM 数据库，否则不能挂载ASM磁盘组。