• linux 安装 ArcSDE10.1


    实验仍未成功,步骤仅供参考。

     

    1:首先检查一下在Linux操作系统下Oracle数据库是否能启动,是否能连通等

    [oracle@localhost ~]$ sqlplus

     

    SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 25 02:17:32 2014

     

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

     

    Enter user-name: sys as sysdba

    Enter password:

     

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    SQL> exit

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    创建操作系统级别的ArcSDE用户

    [oracle@localhost ~]$ su root

    Password:

    [root@localhost oracle]# useradd -d /home/gis -G oinstall -m gis

    [root@localhost oracle]# passwd gis

    Changing password for user gis.

    New password: (jhl123)

    BAD PASSWORD: it is based on a dictionary word

    BAD PASSWORD: is too simple

    Retype new password:

    passwd: all authentication tokens updated successfully.

    [root@localhost oracle]# su gis

    创建SDE的用户、表空间、赋予权限,查看一下相关的SQL文件

    '/home/oracle/app/oradata/orcl/sde.dbf'保证该文件夹存在,系统不会自动创建该文件夹,确保Oracle用户对建立sde.dbf路径的文件夹有读写的权限

     

    prompt * Granting of permissions by the SYS user in Oracle, on two packages
    
    prompt * to the public role.
    
     
    
    grant execute on dbms_pipe to public;
    
    grant execute on dbms_lock to public;
    
     
    
    prompt * * * * * * * * * * * * * * *
    
    prompt * ArcSDE NEW INSTALLATION   *
    
    prompt * * * * * * * * * * * * * * *
    
     
    
    prompt * Connect as system/sys to create the sde  // system用户名密码
    
    prompt * tablespace and user.
    
     
    
    connect sys/sys as sysdba //sys用户名密码
    
     
    
    prompt * Create the sde tablespace.
    
    prompt * Before you run this script update LOCATION for the desired datafile pathname.
    
    //创建SDE表空间,路径需要注意
    
    create tablespace sde
    
    datafile '/home/oracle/app/oradata/orcl/sde.dbf' size 400M
    
    extent management local uniform size 512K;
    
     
    
    prompt * Create the sde user
    
    prompt * The password for the sde user is set to "sde". You may
    
    prompt * change this if you wish.
    
     
    
    create user sde identified by sde
    
    default tablespace sde temporary tablespace temp;
    
     
    
    prompt * Granting the required privileges to the sde user.
    
     
    
    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  CREATE VIEW to sde;
    
    prompt * UNLIMITED TABLESPACE is not required. Grant this privilege
    
    prompt * if you do not wish to explicitly manage and grant tablespace quota to SDE user.
    
    grant  UNLIMITED TABLESPACE to sde;
    
    prompt * ADMINISTER DATABASE TRIGGER can be revoked after install
    
    grant  ADMINISTER DATABASE TRIGGER to sde;
    
     
    
    exit;
    View Code

     

    把以上语句保存为一个createsde.sql的文件,放在/opt目录下,注意目录权限即可,执行

    [oracle@localhost ~]$ sqlplus

     

    SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 25 18:30:23 2014
    
     
    
    Copyright (c) 1982, 2009, Oracle.  All rights reserved.
    
     
    
    Enter user-name: sys as sysdba
    
    Enter password:
    
     
    
    Connected to:
    
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    
     
    
    SQL> @ /opt/createsde.sql
    
    得到以下信息:
    
    * Granting of permissions by the SYS user in Oracle, on two packages
    
    * to the public role.
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
    * * * * * * * * * * * * * * *
    
    * ArcSDE NEW INSTALLATION   *
    
    * * * * * * * * * * * * * * *
    
    * Connect as system/sys to create the sde
    
    * tablespace and user.
    
    Connected.
    
    * Create the sde tablespace.
    
    * Before you run this script update LOCATION for the desired datafile pathname.
    
     
    
    Grant succeeded.
    
     
    
     
    
    Tablespace created.
    
     
    
    * Create the sde user
    
    * The password for the sde user is set to "sde". You may
    
    * change this if you wish.
    
     
    
    User created.
    
     
    
    * Granting the required privileges to the sde user.
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
     
    
    Grant succeeded.
    
     
    
    * UNLIMITED TABLESPACE is not required. Grant this privilege
    
    * if you do not wish to explicitly manage and grant tablespace quota to SDE user.
    
     
    
    Grant succeeded.
    
     
    
    * ADMINISTER DATABASE TRIGGER can be revoked after install
    
     
    
    Grant succeeded.
    
     
    
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    
    With the Partitioning, OLAP, Data Mining and Real Application Testing options
    View Code

    测试sde用户是否可以连通

    [oracle@localhost ~]$ sqlplus

     

    SQL*Plus: Release 11.2.0.1.0 Production on Tue Mar 25 18:53:43 2014

     

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

     

    Enter user-name: sde

    Enter password: (sde)

     

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    安装ArcSDE

    Sde安装文件路径/opt/sde

    进入/opt/sde/linux/oracle11g_64,找到install文件 linux 安装 ArcSDE10.1(1) - 海龙 - 海龙的博客

     ,右键properties,修改下权限Permissions,勾选Allow executing file as program.

    linux 安装 ArcSDE10.1(1) - 海龙 - 海龙的博客

     

    输入命令如下:

    [root@localhost sde]# cd /opt/sde/linux/oracle11g_64

    [root@localhost oracle11g_64]# ./install –load

     

    [root@localhost oracle11g_64]# ./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 <return> or type 'no' to exit installation process. [no] yes

     

     

    Press <return> to take the default, '?' for help, '^' to return to

    the previous question, or 'q' to quit.

     

    Enter media mount point: [/mediamnt] /opt/sde

     

    Select which product to load by entering the product number.

     

       1 - /opt/sde/hpia/commands_64

       2 - /opt/sde/hpia/oracle10g_64

       3 - /opt/sde/hpia/oracle11g_64

       4 - /opt/sde/ibm/commands_64

       5 - /opt/sde/ibm/db2_64

       6 - /opt/sde/ibm/informix_64

       7 - /opt/sde/ibm/oracle10g_64

       8 - /opt/sde/ibm/oracle11g_64

       9 - /opt/sde/linux/commands_64

      10 - /opt/sde/linux/db2_64

      11 - /opt/sde/linux/informix_64

      12 - /opt/sde/linux/oracle10g_64

      13 - /opt/sde/linux/oracle11g_64

      14 - /opt/sde/linux/pg_64

      15 - /opt/sde/solaris/commands_64

      16 - /opt/sde/solaris/db2_64

      17 - /opt/sde/solaris/informix_64

      18 - /opt/sde/solaris/oracle10g_64

      19 - /opt/sde/solaris/oracle11g_64

     

    Enter product number to load: [1] 13

    Enter pathname to install directory: [/opt/sde/linux/oracle11g_64] /home/gis   //sde用户目录

     

    ArcSDE version 10.1 for Oracle11g - Apr 5, 2012 

    -------------------------------------------------

     

    Choices are:

     

     

       1 Application Server                                   

       2 Command Line Tools                                   

    Package numbers to load: [all] all

     

     

    Package selection complete

    --------------------------

     

    You have chosen the following packages to be loaded

     

    ArcSDE Product

             Application Server                                   

             Command Line Tools                                   

     

    Is this correct? [yes] yes

    Total size of chosen packages in megabytes: 262.6

    Available space in megabytes: 19732.0

     

    List file names while loading? [no] yes

    Loading package(s), Please wait...

    sdeexe101/bin/giomgr
    
    sdeexe101/bin/gsrvr
    
    sdeexe101/bin/sdemon
    
    sdeexe101/bin/sderemote
    
    sdeexe101/etc/dbinit.sde
    
    sdeexe101/etc/dbtune.sde
    
    sdeexe101/etc/services.sde
    
    sdeexe101/lib/libicudata.so
    
    sdeexe101/lib/libicudata.so.44
    
    sdeexe101/lib/libicudata.so.44.2
    
    sdeexe101/lib/libicuuc.so
    
    sdeexe101/lib/libicuuc.so.44
    
    sdeexe101/lib/libicuuc.so.44.2
    
    sdeexe101/lib/libicui18n.so
    
    sdeexe101/lib/libicui18n.so.44
    
    sdeexe101/lib/libicui18n.so.44.2
    
    sdeexe101/lib/libxerces-c.so
    
    sdeexe101/lib/libxerces-c-3.1.so
    
    sdeexe101/lib/libtiff.so
    
    sdeexe101/lib/libpe.so
    
    sdeexe101/lib/libsg.so
    
    sdeexe101/lib/libsde.so
    
    sdeexe101/lib/libsdeora11gsrvr101.so
    
    sdeexe101/lib/libgsrvrora11g101.so
    
    Documentation/
    
    Documentation/Admin_Cmd_Ref/
    
    Documentation/Admin_Cmd_Ref/admincmdref.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/
    
    Documentation/Admin_Cmd_Ref/Support_files/admincmd94.log
    
    Documentation/Admin_Cmd_Ref/Support_files/admincmdref.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/admincmdref_csh.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/admincmdref_rhc.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/connections.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/cshdat_robohelp.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/cshdat_webhelp.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/ehelp.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/ehlpdhtm.js
    
    Documentation/Admin_Cmd_Ref/Support_files/envvar.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/help.css
    
    Documentation/Admin_Cmd_Ref/Support_files/help_ns.css
    
    Documentation/Admin_Cmd_Ref/Support_files/robohhre.lng
    
    Documentation/Admin_Cmd_Ref/Support_files/syntax.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/webhelp.cab
    
    Documentation/Admin_Cmd_Ref/Support_files/webhelp.jar
    
    Documentation/Admin_Cmd_Ref/Support_files/welcome.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whcshdata.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whcsh_home.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whestart.ico
    
    Documentation/Admin_Cmd_Ref/Support_files/whfbody.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whfdhtml.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whfform.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whfhost.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whform.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whframes.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whgbody.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdef.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdhtml.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whghost.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whhost.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whibody.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whidhtml.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whiform.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whihost.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whlang.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whmozemu.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whmsg.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whnjs.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whphost.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whproj.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whproj.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whproj.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whproxy.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whres.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whrstart.ico
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_banner.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_blank.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_frmset01.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_frmset010.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_homepage.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_info.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_mbars.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_papplet.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_pdhtml.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_pickup.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_plist.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_tbars.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whskin_tw.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whstart.ico
    
    Documentation/Admin_Cmd_Ref/Support_files/whstart.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whstub.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whst_topics.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whtbar.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whtdhtml.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whthost.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whtopic.js
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_abge.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_abgi.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_abgw.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_abte.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_abti.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_abtw.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_fts_h.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_fts_n.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_glo_h.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_glo_n.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_go.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_hide.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_idx_h.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_idx_n.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_logo1.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_logo2.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_next.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_next_g.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_prev.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_prev_g.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_spac.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_sync.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab0.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab1.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab2.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab3.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab4.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab5.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab6.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab7.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_tab8.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_toc1.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_toc2.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_toc3.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_toc4.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_toc_h.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_toc_n.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_ws.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/wht_ws_g.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/whutils.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whver.js
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/cov2sde.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sde2cov.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sde2shp.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sde2tbl.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdeexport.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdegroup.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdeimport.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdelayer.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sderaster.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdetable.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdeversion.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdexinfo.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/sdexml.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/shp2sde.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/shpinfo.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/tbl2sde.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/images/
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/images/arrow_bullet.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/images/header.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/datamgmt/images/sparse_grid.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/images/
    
    Documentation/Admin_Cmd_Ref/Support_files/images/arrow_bullet.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/images/FullExtent16.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/images/header.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdeconfig.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdedbtune.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdegdbrepair.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdelog.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdemon.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdeservice.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdesetup.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/images/
    
    Documentation/Admin_Cmd_Ref/Support_files/serveradmin/images/header.jpg
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whftdata.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whftdata0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whfts.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whfts.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whfwdata.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whfwdata0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whgdata.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whglo.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whglo.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whidata.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whidx.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whidx.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whtdata.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whtdata0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whtoc.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whdata/whtoc.js
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whexpbar.gif
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf1.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf10.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf11.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf12.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf13.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf14.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf15.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf16.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf17.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf18.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf19.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf2.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf20.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf21.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf22.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf23.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf24.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf3.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf4.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf5.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf6.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf7.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf8.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf9.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl1.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl10.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl11.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl12.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl13.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl14.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl15.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl16.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl17.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl18.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl19.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl2.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl20.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl21.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl22.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl23.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl24.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl25.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl26.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl3.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl4.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl5.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl6.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl7.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl8.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl9.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstg0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlsti0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstt0.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstt1.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whlstt2.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf30.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf31.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf32.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf33.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvl31.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvl32.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvl33.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp30.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp31.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp32.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp33.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt30.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt31.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt32.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt33.htm
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whftdata0.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whfts.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whfwdata0.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whglo.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whidx.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whtdata0.xml
    
    Documentation/Admin_Cmd_Ref/Support_files/whxdata/whtoc.xml
    
    sdeexe101/locale/
    
    sdeexe101/locale/msg/
    
    sdeexe101/locale/msg/default/
    
    sdeexe101/locale/msg/default/error.msg
    
    sdeexe101/locale/codepage/
    
    sdeexe101/locale/codepage/88591.txt
    
    sdeexe101/locale/codepage/88592.txt
    
    sdeexe101/locale/codepage/88593.txt
    
    sdeexe101/locale/codepage/88594.txt
    
    sdeexe101/locale/codepage/88595.txt
    
    sdeexe101/locale/codepage/88596.txt
    
    sdeexe101/locale/codepage/88597.txt
    
    sdeexe101/locale/codepage/88598.txt
    
    sdeexe101/locale/codepage/88599.txt
    
    sdeexe101/locale/codepage/885913.txt
    
    sdeexe101/locale/codepage/codepage.txt
    
    sdeexe101/locale/codepage/dbase.txt
    
    sdeexe101/locale/codepage/437.txt
    
    sdeexe101/locale/codepage/708.txt
    
    sdeexe101/locale/codepage/720.txt
    
    sdeexe101/locale/codepage/737.txt
    
    sdeexe101/locale/codepage/775.txt
    
    sdeexe101/locale/codepage/850.txt
    
    sdeexe101/locale/codepage/852.txt
    
    sdeexe101/locale/codepage/855.txt
    
    sdeexe101/locale/codepage/857.txt
    
    sdeexe101/locale/codepage/860.txt
    
    sdeexe101/locale/codepage/861.txt
    
    sdeexe101/locale/codepage/862.txt
    
    sdeexe101/locale/codepage/863.txt
    
    sdeexe101/locale/codepage/864.txt
    
    sdeexe101/locale/codepage/865.txt
    
    sdeexe101/locale/codepage/866.txt
    
    sdeexe101/locale/codepage/869.txt
    
    sdeexe101/locale/codepage/1250.txt
    
    sdeexe101/locale/codepage/1251.txt
    
    sdeexe101/locale/codepage/1252.txt
    
    sdeexe101/locale/codepage/1253.txt
    
    sdeexe101/locale/codepage/1254.txt
    
    sdeexe101/locale/codepage/1255.txt
    
    sdeexe101/locale/codepage/1256.txt
    
    sdeexe101/locale/codepage/1257.txt
    
    sdeexe101/locale/codepage/1258.txt
    
    sdeexe101/locale/codepage/885910.txt
    
    sdeexe101/locale/codepage/885915.txt
    
    sdeexe101/bin/sde2shp
    
    sdeexe101/bin/sde2tbl
    
    sdeexe101/bin/sdeconfig
    
    sdeexe101/bin/sdedbtune
    
    sdeexe101/bin/sdeexport
    
    sdeexe101/bin/sdegdbrepair
    
    sdeexe101/bin/sdegroup
    
    sdeexe101/bin/sdeimport
    
    sdeexe101/bin/sdelayer
    
    sdeexe101/bin/sdelog
    
    sdeexe101/bin/sdemon
    
    sdeexe101/bin/sderaster
    
    sdeexe101/bin/sdesetup
    
    sdeexe101/bin/sdetable
    
    sdeexe101/bin/sdeversion
    
    sdeexe101/bin/sdexinfo
    
    sdeexe101/bin/sdexml
    
    sdeexe101/bin/setup_st_geometry
    
    sdeexe101/bin/shp2sde
    
    sdeexe101/bin/shpinfo
    
    sdeexe101/bin/tbl2sde
    
    sdeexe101/etc/dbinit.sde
    
    sdeexe101/etc/dbtune.sde
    
    sdeexe101/etc/services.sde
    
    sdeexe101/etc/gcspcs.cref
    
    sdeexe101/lib/archive_util.sps
    
    sdeexe101/lib/archive_util.spb
    
    sdeexe101/lib/layer_stats_util.sps
    
    sdeexe101/lib/layer_stats_util.spb
    
    sdeexe101/lib/sde_util.sps
    
    sdeexe101/lib/sde_util.spb
    
    sdeexe101/lib/svr_config_util.sps
    
    sdeexe101/lib/version_util.sps
    
    sdeexe101/lib/svr_config_util.spb
    
    sdeexe101/lib/version_util.spb
    
    sdeexe101/lib/layers_util.sps
    
    sdeexe101/lib/layers_util.spb
    
    sdeexe101/lib/rastercolumns_util.sps
    
    sdeexe101/lib/rastercolumns_util.spb
    
    sdeexe101/lib/metadata_util.sps
    
    sdeexe101/lib/metadata_util.spb
    
    sdeexe101/lib/registry_util.sps
    
    sdeexe101/lib/registry_util.spb
    
    sdeexe101/lib/sref_util.sps
    
    sdeexe101/lib/sref_util.spb
    
    sdeexe101/lib/locator_util.sps
    
    sdeexe101/lib/locator_util.spb
    
    sdeexe101/lib/pinfo_util.sps
    
    sdeexe101/lib/pinfo_util.spb
    
    sdeexe101/lib/lock_util.sps
    
    sdeexe101/lib/lock_util.spb
    
    sdeexe101/lib/dbtune_util.sps
    
    sdeexe101/lib/dbtune_util.spb
    
    sdeexe101/lib/version_user_ddl.sps
    
    sdeexe101/lib/version_user_ddl.spb
    
    sdeexe101/lib/sdo_util.sps
    
    sdeexe101/lib/sdo_util.spb
    
    sdeexe101/lib/xml_util.sps
    
    sdeexe101/lib/xml_util.spb
    
    sdeexe101/lib/logfile_util.sps
    
    sdeexe101/lib/logfile_util.spb
    
    sdeexe101/lib/instances_util.sps
    
    sdeexe101/lib/instances_util.spb
    
    sdeexe101/lib/st_domain_methods.stb
    
    sdeexe101/lib/st_domain_methods_10g.stb
    
    sdeexe101/lib/st_domain_methods.sts
    
    sdeexe101/lib/st_domain_operators.spb
    
    sdeexe101/lib/st_domain_operators.sps
    
    sdeexe101/lib/st_domain_stats.stb
    
    sdeexe101/lib/st_domain_stats.sts
    
    sdeexe101/lib/st_geom_util.spb
    
    sdeexe101/lib/st_geom_util.sps
    
    sdeexe101/lib/st_geometry.stb
    
    sdeexe101/lib/st_geometry.sts
    
    sdeexe101/lib/keyset_util.sps
    
    sdeexe101/lib/keyset_util.spb
    
    sdeexe101/lib/st_geometry_shapelib_pkg.sps
    
    sdeexe101/lib/st_geometry_shapelib_pkg.spb
    
    sdeexe101/lib/spx_util.spb
    
    sdeexe101/lib/spx_util_10g.spb
    
    sdeexe101/lib/spx_util.sps
    
    sdeexe101/lib/spx_util_10g.sps
    
    sdeexe101/lib/st_geom_cols_util.spb
    
    sdeexe101/lib/st_geom_cols_util.sps
    
    sdeexe101/lib/st_geometry_operators.spb
    
    sdeexe101/lib/st_geometry_operators.sps
    
    sdeexe101/lib/st_geomfromtext.stb
    
    sdeexe101/lib/st_geomfromtext.sts
    
    sdeexe101/lib/st_linestring.stb
    
    sdeexe101/lib/st_linestring.sts
    
    sdeexe101/lib/st_multilinestring.stb
    
    sdeexe101/lib/st_multilinestring.sts
    
    sdeexe101/lib/st_multipoint.stb
    
    sdeexe101/lib/st_multipoint.sts
    
    sdeexe101/lib/st_multipolygon.stb
    
    sdeexe101/lib/st_multipolygon.sts
    
    sdeexe101/lib/st_point.stb
    
    sdeexe101/lib/st_point.sts
    
    sdeexe101/lib/st_polygon.stb
    
    sdeexe101/lib/st_polygon.sts
    
    sdeexe101/lib/st_relation_operators.spb
    
    sdeexe101/lib/st_relation_operators.sps
    
    sdeexe101/lib/st_spref_util.spb
    
    sdeexe101/lib/st_spref_util.sps
    
    sdeexe101/lib/st_type_user.spb
    
    sdeexe101/lib/st_type_user.sps
    
    sdeexe101/lib/st_type_util.spb
    
    sdeexe101/lib/st_type_util.sps
    
    sdeexe101/lib/st_cref_util.spb
    
    sdeexe101/lib/st_cref_util.sps
    
    sdeexe101/lib/st_curve.stb
    
    sdeexe101/lib/st_curve.sts
    
    sdeexe101/lib/st_geomcollection.stb
    
    sdeexe101/lib/st_geomcollection.sts
    
    sdeexe101/lib/st_linefromtext.stb
    
    sdeexe101/lib/st_linefromtext.sts
    
    sdeexe101/lib/st_mlinefromtext.stb
    
    sdeexe101/lib/st_mlinefromtext.sts
    
    sdeexe101/lib/st_mpointfromtext.stb
    
    sdeexe101/lib/st_mpointfromtext.sts
    
    sdeexe101/lib/st_mpolyfromtext.stb
    
    sdeexe101/lib/st_mpolyfromtext.sts
    
    sdeexe101/lib/st_multicurve.stb
    
    sdeexe101/lib/st_multicurve.sts
    
    sdeexe101/lib/st_multisurface.stb
    
    sdeexe101/lib/st_multisurface.sts
    
    sdeexe101/lib/st_pointfromtext.stb
    
    sdeexe101/lib/st_pointfromtext.sts
    
    sdeexe101/lib/st_polyfromtext.stb
    
    sdeexe101/lib/st_polyfromtext.sts
    
    sdeexe101/lib/st_surface.stb
    
    sdeexe101/lib/st_surface.sts
    
    sdeexe101/lib/st_type_export.spb
    
    sdeexe101/lib/st_type_export.sps
    
    sdeexe101/lib/gdb_util.spb
    
    sdeexe101/lib/gdb_util.sps
    
    sdeexe101/lib/st_pixeldata.wts
    
    sdeexe101/lib/st_pixeldata.wtb
    
    sdeexe101/lib/st_raster.wts
    
    sdeexe101/lib/st_raster.wtb
    
    sdeexe101/lib/st_raster_util.wps
    
    sdeexe101/lib/st_raster_util.wpb
    
    sdeexe101/lib/libicudata.so
    
    sdeexe101/lib/libicudata.so.44
    
    sdeexe101/lib/libicudata.so.44.2
    
    sdeexe101/lib/libicuuc.so
    
    sdeexe101/lib/libicuuc.so.44
    
    sdeexe101/lib/libicuuc.so.44.2
    
    sdeexe101/lib/libicui18n.so
    
    sdeexe101/lib/libicui18n.so.44
    
    sdeexe101/lib/libicui18n.so.44.2
    
    sdeexe101/lib/libxerces-c.so
    
    sdeexe101/lib/libxerces-c-3.1.so
    
    sdeexe101/lib/libtiff.so
    
    sdeexe101/lib/libpe.so
    
    sdeexe101/lib/libsg.so
    
    sdeexe101/lib/libsde.so
    
    sdeexe101/lib/libsdeora11gsrvr101.so
    
    sdeexe101/lib/libgsrvrora11g101.so
    
    sdeexe101/lib/libsdesetup.so
    
    sdeexe101/lib/libst_shapelib.so
    
    sdeexe101/lib/libst_raster_ora.so
    
     
    
    Finished loading package(s)
    
     
    
    Exiting...
    View Code

    根据用户软件安装的位置以及Oracle软件安装的信息,添加sde用户的环境变量

    [gis@localhost ~]$ vi .bash_profile

    i进行编辑,原有的PATH=$PATH:$HOME/bin    export PATH行前加#注释。加入下面红色部分。

    # .bash_profile

     

    # Get the aliases and functions

    if [ -f ~/.bashrc ]; then

            . ~/.bashrc

    fi

     

    # User specific environment and startup programs

     

    #PATH=$PATH:$HOME/bin

    export ORACLE_BASE=/home/oracle/app/oracle

    export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

    export ORACLE_SID=orcl

    export TNS_ADMIN=$ORACLE_HOME/network/admin

    export SDEHOME=/home/gis/sdeexe101

    export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib

    export PATH=$PATH:$HOME:$ORACLE_HOME/bin:$SDEHOME/bin

     

    #export PATH

    ~                                                                              

    ~         /home/oracle/app/oracle/product/11.2.0/dbhome_1/lib                                                                      

    ~                                                                              

    ~    

    输入:wq进行保存。

     

    修改完毕环境变量,使之生效,然后测试一下是否生效

    [gis@localhost ~]$ . ./.bash_profile

    [gis@localhost ~]$ echo $SDEHOME

    /home/gis/sdeexe101

    [gis@localhost ~]$ cd $SDEHOME

    [gis@localhost sdeexe101]$ pwd

    /home/gis/sdeexe101

    [gis@localhost sdeexe101]$

    修改配置文件参数,在ArcSDE用户下修改$SDEHOME/etc/services.sde文件添加实例名和端口号

     

    [gis@localhost ~]$ cd /home/gis/sdeexe101/etc

    [gis@localhost etc]$ vi services.sde

     

    i进行编辑,把#esri_sde               5151/tcp这行前#去掉即可, 输入:wq保存

     

    Root用户下/etc/services文件一样添加

     

    修改gis目录权限

    [gis@localhost etc]$ su root

    Password:

    [root@localhost etc]# chown -R gis:oinstall /home/gis

    [root@localhost etc]# chmod -R 755 /home/gis

    [root@localhost etc]# su gis

    [gis@localhost etc]$ cd $SDEHOME

    [gis@localhost sdeexe101]$ ll

    total 16

    drwxr-xr-x. 2 gis oinstall 4096 Mar 25 19:10 bin

    drwxr-xr-x. 2 gis oinstall 4096 Mar 25 19:29 etc

    drwxr-xr-x. 2 gis oinstall 4096 Mar 25 19:10 lib

    drwxr-xr-x. 4 gis oinstall 4096 May 20  2010 locale

     

    sdesetup

     

    [gis@localhost ~]$ sdesetup

     

    ArcSDE 10.1 Setup

    Setup        Administration Utility

    -----------------------------------------------------

     

     

    Usage for sdesetup:

     

    -?

    -h

     

    -o delete    -d {ORACLE10G|ORACLE11G}

                [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]

                [-i <master_geodatabase_service>[:<user_schema>]] [-N] [q]

    -o list      -d {ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL}

                [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]

                [-D <database>] [-s <datasource>]

                [-i <master_geodatabase_service>[:<user_schema>]] [-q]

    -o update_key

                 -d {ORACLE10G|ORACLE11G|SQLSERVER| DB2|DB2ZOS|INFORMIX|POSTGRESQL}

                 -l <key> [-u <DB_Admin_user>] [-p <DB_Admin_password>]

                [-H <sde_directory>] [-D <database>] [-s <datasource>] [-N]

                [-i <master_geodatabase_service>[:<user_schema>]] [-q]

    -o install_st_raster

                 -d {ORACLE10G|ORACLE11G|SQLSERVER|POSTGRESQL}

                [-H <sde_directory>] [-u <DB_Admin_user>] [-p <DB_Admin_password>]

                [-D <database>] [-s <datasource>] [-N] [-l <key>] [-q]

     

    创建SDE的Schema

    [gis@localhost lib]$ sdesetup -o install_st_raster -d oracle11g -p sde

     

    ESRI ArcSDE Server Setup Utility Tue Mar 25 22:59:38 2014

    ----------------------------------------------------------------

    Install or update ST_RASTER schema objects: Are you sure? (Y/N): y

    Creating ST_RASTER schema...

    Successfully created ST_RASTER schema.

     

     

    Successfully installed ArcSDE components.

    Refer SDEHOMEetcsde_setup.log for more details.

     

    估计会遇到的错误类型:Error: Underlying DBMS error (-51).

    这个问题一般是数据库权限问题,将以下sql语句保存为updatesde.sql执行即可

    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 VIEW to sde;

    prompt * SELECT ANY TABLE is required for compressing the database

    prompt * This privilege needs to be granted whenever a compress is run.

    grant  SELECT ANY TABLE to sde;

    prompt * ADMINISTER DATABASE TRIGGER can be revoked after install

    grant  ADMINISTER DATABASE TRIGGER to sde;

     

    prompt * * * * * * * * * * *

    prompt * ArcSDE UPGRADE    *

    prompt * * * * * * * * * * *

     

    prompt * If upgrading please remove rem from each grant.

    prompt * Granting the required privileges to the sde user.

     

    REM grant  ADMINISTER DATABASE TRIGGER to sde;

    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;

     

     

    更新相关的lic,注意lic文件的所属用户,所属组以及读写权限

    [gis@localhost ~]$ sdesetup -o update_key -d oracle11g -l /opt/sde/sde.ecp -p sde

     

    ESRI ArcSDE Server Setup Utility Wed Mar 26 02:37:39 2014

    ----------------------------------------------------------------

    Error: DBMS table not found (-37).

    Error upgrading authorization key.

    出错,需要在oracle用户下执行

    grant execute on dbms_pipe to public;  
    grant execute on dbms_lock to public;

     

    [gis@localhost ~]$ su oracle

    Password:

    [oracle@localhost gis]$ sqlplus

     

    SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 26 19:36:17 2014

     

    Copyright (c) 1982, 2009, Oracle.  All rights reserved.

     

    Enter user-name: sys as sysdba

    Enter password:

     

    Connected to:

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    SQL> grant execute on dbms_pipe to public; 

    grant execute on dbms_lock to public;

    Grant succeeded.

     

    SQL>

     

    Grant succeeded.

     

    SQL> exit

    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

    With the Partitioning, OLAP, Data Mining and Real Application Testing options

     

    [oracle@localhost gis]$ su gis

    Password:

    [gis@localhost ~]$ sdesetup -o update_key -d oracle11g -l /opt/sde/sde.ecp -p sde

    sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory

     

    再次出错。

     

     

     

    启动ArcSDE服务

    [gis@localhost ~]$ sdemon -o start -p sde

     

     

    -------------------------------------------------------

    ArcSDE 10.1  for Oracle11g Build 679 Thu Apr  5 11:43:21  2012

    -------------------------------------------------------

     

     

    ST_Geometry Schema Owner: () Type Release: 0

     

    Instance initialized for ((sde)) . . .

     

     

    Connected to instance . . .

     

    Previous SDE Server Release 0.0.0 is not compatible with the current Release 10.1.0.

     

     

    Could not start ArcSDE -- Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.

     

     

    补充:如果要设置随着机器自动启动,那么创建sde.sh文件,加入下面的内容:

    #!/bin/sh
    
    #
    
    SDEHOME=/home/sde/sdeexe93
    
    SDE_OWNR=sde
    
    ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
    
    #
    
    #
    
    if [ ! -d $SDEHOME ] || [ ! -f $SDEHOME/bin/sdemon ]
    
    then
    
    echo "ArcSDE startup: cannot start"
    
    exit 1
    
    fi
    
    #
    
    case "$1" in
    
    start)
    
    #ArcSDE startup
    
    echo -n "Starting ArcSDE: "
    
    su $SDE_OWNR -c " export SDEHOME=/home/sde/sdeexe93&&
    
    export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1&&
    
    export ORACLE_SID=pgis1&&
    
    export PATH=$PATH:$SDEHOME/bin:$ORACLE_HOME/bin:/etc&&
    
    export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib32&&
    
    export NLS_.ZHS16GBK&&
    
    $SDEHOME/bin/sdemon -o start -p sde"
    
    touch /var/lock/sde
    
    echo "OK, Started"
    
    ;;
    
    stop)
    
    #ArcSDE shutdown
    
    echo -n "Shutdown ArcSDE: "
    
    su $SDE_OWNR -c " export SDEHOME=/home/sde/sdeexe93&&
    
    export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1&&
    
    export ORACLE_SID=pgis1&&
    
    export PATH=$PATH:$SDEHOME/bin:$ORACLE_HOME/bin:/etc&&
    
    export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib32&&
    
    export NLS_.ZHS16GBK&&
    
     
    
    $SDEHOME/bin/sdemon -o shutdown -p sde"
    
    rm -f /var/lock/sde
    
    echo "OK, Stopped"
    
    ;;
    
    restart)
    
    $0 stop
    
    $0 start
    
    ;;
    
    *)
    
    echo "Usage: $0 start|stop|restart"
    
    exit 1
    
    ;;
    
    esac
    
    exit 0

    然后:

     chmod 755 sde.sh

     sudo cp sde.sh /etc/init.d/

     sudo update-rc.d sde.sh defaults 99

     就可以了。

  • 相关阅读:
    git 账号密码
    sql server 备份
    计算经纬度的两点之间的距离
    redis 安装
    webapi 可空参数
    Asp.Net MVC4 使用Unity 实现依赖注入
    sublime主题推荐
    分解质数因子
    如何在sublime+chrome中调试php代码?
    php的mysql语句里变量加不加单引号问题
  • 原文地址:https://www.cnblogs.com/jhlong/p/5442484.html
Copyright © 2020-2023  润新知