实验仍未成功,步骤仅供参考。
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 packagesprompt * 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 sdedatafile '/home/oracle/app/oradata/orcl/sde.dbf' size 400Mextent management local uniform size 512K; prompt * Create the sde userprompt * The password for the sde user is set to "sde". You mayprompt * change this if you wish. create user sde identified by sdedefault 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 privilegeprompt * 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 installgrant ADMINISTER DATABASE TRIGGER to sde; exit;
把以上语句保存为一个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 sysdbaEnter password: Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith 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 ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
测试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文件
,右键properties,修改下权限Permissions,勾选Allow executing file as program.
输入命令如下:
[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/giomgrsdeexe101/bin/gsrvrsdeexe101/bin/sdemonsdeexe101/bin/sderemotesdeexe101/etc/dbinit.sdesdeexe101/etc/dbtune.sdesdeexe101/etc/services.sdesdeexe101/lib/libicudata.sosdeexe101/lib/libicudata.so.44sdeexe101/lib/libicudata.so.44.2sdeexe101/lib/libicuuc.sosdeexe101/lib/libicuuc.so.44sdeexe101/lib/libicuuc.so.44.2sdeexe101/lib/libicui18n.sosdeexe101/lib/libicui18n.so.44sdeexe101/lib/libicui18n.so.44.2sdeexe101/lib/libxerces-c.sosdeexe101/lib/libxerces-c-3.1.sosdeexe101/lib/libtiff.sosdeexe101/lib/libpe.sosdeexe101/lib/libsg.sosdeexe101/lib/libsde.sosdeexe101/lib/libsdeora11gsrvr101.sosdeexe101/lib/libgsrvrora11g101.soDocumentation/Documentation/Admin_Cmd_Ref/Documentation/Admin_Cmd_Ref/admincmdref.htmDocumentation/Admin_Cmd_Ref/Support_files/Documentation/Admin_Cmd_Ref/Support_files/admincmd94.logDocumentation/Admin_Cmd_Ref/Support_files/admincmdref.htmDocumentation/Admin_Cmd_Ref/Support_files/admincmdref_csh.htmDocumentation/Admin_Cmd_Ref/Support_files/admincmdref_rhc.htmDocumentation/Admin_Cmd_Ref/Support_files/connections.htmDocumentation/Admin_Cmd_Ref/Support_files/cshdat_robohelp.htmDocumentation/Admin_Cmd_Ref/Support_files/cshdat_webhelp.htmDocumentation/Admin_Cmd_Ref/Support_files/ehelp.xmlDocumentation/Admin_Cmd_Ref/Support_files/ehlpdhtm.jsDocumentation/Admin_Cmd_Ref/Support_files/envvar.htmDocumentation/Admin_Cmd_Ref/Support_files/help.cssDocumentation/Admin_Cmd_Ref/Support_files/help_ns.cssDocumentation/Admin_Cmd_Ref/Support_files/robohhre.lngDocumentation/Admin_Cmd_Ref/Support_files/syntax.htmDocumentation/Admin_Cmd_Ref/Support_files/webhelp.cabDocumentation/Admin_Cmd_Ref/Support_files/webhelp.jarDocumentation/Admin_Cmd_Ref/Support_files/welcome.htmDocumentation/Admin_Cmd_Ref/Support_files/whcshdata.htmDocumentation/Admin_Cmd_Ref/Support_files/whcsh_home.htmDocumentation/Admin_Cmd_Ref/Support_files/whestart.icoDocumentation/Admin_Cmd_Ref/Support_files/whfbody.htmDocumentation/Admin_Cmd_Ref/Support_files/whfdhtml.htmDocumentation/Admin_Cmd_Ref/Support_files/whfform.htmDocumentation/Admin_Cmd_Ref/Support_files/whfhost.jsDocumentation/Admin_Cmd_Ref/Support_files/whform.jsDocumentation/Admin_Cmd_Ref/Support_files/whframes.jsDocumentation/Admin_Cmd_Ref/Support_files/whgbody.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdef.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdhtml.htmDocumentation/Admin_Cmd_Ref/Support_files/whghost.jsDocumentation/Admin_Cmd_Ref/Support_files/whhost.jsDocumentation/Admin_Cmd_Ref/Support_files/whibody.htmDocumentation/Admin_Cmd_Ref/Support_files/whidhtml.htmDocumentation/Admin_Cmd_Ref/Support_files/whiform.htmDocumentation/Admin_Cmd_Ref/Support_files/whihost.jsDocumentation/Admin_Cmd_Ref/Support_files/whlang.jsDocumentation/Admin_Cmd_Ref/Support_files/whmozemu.jsDocumentation/Admin_Cmd_Ref/Support_files/whmsg.jsDocumentation/Admin_Cmd_Ref/Support_files/whnjs.htmDocumentation/Admin_Cmd_Ref/Support_files/whphost.jsDocumentation/Admin_Cmd_Ref/Support_files/whproj.htmDocumentation/Admin_Cmd_Ref/Support_files/whproj.jsDocumentation/Admin_Cmd_Ref/Support_files/whproj.xmlDocumentation/Admin_Cmd_Ref/Support_files/whproxy.jsDocumentation/Admin_Cmd_Ref/Support_files/whres.xmlDocumentation/Admin_Cmd_Ref/Support_files/whrstart.icoDocumentation/Admin_Cmd_Ref/Support_files/whskin_banner.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_blank.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_frmset01.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_frmset010.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_homepage.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_info.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_mbars.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_papplet.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_pdhtml.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_pickup.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_plist.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_tbars.htmDocumentation/Admin_Cmd_Ref/Support_files/whskin_tw.htmDocumentation/Admin_Cmd_Ref/Support_files/whstart.icoDocumentation/Admin_Cmd_Ref/Support_files/whstart.jsDocumentation/Admin_Cmd_Ref/Support_files/whstub.jsDocumentation/Admin_Cmd_Ref/Support_files/whst_topics.xmlDocumentation/Admin_Cmd_Ref/Support_files/whtbar.jsDocumentation/Admin_Cmd_Ref/Support_files/whtdhtml.htmDocumentation/Admin_Cmd_Ref/Support_files/whthost.jsDocumentation/Admin_Cmd_Ref/Support_files/whtopic.jsDocumentation/Admin_Cmd_Ref/Support_files/wht_abge.jpgDocumentation/Admin_Cmd_Ref/Support_files/wht_abgi.jpgDocumentation/Admin_Cmd_Ref/Support_files/wht_abgw.jpgDocumentation/Admin_Cmd_Ref/Support_files/wht_abte.jpgDocumentation/Admin_Cmd_Ref/Support_files/wht_abti.jpgDocumentation/Admin_Cmd_Ref/Support_files/wht_abtw.jpgDocumentation/Admin_Cmd_Ref/Support_files/wht_fts_h.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_fts_n.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_glo_h.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_glo_n.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_go.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_hide.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_idx_h.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_idx_n.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_logo1.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_logo2.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_next.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_next_g.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_prev.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_prev_g.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_spac.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_sync.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab0.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab1.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab2.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab3.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab4.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab5.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab6.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab7.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_tab8.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_toc1.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_toc2.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_toc3.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_toc4.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_toc_h.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_toc_n.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_ws.gifDocumentation/Admin_Cmd_Ref/Support_files/wht_ws_g.gifDocumentation/Admin_Cmd_Ref/Support_files/whutils.jsDocumentation/Admin_Cmd_Ref/Support_files/whver.jsDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/Documentation/Admin_Cmd_Ref/Support_files/datamgmt/cov2sde.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sde2cov.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sde2shp.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sde2tbl.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdeexport.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdegroup.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdeimport.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdelayer.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sderaster.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdetable.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdeversion.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdexinfo.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/sdexml.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/shp2sde.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/shpinfo.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/tbl2sde.htmDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/images/Documentation/Admin_Cmd_Ref/Support_files/datamgmt/images/arrow_bullet.jpgDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/images/header.jpgDocumentation/Admin_Cmd_Ref/Support_files/datamgmt/images/sparse_grid.jpgDocumentation/Admin_Cmd_Ref/Support_files/images/Documentation/Admin_Cmd_Ref/Support_files/images/arrow_bullet.jpgDocumentation/Admin_Cmd_Ref/Support_files/images/FullExtent16.jpgDocumentation/Admin_Cmd_Ref/Support_files/images/header.jpgDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/Documentation/Admin_Cmd_Ref/Support_files/serveradmin/sdeconfig.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/sdedbtune.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/sdegdbrepair.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/sdelog.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/sdemon.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/sdeservice.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/sdesetup.htmDocumentation/Admin_Cmd_Ref/Support_files/serveradmin/images/Documentation/Admin_Cmd_Ref/Support_files/serveradmin/images/header.jpgDocumentation/Admin_Cmd_Ref/Support_files/whdata/Documentation/Admin_Cmd_Ref/Support_files/whdata/whftdata.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whftdata0.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whfts.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whfts.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whfwdata.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whfwdata0.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whgdata.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whglo.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whglo.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whidata.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whidx.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whidx.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whtdata.jsDocumentation/Admin_Cmd_Ref/Support_files/whdata/whtdata0.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whtoc.htmDocumentation/Admin_Cmd_Ref/Support_files/whdata/whtoc.jsDocumentation/Admin_Cmd_Ref/Support_files/whgdata/Documentation/Admin_Cmd_Ref/Support_files/whgdata/whexpbar.gifDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf0.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf1.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf10.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf11.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf12.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf13.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf14.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf15.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf16.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf17.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf18.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf19.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf2.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf20.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf21.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf22.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf23.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf24.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf3.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf4.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf5.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf6.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf7.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf8.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstf9.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl0.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl1.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl10.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl11.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl12.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl13.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl14.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl15.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl16.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl17.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl18.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl19.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl2.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl20.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl21.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl22.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl23.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl24.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl25.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl26.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl3.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl4.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl5.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl6.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl7.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl8.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstfl9.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstg0.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlsti0.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstt0.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstt1.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whlstt2.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf30.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf31.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf32.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvf33.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvl31.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvl32.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvl33.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp30.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp31.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp32.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvp33.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt30.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt31.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt32.htmDocumentation/Admin_Cmd_Ref/Support_files/whgdata/whnvt33.htmDocumentation/Admin_Cmd_Ref/Support_files/whxdata/Documentation/Admin_Cmd_Ref/Support_files/whxdata/whftdata0.xmlDocumentation/Admin_Cmd_Ref/Support_files/whxdata/whfts.xmlDocumentation/Admin_Cmd_Ref/Support_files/whxdata/whfwdata0.xmlDocumentation/Admin_Cmd_Ref/Support_files/whxdata/whglo.xmlDocumentation/Admin_Cmd_Ref/Support_files/whxdata/whidx.xmlDocumentation/Admin_Cmd_Ref/Support_files/whxdata/whtdata0.xmlDocumentation/Admin_Cmd_Ref/Support_files/whxdata/whtoc.xmlsdeexe101/locale/sdeexe101/locale/msg/sdeexe101/locale/msg/default/sdeexe101/locale/msg/default/error.msgsdeexe101/locale/codepage/sdeexe101/locale/codepage/88591.txtsdeexe101/locale/codepage/88592.txtsdeexe101/locale/codepage/88593.txtsdeexe101/locale/codepage/88594.txtsdeexe101/locale/codepage/88595.txtsdeexe101/locale/codepage/88596.txtsdeexe101/locale/codepage/88597.txtsdeexe101/locale/codepage/88598.txtsdeexe101/locale/codepage/88599.txtsdeexe101/locale/codepage/885913.txtsdeexe101/locale/codepage/codepage.txtsdeexe101/locale/codepage/dbase.txtsdeexe101/locale/codepage/437.txtsdeexe101/locale/codepage/708.txtsdeexe101/locale/codepage/720.txtsdeexe101/locale/codepage/737.txtsdeexe101/locale/codepage/775.txtsdeexe101/locale/codepage/850.txtsdeexe101/locale/codepage/852.txtsdeexe101/locale/codepage/855.txtsdeexe101/locale/codepage/857.txtsdeexe101/locale/codepage/860.txtsdeexe101/locale/codepage/861.txtsdeexe101/locale/codepage/862.txtsdeexe101/locale/codepage/863.txtsdeexe101/locale/codepage/864.txtsdeexe101/locale/codepage/865.txtsdeexe101/locale/codepage/866.txtsdeexe101/locale/codepage/869.txtsdeexe101/locale/codepage/1250.txtsdeexe101/locale/codepage/1251.txtsdeexe101/locale/codepage/1252.txtsdeexe101/locale/codepage/1253.txtsdeexe101/locale/codepage/1254.txtsdeexe101/locale/codepage/1255.txtsdeexe101/locale/codepage/1256.txtsdeexe101/locale/codepage/1257.txtsdeexe101/locale/codepage/1258.txtsdeexe101/locale/codepage/885910.txtsdeexe101/locale/codepage/885915.txtsdeexe101/bin/sde2shpsdeexe101/bin/sde2tblsdeexe101/bin/sdeconfigsdeexe101/bin/sdedbtunesdeexe101/bin/sdeexportsdeexe101/bin/sdegdbrepairsdeexe101/bin/sdegroupsdeexe101/bin/sdeimportsdeexe101/bin/sdelayersdeexe101/bin/sdelogsdeexe101/bin/sdemonsdeexe101/bin/sderastersdeexe101/bin/sdesetupsdeexe101/bin/sdetablesdeexe101/bin/sdeversionsdeexe101/bin/sdexinfosdeexe101/bin/sdexmlsdeexe101/bin/setup_st_geometrysdeexe101/bin/shp2sdesdeexe101/bin/shpinfosdeexe101/bin/tbl2sdesdeexe101/etc/dbinit.sdesdeexe101/etc/dbtune.sdesdeexe101/etc/services.sdesdeexe101/etc/gcspcs.crefsdeexe101/lib/archive_util.spssdeexe101/lib/archive_util.spbsdeexe101/lib/layer_stats_util.spssdeexe101/lib/layer_stats_util.spbsdeexe101/lib/sde_util.spssdeexe101/lib/sde_util.spbsdeexe101/lib/svr_config_util.spssdeexe101/lib/version_util.spssdeexe101/lib/svr_config_util.spbsdeexe101/lib/version_util.spbsdeexe101/lib/layers_util.spssdeexe101/lib/layers_util.spbsdeexe101/lib/rastercolumns_util.spssdeexe101/lib/rastercolumns_util.spbsdeexe101/lib/metadata_util.spssdeexe101/lib/metadata_util.spbsdeexe101/lib/registry_util.spssdeexe101/lib/registry_util.spbsdeexe101/lib/sref_util.spssdeexe101/lib/sref_util.spbsdeexe101/lib/locator_util.spssdeexe101/lib/locator_util.spbsdeexe101/lib/pinfo_util.spssdeexe101/lib/pinfo_util.spbsdeexe101/lib/lock_util.spssdeexe101/lib/lock_util.spbsdeexe101/lib/dbtune_util.spssdeexe101/lib/dbtune_util.spbsdeexe101/lib/version_user_ddl.spssdeexe101/lib/version_user_ddl.spbsdeexe101/lib/sdo_util.spssdeexe101/lib/sdo_util.spbsdeexe101/lib/xml_util.spssdeexe101/lib/xml_util.spbsdeexe101/lib/logfile_util.spssdeexe101/lib/logfile_util.spbsdeexe101/lib/instances_util.spssdeexe101/lib/instances_util.spbsdeexe101/lib/st_domain_methods.stbsdeexe101/lib/st_domain_methods_10g.stbsdeexe101/lib/st_domain_methods.stssdeexe101/lib/st_domain_operators.spbsdeexe101/lib/st_domain_operators.spssdeexe101/lib/st_domain_stats.stbsdeexe101/lib/st_domain_stats.stssdeexe101/lib/st_geom_util.spbsdeexe101/lib/st_geom_util.spssdeexe101/lib/st_geometry.stbsdeexe101/lib/st_geometry.stssdeexe101/lib/keyset_util.spssdeexe101/lib/keyset_util.spbsdeexe101/lib/st_geometry_shapelib_pkg.spssdeexe101/lib/st_geometry_shapelib_pkg.spbsdeexe101/lib/spx_util.spbsdeexe101/lib/spx_util_10g.spbsdeexe101/lib/spx_util.spssdeexe101/lib/spx_util_10g.spssdeexe101/lib/st_geom_cols_util.spbsdeexe101/lib/st_geom_cols_util.spssdeexe101/lib/st_geometry_operators.spbsdeexe101/lib/st_geometry_operators.spssdeexe101/lib/st_geomfromtext.stbsdeexe101/lib/st_geomfromtext.stssdeexe101/lib/st_linestring.stbsdeexe101/lib/st_linestring.stssdeexe101/lib/st_multilinestring.stbsdeexe101/lib/st_multilinestring.stssdeexe101/lib/st_multipoint.stbsdeexe101/lib/st_multipoint.stssdeexe101/lib/st_multipolygon.stbsdeexe101/lib/st_multipolygon.stssdeexe101/lib/st_point.stbsdeexe101/lib/st_point.stssdeexe101/lib/st_polygon.stbsdeexe101/lib/st_polygon.stssdeexe101/lib/st_relation_operators.spbsdeexe101/lib/st_relation_operators.spssdeexe101/lib/st_spref_util.spbsdeexe101/lib/st_spref_util.spssdeexe101/lib/st_type_user.spbsdeexe101/lib/st_type_user.spssdeexe101/lib/st_type_util.spbsdeexe101/lib/st_type_util.spssdeexe101/lib/st_cref_util.spbsdeexe101/lib/st_cref_util.spssdeexe101/lib/st_curve.stbsdeexe101/lib/st_curve.stssdeexe101/lib/st_geomcollection.stbsdeexe101/lib/st_geomcollection.stssdeexe101/lib/st_linefromtext.stbsdeexe101/lib/st_linefromtext.stssdeexe101/lib/st_mlinefromtext.stbsdeexe101/lib/st_mlinefromtext.stssdeexe101/lib/st_mpointfromtext.stbsdeexe101/lib/st_mpointfromtext.stssdeexe101/lib/st_mpolyfromtext.stbsdeexe101/lib/st_mpolyfromtext.stssdeexe101/lib/st_multicurve.stbsdeexe101/lib/st_multicurve.stssdeexe101/lib/st_multisurface.stbsdeexe101/lib/st_multisurface.stssdeexe101/lib/st_pointfromtext.stbsdeexe101/lib/st_pointfromtext.stssdeexe101/lib/st_polyfromtext.stbsdeexe101/lib/st_polyfromtext.stssdeexe101/lib/st_surface.stbsdeexe101/lib/st_surface.stssdeexe101/lib/st_type_export.spbsdeexe101/lib/st_type_export.spssdeexe101/lib/gdb_util.spbsdeexe101/lib/gdb_util.spssdeexe101/lib/st_pixeldata.wtssdeexe101/lib/st_pixeldata.wtbsdeexe101/lib/st_raster.wtssdeexe101/lib/st_raster.wtbsdeexe101/lib/st_raster_util.wpssdeexe101/lib/st_raster_util.wpbsdeexe101/lib/libicudata.sosdeexe101/lib/libicudata.so.44sdeexe101/lib/libicudata.so.44.2sdeexe101/lib/libicuuc.sosdeexe101/lib/libicuuc.so.44sdeexe101/lib/libicuuc.so.44.2sdeexe101/lib/libicui18n.sosdeexe101/lib/libicui18n.so.44sdeexe101/lib/libicui18n.so.44.2sdeexe101/lib/libxerces-c.sosdeexe101/lib/libxerces-c-3.1.sosdeexe101/lib/libtiff.sosdeexe101/lib/libpe.sosdeexe101/lib/libsg.sosdeexe101/lib/libsde.sosdeexe101/lib/libsdeora11gsrvr101.sosdeexe101/lib/libgsrvrora11g101.sosdeexe101/lib/libsdesetup.sosdeexe101/lib/libst_shapelib.sosdeexe101/lib/libst_raster_ora.so Finished loading package(s) Exiting...
根据用户软件安装的位置以及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 SDEHOME\etc\sde_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/sdeexe93SDE_OWNR=sdeORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1##if [ ! -d $SDEHOME ] || [ ! -f $SDEHOME/bin/sdemon ]thenecho "ArcSDE startup: cannot start"exit 1fi#case "$1" instart)#ArcSDE startupecho -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/sdeecho "OK, Started";;stop)#ArcSDE shutdownecho -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/sdeecho "OK, Stopped";;restart)$0 stop$0 start;;*)echo "Usage: $0 start|stop|restart"exit 1;;esacexit 0
然后:
chmod 755 sde.sh
sudo cp sde.sh /etc/init.d/
sudo update-rc.d sde.sh defaults 99
就可以了。