AIC SDE安装.doc

SDEforOracle9安装日志(z)(2007-04-13 15:10:41) 转载一、准备工作1.1 首先创建一个Oracle数据库实例用来存储GIS数据1.2 使用sys用户登陆，在该数据库中创建一个表空间 sde 大小可以为140MB1.3 创建sde用户，设置表空间为sde,临时为temp；在角色标签中，授予sde用户connect和Resource角色；在系统权限中授予sde用户Select Any Table权限；在限额中设置sde表空间为无限制.好了这样用户就设置正确了，点击应用创建sde用户.1.4 在打开方案-程序包-SYS，选择DBMS_LOCK，鼠标右击选择授予权限,授予EXECUTE 给PUBLIC；用相同的方法授予DBMS_PIPE给Public.二、开始POST安装C:Documents and Settingsryh.WESTGIS.000sdesetupora9i -o install -p sdeESRI ArcSDE Server Setup Utility Fri Apr 30 10:00:10 2004- -Error: Underlying DBMS error (-51).Error: Unable to connectORA-12560: TNS: 协议适配器错误更改了dbinit.sde文件之后C:Documents and Settingsryh.WESTGIS.000sdesetupora9i -o install -p sdeESRI ArcSDE Server Setup Utility Fri Apr 30 11:51:17 2004- -To upgrade your ArcSDE for Oracle 8i or Oracle 9iservice, you will also have to grant the followingadditional permissions to the sde user to accomplishthe upgrade:ALTER ANY INDEXALTER ANY TABLEANALYZE ANYCREATE ANY INDEXCREATE ANY PROCEDURECREATE ANY SEQUENCECREATE ANY TRIGGERCREATE ANY VIEWCREATE SESSIONDROP ANY INDEXDROP ANY VIEWDROP ANY PROCEDUREDROP ANY SEQUENCEEXECUTE ANY PROCEDURESELECT ANY SEQUENCESELECT ANY TABLEUNLIMITED TABLESPACE到这儿有两种方案：1授予SDE用户上述的全部权限，然后更新，这种方法可以保留以往数据2DROP 掉SDE表空间和SDE用户，重建，有些权限在执行完后需要收回用第一种方案：C:Documents and Settingsryh.WESTGIS.000sdesetupora9i -o install -p sdeESRI ArcSDE Server Setup Utility Fri Apr 30 14:33:39 2004- -Upgrade Instance to SDE 8.3: Are you sure? (Y/N): yArcSde is already at an acceptable release: 8.3.0 Oracle9i Build 241 Fri Nov 22 15:35:11 PST 2002Upgrading geodatabase schema:Connection to sde failed(-106)Geodatabase schema object install not completed.我发现在SDE库中已经有建立了SDE表，不过还不知道全不全，没有办法的情况下，我只好用SDESERVICE命令直接创建服务!C:Documents and Settingsryh.WESTGIS.000sdeservice -o create -p ryhoracle -l qzgis -H C:arcgisArcSDEora9iexe -d oracle9i,sde -i esri_sde -u sde -p sdePlease enter SDE service account user password:Error creating SDE Service(esri_sde) - err(1057).Specified service user doesnt have privileges tocreate service.C:Documents and Settingsryh.WESTGIS.000sdeservice -o create -p ryhoracle -l qzgis -H C:arcgisArcSDEora9iexe -d oracle9i,sde -i esri_sdeCopying contents of C:arcgisArcSDEora9iexeetcdbinit.sde to C:arcgisArcSDEora9iexeetcdbinit.sde.backup.Successfully created and registered esri_sde service修改Windows配制文件 首先在c:winntsystem32driversect目录下找到 services文件，使用记事本打开，在最后加一行 esri_sde 5151/tcp #ArcSDE修改sde配置文件在ArcSDE安装路径下的etc目录中（兔八哥的就是D:ArcGISarcexe81arcsdeoraexee tc）有一个services.sde，使用记事本将esri_sde前面的#给去除，保存.C:Documents and Settingsryh.WESTGIS.000sdemon -o start -p sdeesri_sde service failed during initialization.Please check event log or error log files.Error starting esri_sde service(997)Could not start ArcSDE - Check Network, $SDEHOME disk, DBMS settings and dbinit.sde.不行，回到前一步，删除SDE表后：C:Documents and Settingsryhsdesetupora9i -o install -p sdeESRI ArcSDE Server Setup Utility Thu May 06 20:30:27 2004- -Install or update ArcSDE schema objects: Are you sure? (Y/N): yVERSION table created.SPATIAL_REFERENCES table being created.SPATIAL_REFERENCES table created.GEOMETRY_COLUMNS table being created.GEOMETRY_COLUMNS table created.LAYERS table being created.LAYERS table created.METADATA table being created.METADATA table created.RASTER_COLUMNS table being created.RASTER_COLUMNS table created.TABLE_REGISTRY table being created.TABLE_REGISTRY table created.STATES table being created.STATES table created.VERSIONS table being created.VERSIONS table created.MVTABLES_MODIFIED table being created.MVTABLES_MODIFIED table created.STATE_LINEAGES table being created.STATE_LINEAGES table created.LOCATORS table being created.LOCATORS table created.DBTUNE table being created.DBTUNE table created.Connection to sde failed(-106)SDE schema object install not completed.删除重新建立表空间及用户后：C:Documents and Settingsryh.WESTGIS.000sdesetupora9i -o install -p sdeESRI ArcSDE Server Setup Utility Thu May 06 20:47:47 2004- -Install or update ArcSDE schema objects: Are you sure? (Y/N): yVERSION table created.SPATIAL_REFERENCES table being created.SPATIAL_REFERENCES table created.GEOMETRY_COLUMNS table being created.GEOMETRY_COLUMNS table created.LAYERS table being created.LAYERS table created.METADATA table being created.METADATA table created.RASTER_COLUMNS table being created.RASTER_COLUMNS table created.TABLE_REGISTRY table being created.TABLE_REGISTRY table created.STATES table being created.STATES table created.VERSIONS table being created.VERSIONS table created.MVTABLES_MODIFIED table being created.MVTABLES_MODIFIED table created.STATE_LINEAGES table being created.STATE_LINEAGES table created.LOCATORS table being created.LOCATORS table created.DBTUNE table being created.DBTUNE table created.DBMS stored procedures being created or updated.DBMS stored procedures created or updated.Connection to sde failed(-106)SDE schema object install not completed.在好多次不成功而又找不到错误的情况下，我用ArcSDE8.3 for Oracle9i(企业9.0.1.0.0),原来是ArcSDE8.2，结果用两个字来形容“简单“，一次成功!结论：ArcSDE8.1和ArcSDE8.2安装在Oracle8.1.5上有问题ArcSDE8.3 安装在Oracle 9.0.1.0.0上有问题。Adding a direct connection to an Oraclegeodatabase inArcCatalog1. Double-click Database Connections.2. Double-click Add Spatial Database Connection.3. If youre connecting to Oracle8i, type “sde:oracle” in the Service box. If youre connecting to Oracle9i, type “sde:oracle9i”.4. Type the username.5. Type the password followed by “”.6. Check the check box to save the username and password in the connection file so that you can connect to thedatabase