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.

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 sdeservice2, name the dbinit file dbinit_sdeservice2.sde.
2. Update the new dbinit file with the proper DBMS connection variables (that is, ORACLE_SID).
3. If you want to specify different geodatabase storage information for the second geodatabase, make copies of your giomgr.defs and dbtune.sde files, giving them different names. For example, you could name them giomgr2.defs and dbtune2.sde.
4. Alter the contents of the new copies of the files to include the parameters and values with which you want your second geodatabase to be built. Based on the example given in the previous step, you would be altering giomgr2.defs and dbtune2.sde.
5. Create the geodatabase in the second Oracle database using the Post Installation wizard.
6. Specify the net service name of the second Oracle database on the first User information dialog box.
7. Specify the .dbf file and path for the second database in the SDE user and tablespace information dialog box.
8. Specify your customized dbinit.sde and giomgr.def files on the first ArcSDE configuration files dialog box.
9. Choose the custom dbtune file option on the second ArcSDE configuration files dialog box and specify your customized file.
10. Specify the net service name for the second Oracle database on the second User information dialog box.
11. Specify the service name, port number, password, and Oracle SID for the second Oracle database on the ArcSDE service information dialog box, and be sure to specify a unique service name and port number.

    This step of the wizard adds the new service information to the Windows and ArcSDE services files.