倒腾arcgis10.2 sde服务

环境：windows server 2012, 已安装oracle 11g,  dbhome_1, client_1, arcmap 10.2 : 

已使用arcmap 创建企业库SDE, 并创建用户 user1  并启用，添加了数据集，注册了版本。并AE二开后进行连接使用。

现在想在这台服务器上安装arcsde10.2 , 并创建 esr_sde 服务，

oracle client: 

D:\app\Administrator\product\11.2.0\client_1\network\admin 目录 下

listener.ora

# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\client_3\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-GT23SBE120R)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = D:\app\Administrator

tnsnames.ora

# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.2.0\client_3\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =WIN-GT23SBE120R)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ORCL)
    )
  )

oracle dbhome:

E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN 目录下：

 listener.ora

# listener.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ANY")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-GT23SBE120R)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = E:\app\Administrator

tnsnames.ora

# tnsnames.ora Network Configuration File: E:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-GT23SBE120R)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

以上可知 ServiceName  = ORCL  (Oracle客户端配置的Oracle服务名)

下面开始安装ArcSDE

 因为是oracle11g ,只安装这个就可以了一路next到底

 然后你就有了这样的目录：

然后你的sdemon 命令就有了，可以使用了 ，他们是在  C:\Program Files\ArcGIS\ArcSDE\ora11gexe\bin  目录下

安装时自动加了这个路径到 path中的 

  检查这两个文件 dbinit.sde,  services.sde 

 

 在C:\Windows\System32\drivers\etc  services文件最后加上这行 esri_sde 5151/tcp

 开始创建esri_sde 服务了:这里的orcl 就是serviceName ,oracle客户端配置好的。

 sdeservice -o create -d oracle,orcl -p sde -i esri_sde   

 如果没有做前面的配置，直接启动的话，可能报这样的错误：

 除此之外还要导入 esri的许可：

C:\Users\Administrator>sdesetup -o update_key -d oracle -l c:\server.ecp -u sde -p sde

 arcgis server 的许可Ecp 文件和这个sde是通用的。我也放在后面了。

再启动就ok

 (怀念一下，arcgis 9.3.1时经常这么弄这个服务)

最后附上server.ecp (这个今年过期，要重找一个，见有个2030年的)

arcgisserver,102,ecp.arcgis.product,31-dec-2024,E9PJJE2EXHEDZTG23024
3dengine,102,ecp.arcgis.product,31-dec-2024,D7MGJE2EXHEDZTG23245
3dserver,102,ecp.arcgis.product,31-dec-2024,IE8LLD1ARJH7PKARP213
arcgisengine,102,ecp.arcgis.product,31-dec-2024,HC4LERFP6Y4M6008A000
arcimsserver,102,ecp.arcgis.product,31-dec-2024,JFB7JK9L5E2K81HBB141
arcsdeserver,102,ecp.arcgis.product,31-dec-2024,YYHJSRFSC2ARG9EJJ106
bingmapseng,102,ecp.arcgis.product,31-dec-2024,HC40LK8HZ0LFYSJ02035
bingmapssvr,102,ecp.arcgis.product,31-dec-2024,YYPF80PZJ9FYJD1LN152
businessvr,102,ecp.arcgis.product,31-dec-2024,RP5L04S3MCJ1NH5PR184
defenseintleng,102,ecp.arcgis.product,31-dec-2024,OLRDFK9L5E2K81HBB018
defenseintlsvr,102,ecp.arcgis.product,31-dec-2024,OLPJRPJEG6EEKDZNN115
defenseuseng,102,ecp.arcgis.product,31-dec-2024,D7HDFH5H1RZG3XK67242
defenseussvr,102,ecp.arcgis.product,31-dec-2024,VPH30H4EEMSBTHEEY070
designer,102,ecp.arcgis.product,31-dec-2024,XXMA0RFP6Y4M6008A014
gdbedit,102,ecp.arcgis.product,31-dec-2024,KGC9KK9L5E2K81HBB166
geostatserver,102,ecp.arcgis.product,31-dec-2024,A3F654S3MCJ1NH5PR051
imageextserver,102,ecp.arcgis.product,31-dec-2024,FAYLDTHH9PBFL9FCD115
interopengine,102,ecp.arcgis.product,31-dec-2024,OLPGMNCH8Z6HC5RFF152
interopserver,102,ecp.arcgis.product,31-dec-2024,D7L60XLLE5BPE8XHJ216
jtxserver,102,ecp.arcgis.product,31-dec-2024,FA00RPJSA180A4TDF128
maplexengine,102,ecp.arcgis.product,31-dec-2024,HC5TMK8HZ0LFYSJ02226
networkengine,102,ecp.arcgis.product,31-dec-2024,FA0LYPJSA180A4TDF055
networkserver,102,ecp.arcgis.product,31-dec-2024,ZZYHHAY7NFK4LG7N0110
routeserver,102,ecp.arcgis.product,31-dec-2024,FAYP7AZATKR9EPCYZ192
schematicengine,102,ecp.arcgis.product,31-dec-2024,KGE1YXLLE5BPE8XHJ216
schematicsvr,102,ecp.arcgis.product,31-dec-2024,YYPCCE2EXHEDZTG23084
sdeworkgroup,102,ecp.arcgis.product,31-dec-2024,LHF63XLLE5BPE8XHJ021
spatial,102,ecp.arcgis.product,31-dec-2024,S08XY0PZJ9FYJD1LN209
spatialengine,102,ecp.arcgis.product,31-dec-2024,TRC42XLLE5BPE8XHJ039
spatialserver,102,ecp.arcgis.product,31-dec-2024,PM0LZ00TJ0JAY04A3091
standardengine,102,ecp.arcgis.product,31-dec-2024,MJLDC7E70GN5RL8PE051
streetmap,102,ecp.arcgis.product,31-dec-2024,YYRF70PZJ9FYJD1LN154
streetmapengine,102,ecp.arcgis.product,31-dec-2024,OLHDJK9L5E2K81HBB002
streetmapserver,102,ecp.arcgis.product,31-dec-2024,GB4PEXLLE5BPE8XHJ160
svradvanced,102,ecp.arcgis.product,31-dec-2024,D7M92XLLE5BPE8XHJ247
svrenterprise,102,ecp.arcgis.product,31-dec-2024,OLPLRNCH8Z6HC5RFF207
svrstandard,102,ecp.arcgis.product,31-dec-2024,XXL974S3MCJ1NH5PR003
tifflzw,102,ecp.arcgis.product,31-dec-2024,PMYP0XLLE5BPE8XHJ233
tracking,102,ecp.arcgis.product,31-dec-2024,FAYHHAY7NFK4LG7N0250
trackingengine,102,ecp.arcgis.product,31-dec-2024,MJJ4ENBL3P0J2LM46250
trackingserver,102,ecp.arcgis.product,31-dec-2024,MJJFRPJEG6EEKDZNN061
virtualearthsvr,102,ecp.arcgis.product,31-dec-2024,E9PD84S3MCJ1NH5PR205

 

 

这篇sde 的杂谈也是普通 对sde 的认识

https://www.cnblogs.com/Jingkunliu/p/17547057.html