Problem: Unable to start an ArcSDE service after installing Service Pack 2 or higher
After installing Service Pack 2 or higher for ArcSDE version 10, the ArcSDE service does not start.
Listed below are a few potential reasons that might explain why an SDE service may not start after installing SP2 or higher:
• 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
- Use a direct connection in ArcCatalog to upgrade the geodatabases to SP3.
SQL Server• Making a direct connection from ArcGIS Desktop to a geodatabase in SQL Server
• Upgrading an ArcSDE geodatabase in SQL Server
Oracle• Making a direct connection from ArcGIS Desktop to a geodatabase in Oracle
• Upgrading an ArcSDE geodatabase in Oracle
- Delete the existing ArcSDE services (Windows only).A. Open a command line window on the SDE machine and type the following:
sc delete <service name>
B. Repeat step A for all services.
- 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.
- 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.
- Run post-installation to create new services.
Oracle• Creating and starting an ArcSDE service for geodatabases in Oracle on Windows
• Creating a geodatabase in Oracle on Linux or UNIX (Includes information on connecting to SDE using a service.)
- Authorizing ArcSDE geodatabases in SQL Server
- Authorizing ArcSDE geodatabases in Oracle on Linux or UNIX
- Authorizing ArcSDE geodatabases in Oracle on Windows