English

How To: Create multiple instances for ArcSDE 8.3 or earlier releases

Summary

Occasionally, it may be necessary to have more than one instance of ArcSDE running at the same time on the same machine. Creating multiple instances of ArcSDE is useful for running multiple versions of SDE, maintaining separate development and production instances, and spatially enabling multiple RDBMS instances. Multiple database instances must be used when connecting to Oracle.

Each ArcSDE instance must have its own SDEHOME directory, a unique service (instance) name and a separate port number in the services file. Instructions provided briefly outline how to create multiple instances of ArcSDE. Refer to the specific RDBMS documentation for information on how to create multiple RDBMS instances.

Procedure

For Windows NT:
----------------
1. Copy %SDEHOME% to a new location.

2. Update the new dbinit.sde file with the proper RDBMS connection variables (e.g., ORACLE_SID).

3. Update the %SDEHOME%\etc\services.sde file with the new instance name, port number, and network protocol.

4. Add the service name, port number, and network protocol to the \WINNT\system32\drivers\etc\services file. Make sure the port number selected is not already in use.

5. Delete the contents of the new giomgr.log file.

6. If necessary, update the new giomgr.defs file to specify operating parameters of the new instance.

7. If necessary, update the new dbtune.sde file to specify parameters for creating data in the new instance's database.

8. Make sure the SDEHOME variable is pointing to the correct location for the new ArcSDE instance and run the sdesetup command that is appropriate for your database to create the repository tables in the new database.

9. Create the new ArcSDE service using the 'sdeservice -o create' command.

For UNIX:
---------
1. Create a new home directory for the new instance.

2. Copy $SDEHOME to the new home directory that was just created.

3. Update the new dbinit.sde file with the proper RDBMS connection variables (e.g., ORACLE_SID).

4. Update the $SDEHOME/etc/services.sde file with the new instance name, port number, and network protocol.

5. Add the service name, port number, and network protocol to the /etc/services file. Make sure the port number selected is not already in use.

6. Delete the contents of the new giomgr.log file.

7. If necessary, update the new giomgr.defs file to specify operating parameters of the new instance.

8. If necessary, update the new dbtune.sde file to specify parameters for creating data in the new instance's database.

9. Make sure the SDEHOME variable is pointing to the correct location for the new ArcSDE instance and run the sdesetup command that is appropriate for your database to create the repository tables in the new database.

Note:
When using multiple ArcSDE instances to maintain separate development and production environments, it is necessary to create multiple SDEHOME directories with their own services that connect to their own database or Oracle instance. Creating multiple ArcSDE services from the same SDEHOME directory to connect to one database or Oracle instance causes both ArcSDE services to connect to the same set of ArcSDE repository tables, which does not allow the user to keep the development work separate from the production work.

Related Information