arcsde9.1 for oracle10g 在ubuntu上的安装
http://support.esri.com/index.cfm?fa=downloads.patchesServicePacks.viewPatch&PID=19&MetaID=1155
下载arcsde for oracle 10g
装的前期准备：
1.1 首先创建一个Oracle数据库实例用来存储GIS数据
1.2 使用sys用户登陆，在该数据库中创建一个表空间 sde 大小可以为100MB
1.3 创建sde用户，设置表空间为sde,临时为temp；在角色标签中，授予sde用户connect和Resource角色；在系统权限中授予sde用户Select Any Table权限；在限额中设置sde表空间为无限制.好了这样用户就设置正确了，点击应用创建sde用户.
1.4 在打开方案->程序包->SYS，选择DBMS_LOCK，鼠标右击选择授予权限,授予EXECUTE 给PUBLIC；用相同的方法授予DBMS_PIPE给Public.
创建系统的sde用户，用户组为oinstall指定如下变量到用户的.bashrc_profile
SDEHOME <location of ArcSDE>
ORACLE_HOME <location of Oracle>
ORACLE_SID <Oracle SID value>
TNS_ADMIN <location of the tnsnames.ora file>
PATH $PATH:$SDEHOME/bin:$ORACLE_HOME/bin
LD_LIBRARY_PATH $SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib (All platforms except HP and IBM)
在82服务器上设置如下
export SDEHOME=/usr/local/sdeexe91
export ORACLE_HOME=/opt/ora10
export ORACLE_BASH=/opt/ora10
export ORACLE_SID=compiere
export TNS_ADMIN=/opt/ora10/network/admin
export PATH=$PATH:$SDEHOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/lib:$ORACLE_HOME/lib
好了，通过上面的操作，我们的准备工作就完成了，现在就可以安装软件了
%uncompress sde91-ora10gR2-lx.tar.Z
%tar vfx sde91-ora10gR2-lx.tar
%./install -load
确保对所安装目录具有权限(否则会在启动sdemon 时会报bad login user, unable to start iomgr的错误)
sdesetupora10g -o install -l youecpfile.ecp -u sde -p goldmap
如果前面有什么漏掉了，导致创建失败，也没关系
修改sde用户的权限，赋予如下的权限
ALTER ANY INDEX
ALTER ANY TABLE
ANALYZE ANY
CREATE ANY INDEX
CREATE ANY PROCEDURE
CREATE ANY SEQUENCE
CREATE ANY TRIGGER
CREATE ANY VIEW
CREATE SESSION
DROP ANY INDEX
DROP ANY TABLE
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
SELECT ANY TABLE
UNLIMITED TABLESPACE
然后
sdesetupora10g -o upgrade -l youecpfile.ecp -u sde -p goldmap
dbinit.sde文件中可做如下设置
set ORACLE_SID=compiere
set SDEUSER=sde
不写什么，默认好像也可以，我是一开始报bad login user, unable to start iomgr的错误时病急乱投医加的，呵呵！
其它安装参见
sde91-ora10gR2-esri-lx.tar.Z压缩包里的安装文档，比较简单，不再多说了.
客户端需要连接这个版本的sde，看网页上说需要如下更新
http://support.esri.com/index.cfm?fa=downloads.patchesServicePacks.viewPatch&PID=19&MetaID=1155
o If you connect to ArcSDE 9.1 using ArcGIS 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g, please follow the steps below to install this release to your ArcGIS 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g installation folder:
o Before you start, make sure you have write access to the installation folder, then download the zip file to that location:
sde91-ora10gR2-esri-win.zip 2 MB
oArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS Application Server (in that order).
o Use WinZip to extract the new files from sde91-ora10gR2-esri-win.zip to the appropriate installation folder, see list below:
+ ArcGIS Desktop, Server, Engine, Reader, or ArcView 9 - <installation-folder>\arcgis\bin
+ ArcGIS Workstation - <installation-folder>\arcexe9x\bin
+ ArcView GIS - <installation-folder>\av_gis30\arcview\(bin32 & DCONNECT\LIB)
+ Depending on the ArcIMS Setup features installed, the SDE client file could be located in one or more of the following locations:
# C:\Program Files\ArcGIS\bin
# C:\Program Files\ArcGIS\ArcIMS\IndexBuilder
# C:\Program Files\ArcGIS\ArcIMS\Metadata\Commands
# C:\Program Files\ArcGIS\ArcIMS\Server\bin
oArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).
NOTE: After uninstalling any of the above ESRI products, these newly added files will remain. You must manually delete them after uninstalling the product.
|