Configuration of direct connection to Oracle database through SDE

In useSDE ServiceConnectionOracle DatabaseTo avoid faults when there are many SDE users connected, SDE provides a direct connection to Oracle, that is, the connection through Oracle. This article mainly introduces some settings for SDE to directly connect to the Oracle database. Next we will introduce it.

Advantages of direct connection:

1) do not manage the ArcSDE service.

Directly connect to the data warehouse without managing the arcsdeservice, without installing the configuration and Starting Process giomgr.exe.

2) provide more options for Scalable systems.

The direct connection architecture migrates the functions of the ArcSDE component to the desktop for execution, removes the ArcSDE load on the server end, releases more resources for the DBMS, and provides better scalability for the database server.

3) direct connection is faster.

Directly connect to the client for faster processing than on the server. Compared with the processing on the client, the server must simultaneously process requests from many clients, and then transmit the computing results to the client over the network.

Prerequisites for direct connection:

If it is Oracle and the client directly connects to the server database, the Oracle client program must be installed and configured. Install the oracle client and configure the connection under Net Manager.

Directly Connected parameter configuration:

Oracle: Set service, username, and password.

Service: sde @ oracle10g (or oracle9i ).

Username: username for example: sde ).

Password: password @ name of the oracle client connection service (for example, sde @ localhost: 1521/orcl ).

SQLServer: Set Service, Database, username, and password.

Service: sde: sqlserver: IP (for example, sde: sqlserver: 127.0.0.1 ).

Database: sde database Name (for example, sde ).

Username: username (for example, sde ).

Password: password (for example, sde ).

The configuration of direct connection to the Oracle database of the SDE service is introduced here. I hope it will be helpful to you.