AIC SDE安裝.doc_第1頁
AIC SDE安裝.doc_第2頁
AIC SDE安裝.doc_第3頁
AIC SDE安裝.doc_第4頁
AIC SDE安裝.doc_第5頁
全文預(yù)覽已結(jié)束

下載本文檔

版權(quán)說明:本文檔由用戶提供并上傳,收益歸屬內(nèi)容提供方,若內(nèi)容存在侵權(quán),請進(jìn)行舉報(bào)或認(rèn)領(lǐng)

文檔簡介

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

溫馨提示

  • 1. 本站所有資源如無特殊說明,都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
  • 2. 本站的文檔不包含任何第三方提供的附件圖紙等,如果需要附件,請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
  • 3. 本站RAR壓縮包中若帶圖紙,網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽,若沒有圖紙預(yù)覽就沒有圖紙。
  • 4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
  • 5. 人人文庫網(wǎng)僅提供信息存儲空間,僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護(hù)處理,對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯,并不能對任何下載內(nèi)容負(fù)責(zé)。
  • 6. 下載文件中如有侵權(quán)或不適當(dāng)內(nèi)容,請與我們聯(lián)系,我們立即糾正。
  • 7. 本站不保證下載資源的準(zhǔn)確性、安全性和完整性, 同時(shí)也不承擔(dān)用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

評論

0/150

提交評論