如何在两台不同的机器上安装配置ArcSDE （oracle）

<P ><FONT face=Arial size=2>1 Ensure Oracle is installed and running on the remote server. </FONT></P>
<P ><FONT face=Arial size=2>1 确保在远程机器（以下称做机器B）上安装好Oracle 服务器端。</FONT></P>
<P ><FONT face="Times New Roman" size=2></FONT> </P>
<P ><FONT face="Times New Roman" size=2>2  Install Oracle Net Software on the Server where ArcSDE is to be installed. Ensure SQL will operate from this remote machine to the Oracle server. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> As ArcSDE is on a machine remote to Oracle, the ArcSDE is effectively a client to Oracle, and will use the Oracle Net communication software.</FONT></P>
<P ><FONT face="Times New Roman" size=2>2 在将要安装ArcSDE 的机器（以下称作机器A）上安装Oracle Net 软件（Oracle 客户端），确保 SQL能在机器A上访问机器B。</FONT></P>
<P ><FONT face="Times New Roman" size=2>当ArcSDE 通过远程机器访问主机的时候，ArcSDE 就作为Oracle服务器的一个客户端，它通过Oracle Net软件与主机交互。</FONT></P>
<P ><FONT size=2><FONT face="Times New Roman">3 Perform pre-installation requirements, as described in the ArcSDE Install Guide. </FONT><FONT face="Times New Roman">The ArcSDE Installation Guide can be found on the Installation CD as an HTML document.</FONT></FONT></P>
<P ><FONT face="Times New Roman" size=2><p>3 按照ArcSDE 安装指南的安装需求检查系统是否满足安装要求。注：ArcSDE 安装指南在安装CD上，是HTML文件。</p></FONT></P>
<P ><FONT face="Times New Roman" size=2><p></p></FONT> </P>
<P ><FONT face="Times New Roman" size=2>4 Install ArcSDE, as per install guide </FONT></P>
<P ><FONT face="Times New Roman" size=2>4 按照安装指南，安装ArcSDE 。</FONT></P>
<P ><FONT face="Times New Roman" size=2></FONT> </P>
<P ><FONT face="Times New Roman" size=2>5 Perform ArcSDE post installation setup, as per the install guide. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> When using the Install Wizard Post Installation, use the Oracle Net Service Name created with the Oracle Client Software in all places that the Install Wizard asks for the Net Service Name </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> If creating the post installation repository tables with the sdesetupora9i command it may require a password of -p <a href="mailtpassword@Oracle_net_service_name" target="_blank" ><FONT color=#5f659d>password@Oracle_net_service_name</FONT></A></FONT></P>
<P ><FONT face="Times New Roman" size=2>5 按照安装指南执行ArcSDE  post installation。在用安装向导来安装Post Installation时，在向导要求填写Net Service Name 的地方，填写由Oracle客户端创建的Oracle Net Service Name。如果在命令行执行sdesetupora9i 来安装post installation 的话，需要一个Oracle的密码。格式为 -p <a href="mailtpassword@Oracle_Net_Service_Name" target="_blank" ><FONT color=#5f659d>password@Oracle_Net_Service_Name</FONT></A></FONT></P>
<P ><FONT face="Times New Roman" size=2></FONT> </P>
<P ><FONT face="Times New Roman" size=2>6 Windows: (如果是Windows操作系统)<BR>Further step required. You must create the windows service. <BR><BR>Use sdeservice -o create to create the windows service as the Install 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 explanation of the command. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> For 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. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> For ArcSDE 9.0 setups, the -d option for the sdeservice is required and you must enter the name of the Oracle Instance (SID). However, as it is not possible for a windows service to have a dependency on a service that is on a remote server, you will need to add to the sdeservice syntax the -n parameter to negate the dependency. <BR>Example: sdeservice -o create -p sdepasswd -d ORACLE9I,ORCL -n -i esri_sde </FONT></P>
<P ><FONT face="Times New Roman"><FONT size=2> <p></p></FONT></FONT></P>
<OL type=1 start=7>
<LI class=MsoNormal style="MARGIN: 0cm 0cm 12pt; mso-margin-top-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt"><FONT face="Times New Roman" size=2>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. <BR>If the ArcSDE server is on Windows, set LOCAL to the Oracle net service name in the SDEHOME\etc\dbinit.sde file ie; <BR>set LOCAL=netservicename. </FONT></LI></OL>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> 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 will overwrite it with an ORACLE_SID setting. The SDEHOME/etc/dbinit.sde file should not contain the following line - set ORACLE_SID=SID. </FONT></P>
<P ><BR><FONT face="Times New Roman" size=2>If the ArcSDE server is on UNIX, set TWO_TASK to the Oracle net service name. The ORACLE_HOME variable must also be set. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> TWO_TASK and LOCAL are Oracle environment variables. Refer to Oracle documentation for further information</FONT></P>
<P ><BR><FONT face="Times New Roman" size=2>The TNS_ADMIN variable must be set if the default location of the tnsnames.ora file is not used. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> If you receive Oracle connection errors, check if the TNS_ADMIN variable has been set, and where it points to. Set the TNS_ADMIN variable to see it it resolves the problem. Check the tnsnames.ora file for correctness. Check the ORACLE_HOME variable has been set. </FONT></P>
<P ><v:shape><v:imagedata><FONT face="Times New Roman" size=2></FONT></v:imagedata></v:shape><FONT face="Times New Roman" size=2> 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 Managing ArcSDE Services.</FONT></P>
<P ><FONT face="Times New Roman"><FONT size=2> <p></p></FONT></FONT></P>
<OL type=1 start=8>
<LI class=MsoNormal style="MARGIN: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto; mso-list: l0 level1 lfo1; tab-stops: list 36.0pt"><FONT face="Times New Roman" size=2>Start ArcSDE, as per install guide. </FONT></LI></OL>
<P ><FONT face="Times New Roman"><FONT size=2> <p></p></FONT></FONT></P>