AIC SDE安裝.doc

SDEforOracle9安裝日志(z)(2007-04-13 15:10:41) 轉(zhuǎn)載一、準(zhǔn)備工作1.1 首先創(chuàng)建一個Oracle數(shù)據(jù)庫實(shí)例用來存儲GIS數(shù)據(jù)1.2 使用sys用戶登陸，在該數(shù)據(jù)庫中創(chuàng)建一個表空間 sde 大小可以為140MB1.3 創(chuàng)建sde用戶，設(shè)置表空間為sde,臨時(shí)為temp；在角色標(biāo)簽中，授予sde用戶connect和Resource角色；在系統(tǒng)權(quán)限中授予sde用戶Select Any Table權(quán)限；在限額中設(shè)置sde表空間為無限制.好了這樣用戶就設(shè)置正確了，點(diǎn)擊應(yīng)用創(chuàng)建sde用戶.1.4 在打開方案-程序包-SYS，選擇DBMS_LOCK，鼠標(biāo)右擊選擇授予權(quán)限,授予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: 協(xié)議適配器錯誤更改了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用戶上述的全部權(quán)限，然后更新，這種方法可以保留以往數(shù)據(jù)2DROP 掉SDE表空間和SDE用戶，重建，有些權(quán)限在執(zhí)行完后需要收回用第一種方案：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.我發(fā)現(xiàn)在SDE庫中已經(jīng)有建立了SDE表，不過還不知道全不全，沒有辦法的情況下，我只好用SDESERVICE命令直接創(chuàng)建服務(wù)!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(企業(yè)9.0.1.0.0),原來是ArcSDE8.2，結(jié)果用兩個字來形容“簡單“，一次成功!結(jié)論：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