ArcGIS 10.2 直连和ArcSDE 10.2服务链接 Oracle 11g r2 配置总结

ArcGIS10.2直连和ArcSDE10.2服务链接Oracle11gr2配置总结一、软件安装1、Oracle11gr2数据库安装取箱-■芸成合OracleDWalMEfl11gEJttK2ElPSff•SfeSE窸-竭打9血OracleDjt3ba«LLg提行饭2疗皿戸--问VS配毀區亚拓宀y:Cl.丄Iwi；-ui.i,，u.：-.in:./.■inu■--r---i!ii■；：im.f-.i5.>壮荊皆itiJhh:■!..kC.jjuiI■V-^.-i^fty：MyOracleSupport口&(0》v后追®帮助HT..屮、力土铢用rhA阴IS克病送1帀ORAOL€'叩叩算[□ATABASEmIKH拦此电子邮件ife址料用于曲收有耀空问勘通扭趣谡幅井启咖EE就器。査直趣啦少KACLHq[g&71ABASE说网二磁装;"•创建和配蛊啟书匡©L.火闭訣:件:|,先fits宙菊却■.■/RE帮助砂汁叮PEI浮籬创■=后居砂下一占㈣-塾OradeDatabasellg境廣2対朝-怎感埠嘩-歩袅3/3系统类IIORACLeDATABASEir+ITTT..旦血圭;」腹诙咖面黄細絳加旳宦Gt道项晡动麵薜并亦用制a险C瞬夷⑤囲皤器關申耐装（ite主缄鮒心內部辭口则播用的内图则觀此颐1母顶允许便用更谿闽affi1；--曲型安装配置ORACLEqq*lTtabase丫團眈麹*安諭■T•玉势芍1拠輙奘¥亓屮且匸柠壬y觀要I誓删'」誠nrsdR^=|TiH'ElapplFORE^R空1二三tEla ppt 关于艾滋病ppt课件精益管理ppt下载地图下载ppt可编辑假如ppt教学课件下载triz基础知识ppt FOREVEF^roducfll1::Ubhome」E^applFOREVERlnradala刃览型翱认值优问胎跑”二帥询」:=：■=.H'hMu：HV卜_歩酎吴质0职消曹OracleDatalaasellgfeHa2總師-旻姦搞去-步焉4/8帮助⑪注尼回下一步酚就E)SWltD=后退⑪就CD[刖消]SWltD=后退⑪就CD[刖消]gOracleDshbasrllc;廝亍版2貝理厅-妄蛹i捋库-步錚5/B皿存先决条件检查ORAO-EqqgDATABASEY日蛊盍全更新舞断，Y裁堂...由刮古奘i处夬劉松杳T佛丫須?产丽■-■融重新栓査©全部显示*□鏑濟ID此先映榮件驗務统物理冋存潍杲否誣丸92-2MB(9^128.0KB)o仙网)却厲且mui：Rv:;丈灯疽:2.6628GB(4051612.0KB)伽®牙出观》J|完E]「班消自OracleDatflba^ellg器证2四？-妄述讎库-歩妄6/Bn(回tFfTOF?AO_m[QgDATABASE諜迭项典型安英做盖IW否-□MI：lHDnr1ltlHNH11ij奘程库-仝卮诰査冊醛闫要求丄加凶可用9126GS範忖罟:K取厅ORACLEUin6<11gR2_da1abas0_1ot2IdalabaselinstaIk.lstagg^roduc77萇打辻虛聲安技ii据库蘇:企、.:顾億惟律隘数拒宦Q)OracleS目录E13PP1FOREVERf?4lZizElappiFJREVERipraductn1.2nidhhome-^-产品満甲信息产』活芫•立走C:.=io?ia^:il:c：,i：iQ：l:1||r,cr:ci”r0盐折库信息醯:一«^¥畀处俚⑼全融拒魅UCl:Fl'llir：JkTq卜悦存I鹹文件⑶..Lj.OracleDatabasew•准奋•复制丈件.舞程序文件OracleDatabase酉f蓋ORAQL&CUTANAKE|jga资料世JCansoI[dateCOiTupre&sControl正在加载产品列抵语狗D%妄全更前舞迭顷典型安驶先瞬件樋6IS专荣产品先:夬亲•件涯EntfirprisEManagerDatabasE亡口rMralURL-[口nil):h1ips:Jfldcalhost1156fem埶援库郎蛊交件已经安釀到E輛曲刊REVER.FI时具脱定的安装组件也已经安装別曰种阿OREVEROracleDatebase的方奘己战功。注：念OracleDatabasellg宙行呱2妄装廷库--步骤7/BI[完.I[关闭①帮助凹由OracleDatabase二g境行缶2虫峯弓？-3?装叢話-歩聂8/E丫TTT丫丫：J—{却7丁宀-丁II-WI安荼产品K®疑更新艘濒至奘典出舞oracyqqgDATABASE注意：oracle数据库必须为64位的数据库版本2、oracle11gr2客户端安装回£3可用语言凶〕局mOTSAnhqqgDATABASE朗时:mB亡生號帀于开用柱忑■冋制孙朮茎△苫皿時:北匚冃“C卡制心妙可诜砂、須件哄尸逊。创消&OractClient圭艇手-说萤咅户现-歩長1/6迭隹圭芜类塑ORACLGqqgDATABASE自OracleClisnt虫瀝序-说予售.1=1矶-步廣2H窗•女--倡拾士亦忖匸j执行先蜩牛摩|按要-■誨龙需史呵Q刁壬二出“In=.f=n-rii^n:；1745冃二安奘Iy-廿：u讣卅牧件-鰹员（1*'」邑去里笆理林方J=.笆珥二£底江朋舟.=ffl丘库北基申茗户tK'4、淮择产品语言.「诜芒云逅建旦y龙捋产品宙言|曲打先•夬条件摩Y亟安菸咅品异成诰点谢乂行八：1?时停用的•.召台"日亍语協俐脏语克罗地瞬:水八胡仝左H涪乞I汗于I?印匸*曲艄丄仝筆再三1再订卩戸秤来语帚腊语下令凹=」|主]|恥消|帮助凹鮎OracleClient宝養程序-设宜客户丹1>-券砾5/7上丨引亠」矗OracleClient-規置昔户机-出瑕3/7|=叵O俺ACLWqqgDAIABASE月士用二加艙oracle朋以艮与哥畫相关的文ft的oracleitEffig汕也亘目录口v訂|R基二亍◎旳「•.即I“pr?「»m狮(E.丫安裝产品■-融摘乍用于有储cm：珀泮kett壬•山匸舌是一血匕亍冃录-S订斗一污CS)E:lanplFOI?EVEI1.orcducftl1.2.0^liEnl_1熬助凹*后退国下一出凶”童GradeClient安起存-设查春户巩-歩聂叨执行先决条件检查ORACLE怦DATABASEV选舲獄里|応择声品语言；指宇去茶懾!■朴衍先決槩件松也［缠Y吉装产品7完成荊疋肪戸录仆妥求'可山謎经豆星”重訓頤国］［卷迅示〒匾Checks暂isranir庙功-陪仝用仝司您Si^l^:FOREVER-PCClUserslFOREVERlftflpDaialLocallTer肅功：智S雜洶嚮ErrvirDrimgrrtYanahle'PATH'杜杳^T.可您1的业主决条曲册屈毂物徨内存总虽是否至^12eMB(131072.DKH)-牌舸強朗叼丸目:128MBKIC7201)?9Sfi3.3638GB(4051512OKB)S?Ib(tD*启退囿下一占祉要1VDATABASEORACLE'撕安裝类型-oracleCient-士局诰运磁盘空问：更尹’2尿可用87.72GB源位遥:可二-'RACLZ'v/in32_11gR2_clie-t.cicnttinstaII...'stagd:io?u:tz.-rr諜产品：-|'ih:l-R.S-=1寸1：市-二內=二(旧1=三目录fiS：E:lapplF(REyERlproducnn2tH£lien1_1-咅品沽甲信息riSW^fnH”c：.rrogramFies&06JV3racelln/Entory保存响应文件迪.帝助凹“启退回直Or■机IeClient却蜒序-盪目咅户机-岀男即7=■回5jPSo尺ACke怦DATABASE11邃厳装删谊桂产品语言T'IIth行先决杀件檢査般要W(H)联过③在功桂挂挂正成皙>暂.ia?l='.1e-1士氷b-ConfiguraBonI重试®IORACLEOAIABAfiExO(0l辽也i下一步迥）・ConvalidateCompressControl取消n回注意：oracle客户端必须为32位逢OracleClient-iHS朋机-闵7/7ira:i:acn:爪碇irG(C)迭择宝装蛊型迭择产品语言IIIORA£L_ErqqgDATABASE肉行先决荼忡惟査翎要安芬产品下一歩固n誠(DH&lp3、ArcGIS10.2安装闵ArcGIS10.2forDesktopSetupWelcometotheArcGIS10.2forDesktopSetupprogramItisstronglyreconmriendedtiiatyouExitallWindowsprogramsbeforerunningtliissetupprogram.ClickCanceltnquitgetupanddoseanypragramsyouhaverunning.ClickN亡xttncontinueth亡installation.WARNING:ThisprogramisprotectedbycopyrightlawandinternationalInatiesL□nautiiorizedreproducticinordistributionoftiiisprogram^aranyportionofit,mayresultins亡丫亡「亡dvil目ndcriminal□亡nmlti亡打曰ndwillbeproseojiedtn出emaximumextentpassibleunderlaw.ji^lArcGIS10-2forDesktopS^tupji^lArcGIS10-2forDesktopS^tupArcGIS10-2forDesktopSetup%Idonot口匚匚cptth亡li匚enseagreementLi匚enseCancelPytlnornDes-tirn-atranFolderSelectafolderwherePythonwillt>einstalled.p-ython卫・7.SjNumericalPython(NumPy)l.G.1andMatplotlib：!・1・1arerequiredtosupportcertainooreGeoproceBaingtools・Itzi曰recommendedthattheybeinstalledbytheArcGIE10.2forDesktopsetup・ThesetupwillinstallPython2-7.3jNumericalPython{NijnnP^Ji1.6.1andMatplotlib1.■:Uinthefollowingfolder・ToinstallintoadiffierentfblderjdickChangeandselectanoi±terfolder.ThePython2.7.3inatallationdirectoryshouldnc^tcontainspaces・Python2.7.3rMumericalPython(MumPy)1.6.1andMatplotlib丄1.1willneed■9-^.7MBofadditionaldiskspacetoinstall.HelpCancelArcGIS10-2forCeslctopSetupRc-EadytaInstalltheProgramThewizardisreadytobeaminstallaton.匚lickinstalltobegintheinstallation.Ifyouwanttorevieworchangeanyofyourinstallstic^nsettingsj-clickBack・ClickCan匚ultoexitthewizard.Wouldyouliketoanonymously口已厂廿dpateinthedesignoffTjiureversionsofa「匚PIS?rjiClickheretopartidpatjeinthEEsriUserExpedienceImpioveinentprogram・:{fterarTimendad)Ipm「nm门厂戶总hruii~F样i~iI旦尸「尸1口1=和1=门厂戸Trjnnrntpnnpril"<吕jack]InsstallCiancel|ArcGISL0.2forDesktopSetupInshtoKingArcGIS10.2forDe-skrtopTheproyrsmfeaturesyouselectedarebeinginstalled.F'leasewaitwhileArcGIS10.2forDeskto口insiLfll怙'TliismayLake：severalminutes.Status;出ArcGIS10.2forDesktopSetupAn^GIS1D.2forOesktophasbeensuccessfullyinstalled.＜日冃diFinishCancelClicktheFinishbuttontoexitthisinsiallation.ArcSDE10.2forOraclellgSeiupWelcometotheArcSDE1Q.3forOraclellgSetupprogramItisstronglyrecommendedtiiatyouexitallWindowsprogramsbeforerunningthissetupprogram.ClickCanceltoquit^etupandcloseanypragramsyouhaverunning.ClickNesttocontinuedieinstallation.WARNING:ThisprogramisprctertedcapyrightlawandintErnationaltr亡mti亡阶Unautiiorizedreproductionordistributionoftiiisprogram^oranyportionofit,mayresultinsevereduilaidcriminalpenaltiesTaidndbeprosecutedtn出emaximumextentpossibleunderlaw.4、ArcSDE10.2安装闵ArcSDE10.2forQraclellgSetupLicenseAgreementYoumustagreewithiheli匚已nw已agreementbelowtnproceed.IMPORTANT-RIADCAREFLLLYUnlesssupersededbyasignedLic-enseigreeroentbetrreenyouandEsri,EsriwillingtoLicenseProductEmya-uonlyLfvouacceptalltetmEandranditionsc-antaine-dintliisLietnseAgretiutnl.PLeisereadthetermsandeondilionscirefully.YoumivnotusetkeProduclsuntiLyouhiveagreedtothete-rinsuuic-ondilionsoftheLicenseAgreement.Ifvondonotagreelothetermsandcondilionsisstited,click"Idonoticcejrtth.eLicensei^reement''beLoTr;toilmaytkenrequestirefunda-fapplicablefeespaid..PrintLICTNSEAGRTEMEXI0Iaccept出已license目口reerrientIdonotacceptHielieens亡agre亡m亡ntLicenseCancel囲ArsSDE10,2forOracleSelectFeaturesPleaseselectwhichfeaturesyouwouldliketoinstall.匚lickananiconintiielistbelowtotfiangehowafeatureisinEtalled.FeatureDescriptionTheArcSDEappliestionserver[alsocalledanArcSDEservi匚亡）conv亡护spatialdatabetweenGISappliestion吕andanenterprisegendstab3E&.Installto:Tliisfeaturerequires3-4MBonyourharddrive.匍ArcSDE10.2forOraclellgSetupR.eadvtolnstallthePrograrnTliewi^^rdisreadytobegininstallation.Click.InstalltobegintieinEtallation.Ifyoutcirevieworchangeanyofyourinstallationsettings^clickElauk,ClickCancfilt»exittinewizard.闵ArcSDE10.2forOr^clellgSetup€Ei^ck.InstallCancelInstallingArc5DE10.2fo-rOraclellgTh已programfeaturesyouselectedarebeinginstalled.PleasewaitwhileArcSDE10.2■forOraclellginstalls.Tlnismaytakeseveralminutes.Status:Next>Cancel率*Artijfwlijg-Folder匚onrK-niflnsPol'liFCo>Tlg'：U.«]L5；申XC^tflbgTrw■3|£百Fald«r匚cnna^icmQ£TglbT3LQOotabmeSprwrs-田与Eanneffl宙GgServeiT：田MyHci^ad£・rvir”QL3fi.*ady-To-UseSt^icts1、启动ArcCatalog10.21、ArcGIS10.2与Oracle11gr2直连配置FiInEditVinr卫口GvcpraeviiirigCunEomiHWlndcnxHv|ptslX器痔圍耗OlEltSIKnJ»B■■2、点击databaseconnection,选择adddatabaseconnectionE匚主FolderConnections-(±)E^iToolboxesi±i口3D呂tabaseS-eirversEJDatat>aseConnections1-jj!AddD^tat>aseConnection®§31GIS-Servers.EMyHostedSe-irvices®Resdy-To-UsesServics-s2、配置链接Oracle参数GeodatabaseAdministration-CreateEnterpriseGeodatabase工具，设置相关参数，点击OK，即可完成空间数据库的启用。日裁Geo-databaseAdministration声、AnalyzeDsttasets洪'*Change-Privileges咽饨Compress我、CreateDatabaseU&er.CreateEnterpriseGeo-databas•日气CreateRole亠、EnableEnterpriseGeadatabase声*MigrateStorage"気RebuildIndexes巴*、RegisterwitlrGeodatabase"鼻UpgradeDatasetUpgrmde1deoTmizab’EegC*UpgradeSpatialRefer&nce完成创建空间数据库之后，再次添加一个sde用户，通过以上的工具，可以实现空间数据库的用户管理，角色管理，权限管理等数据库的管理职能，通过连接之后，可以实现数据的入库，编辑，查询等操作。、ArcSDE10.2与Oracle11gr2的服务连接配置1、在C:\Windows\System32\drivers\etc目录下的service文件下增加一个sde服务services”迅事本丈忡㈢彌［曰咼:S莹老㈣Sfe(H)KSdtGl3882Acd#DTSSer\dcePortsdp~pcfftm-apper一#SDPPoriMapperFrotoc口J.sdp-riOTtmaiipcr:「.更/亡.#SDPPortMapperPtoIocdInet-device^250/i.K#NetDevicenrt_devi匚亡3350/li1j#%tDeviceips已cmsFt[•HjQt-：：MicrosoftIPsecNAT^Tipsec^reft#HlcrosoftIPsecNAT-Tllnnr:：!■!i./l:札LMNRllnrirffLLMNKwsd■..l：#WebServicesondeviceswsd'■:-：#WebServicesondevicesrrac邛％"t^RemoteReplicationAgentConnectionrracJ飞门阳#RemoteReplicationAgentCoeinectiondeem5G79/-tcp#DircctCabL亡匚口口11亡亡十Managerdeem5&79/adp#DirectCableConnectManagerEE-liceiifiingm：#HlcrosoftLicensingms-1icmsinE5720/udp#TIicrosoftLitensingdirectplayB5C^Sx't::ttDirectPlayEdire匚七卩^屯吕#DirEctPlayEman#1?5口上亡NanServerrasadv?"53/t:二rasadv:■''f一心imip-channelsIIWQt■;.#IKTPChanneLsPartimp-channelsHj20Al^#IKIPCharuiELsPartdirectpla.ysm"异上4八-#DirectPlayServerdircctplaysrvr^7&24/udp#。让匸毗PlayServeresri_sde2、在C:\ProgramFiles\ArcGIS\ArcSDE\ora11gexe\etc目录下的service.sde文件中将注释sde服务的#去掉［］servirCcii^niion.件'.‘站「斤冇*乂千［|*C=xJUutfj-v\FOREUER>4、创建sde服务C:MisersXFOREUER>sdeseruice-ocreate-dOFtACLE^OFtCL-psde-iesri_sdeCopyingcontentsofC：XPpogramFilesSfli'cGISsflpcSDEXoi'allgexeXetcXdbinit.sdetoC:\ProgramFilesSflrcGISsflrcSDEXorallgexeXetcXdbinit.sde.hackup.KuccessfLillycreatedandFegisteredesi'i_sdeseruice5、启动sde服务C:XJUsers\FOEEUER>sdenon-ostart-psdeApcSEEInstanceesri_sdestartedTueJul2914：30：4520146、创建ArcSDE链接7、选择Arctoolbox-datamanagementtools-GeodatabaseAdministration-workspace-createArcSDEconnectionfile配置好相关参数后点击OK,等待创建完成日sde2014.5.deEI.CHANNELSB[.COSTSB[.COUNTRIESBI.CU&TOMERSEI.PRaDUCTSB[.PRaMOTION£MEI.SALESfflBI.TIMESSHR.COUNTRIESnHR.DEPARTMENTSraHR.EWP_DETAILS_V1EWHHR.EMPLOYEESMHR.JOB_H[STORVHHR.JOBS冒HKLOCATECJNSnHR.REGIONSnIX.AQ$_OKDER£_QUEUETAIHIX.AQ$_OkDER&_QUEUETAInIX.AQ$_OkDER£_QUEUETAIIHIlHACfHDRDFR＜；nilFUFTAI此时的连接即为ArcSDE服务连接。四、总结1、直连是必须的链接的客户端机器上安装Oracle数据库客户端才能连接配置好的服务器端数据库这样显得比较麻烦，一般在客户机上都不会装Oracle客户端。2、ArcSDE服务链接，则不需要客户端的安装，通过在服务器端配置好ArcSDE数据库服务，在客户端直接创建ArcSDE文件，方便的实现客户端机器连接服务器端的数据库。3、在配置的时候同样需要在服务器端安装Oracle数据库客户端，便于创建企业级空间数据库。