Install ArcSDE on a machine that is remote from the Oracle RDBMS

上一篇 / 下一篇  2010-03-19 04:38:51 / 个人分类：SDE

查看( 819 ) / 评论( 0 ) / 评分( 0 / 0 )

由于ArcSDE服务需要部署到与数据库系统不同的服务器上，需要ArcSDE服务远程连接DBMS实现通道的结合。经过一下午和半个夜晚的尝试终于搞定。下面是一些格外需要注意的地方

注意事项：

1.oracle的客户端版本必须等于或大于DBMS的版本，否则会有问题。譬如9i的客户端连接Oracle 10G就会出现问题，本人使用11G Client连接10G是可以的。

2.使用SDE POSTINSTALL前三步可以按照向导来操作，但第四步（创建SDE服务）绝对不能点击，直接取消退出向导，使用命令行创建和启动服务。（如果你只是迁移SDE服务，前两部不需要做）

3.dbinit.sde文件的修改一定要在创建服务之后进行，改为 set LOCAL = ServiceName，否则创建服务会把dbinit文件刷新为 set Ora_SID =ServiceName。

4.SDE对数据库版本有严格的要求，什么版本的DBMS一定要用对应的SDE版本，否则将在配置SDE属性时失败。不过，32位的SDE可以在64位的环境下使用。

5.启动SDE服务前，要确认windows/system32/drivers/etc/service文件中的存在 esri_sde 5151/tcp #SDE for ORALCE

CMD命令:

--创建SDE服务

C:\>sdeservice -o create -p sdepasswd -d ORACLE10G,ecahz -n -i esri_sde

Copying contents of D:\arcgis\ArcSDE\ora10gexe\\etc\dbinit.sde to D:\arcgis\ArcS
DE\ora10gexe\\etc\dbinit.sde.backup.

Successfully created and registered esri_sde service

--启动SDE服务

C:\>sdemon -o start -i esri_sde -p sde
ArcSDE Instance esri_sde started Fri Mar 19 04:27:54 2010

 

参考文档：http://support.esri.com/index.cfm?fa=knowledgebase.techarticles.articleShow&d=23753

HowTo:  Install ArcSDE on a machine that is remote from the Oracle RDBMS

Article ID:23753
Software: ArcSDE8.2, 8.3, 9.0, 9.1
Platforms:N/A

Summary

Sometimes it is necessary to install ArcSDE on a machine that is remote from the Oracle instance. Instructions provided describe how to install ArcSDE on a machine that is remote from the Oracle RDBMS.

 Installation directions for later versions of the product contain details for distributed setups and can be found in the 9.3 Installation Guide; referenced in the 'Related Information' section of this article.

Procedure

  1. Ensure Oracle is installed and running on the remote server.
  2. Install Oracle Net Software on the Server where ArcSDE is to be installed. Ensure SQL operates from this remote machine to the Oracle server.

     If ArcSDE is on a machine that is remote to Oracle, ArcSDE is effectively a client to Oracle and uses the Oracle Net communication software.

  3. Perform. pre-installation requirements, as described in the ArcSDE for Oracle Installation Guide.
    The installation guide can be found on the installation CD/DVD as an HTML document.
  4. Install ArcSDE, as per the installation guide for the operating system (OS) being used.

    Windows:
    Perform. the ArcSDE Post Installation setup using the Custom option, and uncheck 'Create ArcSDE Service' from the four components/steps of the installation. See Step 5 for information on creating the service manually.

     When using the Post Installation Wizard, use the Oracle Net Service Name created with the Oracle Client Software in all the places that the Installation Wizard asks for the Net Service Name.

     If creating the geodatabase repository tables manually with the sdesetup command, it may require a password of -p password@<Oracle_Net_Service_Name>.

  5. Windows only:
    The ArcSDE Windows service must be created manually when installing ArcSDE and Oracle on remote servers.

    Use 'sdeservice -o create' to create the Windows service, as the Post Installation Wizard is not designed to create a service for ArcSDE setups that are on a remote server. At a command prompt type: 'sdeservice -h' for syntax information or refer to the ArcSDE Developer Guide for syntax and an explanation of the command.

    ArcSDE 8.x setups do not use the sdeservice '-d' option for dependency. It is not possible for a Windows service to have a dependency on a service that is on a remote server.

    For ArcSDE 9x setups, the '-d' option for the sdeservice is required and the name of the Oracle Instance (SID) must be entered. However, as it is not possible for a Windows service to have a dependency on a service that is on a remote server, the sdeservice syntax or the '-n' parameter must be added to negate the dependency.

    For example: sdeservice -o create -p sdepasswd -d ORACLE9I,<ORACLE_SID> -n -i esri_sde.
  6. For Oracle to connect to a remote instance, Oracle has defined an environment variable to identify the remote Oracle instance through the Net service name.

    Windows
    If the ArcSDE server is on Windows, set LOCAL to the Oracle Net service name in the SDEHOME\etc\dbinit.sde file.
    For example, set LOCAL=netservicename.

     The dbinit.sde file should have the LOCAL setting added after the ArcSDE service has been created with the sdeservice command. If the ArcSDE service is created after the dbinit.sde file is updated, it overwrites it with an ORACLE_SID setting. The SDEHOME\etc\dbinit.sde file should not contain the following line - set ORACLE_SID=<SID>.

    UNIX
    If the ArcSDE server is on UNIX, set TWO_TASK to the Oracle Net service name. The ORACLE_HOME variable must also be set.

     TWO_TASK (for UNIX/Linux) and LOCAL (for Windows) are Oracle environment variables. Refer to Oracle documentation for further information.

  7. The TNS_ADMIN variable must be set if the default location of the tnsnames.ora file is not used.

     If Oracle connection errors are received, check if the TNS_ADMIN variable has been set and to where it points. Set the TNS_ADMIN variable to see if it resolves the problem. Check that the tnsnames.ora file is accurate. Check that the ORACLE_HOME variable has been set. When the ArcSDE server is started, the giomgr process reads the variable settings in the $SDEHOME/etc/dbinit.sde file. These variable settings override the variables set by .cshrc or .profile files. The role of the dbinit.sde file is further explained in the book titled, "Managing ArcSDE Services (prior to 9.1)" or within the ArcGIS 9.2 Desktop Web Help topic link in the Related Information section of this article.
  8. Start ArcSDE, as per the installation guide.


 


收藏 举报

TAG:

 

评分：0

我来说两句

Open Toolbar