Distributed deployment of ArcSDE and Oracle services

1. First, you should install oracle on a separate server and perform dbca to monitor and start the service normally.
2. Install Oracle network software on the SDE server to execute SQL statements on the SDE server to manipulate the remote ORACLE Server. Compared with the SDE server, it is a client of the Oracle server.
3. When installing SDE based on different operating systems, you need to make some adjustments during post. On Windows platforms, You need to manually create the SDE service because post cannot create the SDE service for remote SDE servers.
Sdeservice-o create-D Oracle10g, oracle_sid-I esri_sde-P password-n
Note: The "-n" parameter must be added later "! Sde8.x cannot be deployed in a distributed manner on Windows.

Environment variable settings:

The SDE server allows Oracle network software to find the Oracle service only after the corresponding environment variables are written. In Windows, you need to set sdehome \ etc \ dbinit. SDE, add set local = netservicename, and write it after the SDE service is created. For Unix systems, two_task must be added to environment variables, which is the same as installing SDE on Oracle dual-host systems. Of course, tns_admin is indispensable. When the SDE service is started, the giomgr process reads the variable values in dbinit. SDE, which overwrites the values in. cshrc and. profile.

OK, so the configuration is complete. If you find that the service is still faulty, check the environment variable settings and Oracle network connectivity, and restart the server to solve the problem, if you have Redundant servers, do you want to try it!

Reprinted from: http://www.cnblogs.com/flyingis/archive/2007/10/14/924049.html