Setting up multiple ArcSDE services on one Windows server

If you have two separate geodatabases on the same server and are using an ArcSDE service, you must have separate ArcSDE services with unique service names and a separate port number in the services files.

The following steps assume you have already created the second geodatabase:

Steps:
  1. Make a copy of your dbinit.sde file, giving it a new name. This name must include the name of the new ArcSDE service. For example, if the new service will be sde2, name the dbinit file dbinit_sde2.sde.
  2. Update the new dbinit file, setting an ORACLE_SID connection variable to point to the Oracle SID of the second database.

    If Oracle is installed on a different server from the ArcSDE application server, set the LOCAL variable to the second database's Oracle SID.

  3. Open the services.sde file and the Windows services file and add an entry for your new service.

    For example, if your new service is sde2 on port 9999, add this entry to both files:

    sde2					9999/tcp

  4. Use the sdeservice command with the create operation to create a service. You will be prompted to provide the password for the database administrator.

    The following example shows creating a service when ArcSDE and the database are installed on the same server. For syntax to use with the create operation when ArcSDE and the database are on separate servers, see Creating an ArcSDE service from a remote Windows server.

    In this example, a service is created for an Oracle database with an SID of orasid2.

    sdeservice -o create -d ORACLE,orasid2 -i sde2
    

    TipTip:

    For more information on the sdeservice and sdemon commands, see the ArcSDE application server installation guide provided with your download or installation media.

  5. Use the sdemon command with the start operation to start the new service.

    sdemon -o start -i sde2
    

    To start a service on a remote computer, see Starting a remote ArcSDE service on Windows.

4/2/2015