English

Problem: Unable to start an ArcSDE service after installing Service Pack 2 or higher

Description

After installing Service Pack 2 or higher for ArcSDE version 10, the ArcSDE service does not start.

Cause

Listed below are a few potential reasons that might explain why an SDE service may not start after installing SP2 or higher:

• The geodatabase was not upgraded after installing the service pack.
• The SDE admin user password has changed since the creation of the service.
• The geodatabase was upgraded from version 9.x but never authorized for version 10 (Please see Related Information for details about authorizing an ArcSDE geodatabase.)

Solution or Workaround

  1. Use a direct connection in ArcCatalog to upgrade the geodatabases to SP3.

    SQL Server

    Oracle

  2. Delete the existing ArcSDE services (Windows only).
    A. Open a command line window on the SDE machine and type the following:

    Code:
    sc delete <service name>

    B. Repeat step A for all services.

  3. Clean up the ArcSDE services file found in the etc folder under SDEHOME.
    A. Open the ArcSDE services file: SDEHOME\etc\services.sde

    • Windows: C:\Program Files\ArcGIS\ArcSDE\sqlexe\etc\services.sde
    • Unix: $SDEHOME/etc/services.sde

    B. Remove all service entries related to the upgraded geodatabases. Save and close the file.

  4. Clean up the Windows/Unix services file.
    A. Open the services file using Notepad.

    • Windows: C:\Windows\System32\drivers\etc\services
    • Unix: The location of the services file is defined by _PATH_SERVICES in /usr/include/netdb.h. This is usually set to /etc/services.

    B. Remove all service entries related to the upgraded geodatabases. Ensure that there is a carriage return after the last entry in the file. Save and close file.
  5. Run post-installation to create new services.

    SQL Server

    Oracle

Related Information