ArcSDE service entry 1

ArcSDEProgramService Introduction: ArcSDE is an important "path" between spatial data and GIS programs. It is a middleware, it can be used to associate ArcGIS and other programs with common relational database systems as a geographical database. These relational databases include both access databases and Distributed DBMS similar to Oracle and sqlserver; at the same time, the ArcSDE for coverages system can also access file-based data such as coverage, shapefile, and arcsotrm in read-only mode.

ArcSDE is a C/S component. It provides two data connection architectures, namely, two-layer and three-layer models. Generally, we use three-layer architecture. If you need to use the former, you can select "generate a direct connection" in arccatalog, which is a data server that directly accesses DBMS through ODBC rather than ArcSDE.

The sdemon command allows the Administrator to manage and monitor the ArcSDE service. After the SDE service is started, a giomgr SDE server process always exists, listening for connection requests (server name and port) verify the connection (password and user), assign an independent gsrvr process to each successful connection, and gsrvr is responsible for communication between the client and the server (using the same server name and port ).

ArcSDE is a client/server component. It has several attributes that need attention:
1. The home directory is a recorded path and becomes sdehome. This directory contains executable files, configuration files, and dynamic shared libraries.
2. two processes: giomgr and gsrvr (as before). When we connect to the SDE database, the giomgr Service is responsible for the entire connection process, such as searching for databases and ports, and querying the SDE In the DBMS. whether the server_config table has a license record.
3. Because SDE uses the TCP/IP protocol, server names and ports play an important role in communication. After the service is created, the service name and port number are stored in the services file "C: \ winnt \ system32 \ drivers \ etc. It has two forms: Service name: Port, IP: port.
4. The configuration parameters are saved in a table named SDE. server_config. The default parameter file is giomgr. defs, which is stored in the ETC folder in sdehome.

Installing the ArcSDE Application Server is a simple task. However, if you are using a Windows system, you only need to do two things: whether your license file is still valid; restart the operating system.

How to start the SDE service:
(1). Use the normal service to start the program
(2 ). use the command line method, such as sdemon-o start-p sde parameter configuration: the parameters of the SDE service can be modified. In this process, you can modify the table or service in the database. sde Or dbinit. SDE files, both of which are saved in the ETC folder in sdehome.

For an SDE service, the method that an external program contacts is through the TCP/IP protocol. Therefore, by default, when <sdehome> \ ora9iexe \ etc \ service is enabled. SDE file, we will find the followingCode:
Esri_sde 5151/tcp # ArcSDE 9.0 for Oracle9i
This is the port number of the SDE service named esri_sde. When sdemon-o start-p sde is executed, the system will look for the parameters of this file to see if they match. Verify the password and user if the Password Matches.

Multiple SDE services can exist on one machine at the same time. These service names are different and the ports used are different, but their parameters are stored in the service. SDE file, such as esri_sde2 5152/tcp # ArcSDE 9.0 for Oracle9i

The SDE service must start with dbinit. the SDE file reads some system environment variables to obtain necessary relational database information, such as: # Oracle SID for service esri_sde. the statement above set oracle_sid = SDE specifies the Oracle Data Warehouse routine used by the SDE service. Run the following command to obtain all the parameters: sdemon-O Info-I config. You can also open the SDE. server_config table to view the specific parameters.

Server Management: Server Management includes service start, pause, and close operations. On Windows, services are started and closed, and routines are closed visually, the following describes how to use the command line:
1. start a remote SDE service sdemon-o start-P mypassword-s service-I ArcSDE. In the above sentence,-P is the password and-S is the remote machine name, -I is the SDE service name
2. suspend a service sdemon-O pause-P mypassword
3. restart sdemon-O resume-P mypassword
4. disable a giomgr process cd % sdehome % \ tools killp 100 (100 is the process number) Do you really want to kill process with PID 100 (y/n )? Y
5. close a service sdemon-O shutdown-P mypassword
6. close all user sessions sdemon-o kill-t all
if you forget the command, you can type sdemon -? To obtain information