Is This Content Helpful?
We're glad to know this article was helpful.
After renaming the server on which the database management system (DBMS) resides, the ArcSDE service cannot start.
The ArcSDE service is still referencing the old server name.
On Windows servers, the datasource for the ArcSDE service is stored in the registry. Renaming the datasource leaves this registry key pointing to an invalid datasource.
For Oracle and DB2 DBMSs, the databases themselves are not started until the server name is updated in the tnsnames.ora file (for Oracle) or the Control Center (for DB2).
As mentioned in the previous note, update the server name in the tnsnames.ora file for Oracle. Update the alias for DB2 to point to a new server name. For ArcSDE services on Oracle or DB2, it is the ORACLE_SID or the DB2 alias respectively that is stored in the registry. Updating this information for the DBMS should fix the problem for the ArcSDE service.
To fix this problem for geodatabases in SQL Server or PostgreSQL on Windows, re-create the ArcSDE service.
sdeservice -o delete -d <DBMS> -i <service>