arcsde10.0 for oracle11g Distributed installation tutorial

Operating system
Oracle:windows Server 2008
Arcsde:win7
"Database Version"
Oracle 11g
"ArcSDE Version"
ArcSDE 10.0

1, Install the Oracle 11gR 2 client on the computer to install ArcSDE, This is relatively simple, pay attention to install as Administrator mode.

2. After installation, use NET configuration Assistant to configure a network service name to connect to the remote database

This step click Change Login, log in with the SYS account, will show that the test is unsuccessful, this does not need to control

Fill in a network service name here, any, remember to spare.

3, the installation of SRCSDE, the previous comparison is not a simple introduction, starting from the configuration of the ARCSDE service

Next

Default, Next

Next

Authorizing ARCSDE with an authorization file

Fill in the content of the ARCSDE service, the ORACLE SID is your DB instance name, the server name fills in the network service name configured above

There may be errors in this step, the workaround is as follows:

(1) Creating the SDE service with Sdeservice in CMD

Sdeservice-o create-d Oracle,"Oracle SID" -i esri_sde-p "SDE user password" -n

Configure your parameters in bold red font locations

(2) Use the Sdemon command to start the ARCSDE service sdemon-o start-p SDE user Password

Startup is an error that may occur

The above error prompts require the following configuration work to resolve the ARCSDE service startup when ARCSDE is installed separately from Oracle

(1) Modify the SDE service profile to locate the Services.sde file in the ArcSDE installation directory under the \ARCSDE\ORA10GEXE\ETC directory, open with Notepad, add a line at the end: Esri_sde 5151 #ArcSDE for Ora Cle

(2) Open ... \arcsde\ora10gexe\etc under the Dbinit.sde file, there is a sentence: set oracle_sid=xxx. Change it to: set local=servicename on it. Where servicename is the network service name configured by the Oracle client, remember!!!

(3) Modify the Windows service configuration file first locate the services file in the C:\winnt\system32\drivers\ect directory, open it with Notepad, and add a line at the end: Esri_sde 5151/tcp #ArcSDE for Or Acle

(4) The ARCSDE database connection failure of different network segments is resolved as follows:
Open the Services file in the C:\WINDOWS\system32\drivers\etc directory at the end of the file
Add a line: 10.200.xxx.xxx sdeserver
Where 10.100.xxx.xxx is the IP address of the Oracle server

Try again and you're successful.

arcsde10.0 for oracle11g Distributed installation tutorial