Select to view content in your preferred language

ARCSDE installation

2558
7
07-13-2012 12:32 PM
JoshWhite
Honored Contributor
I'm not sure if this is the best forum or if the Geodatabase & SDE forum is best but since its an installation/setup issue, I thought I'd post this here.  I'm going through the Install guide installing sde and come to the Editing service files on Windows step .  I'm able to get rid of the comment code mentioned in Step 2 but I don't understand what Step 3 means. 

3-Open the Windows services file.
4-Copy the service entry you defined in the services.sde file and paste it into the Windows service file.
5-Save and close both services files.


Where is the Windows services file?

This is my first time installing sde so I'm not exactly sure on the exact set up I need.
Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
7 Replies
DerekLaw
Esri Esteemed Contributor
Hi Josh,

Are you installing Enterprise ArcSDE technology manually? What release of ArcSDE are you installing?

Typically the ArcSDE post-install wizard take care of these steps. Please see step #7 in this Esri KnowledgeBase article:

KB #23821 - How To: Manually install ArcSDE for Oracle on Windows


Hope this helps,
0 Kudos
BubbaHey
Deactivated User
0 Kudos
JoshWhite
Honored Contributor
Hi Josh,

Are you installing Enterprise ArcSDE technology manually? What release of ArcSDE are you installing?

Typically the ArcSDE post-install wizard take care of these steps. Please see step #7 in this Esri KnowledgeBase article:

KB #23821 - How To: Manually install ArcSDE for Oracle on Windows


Hope this helps,


I was just going down through the steps in the Install Guide.  It wasn't clear whether this was required or not.  I'll look for the post-install wizard and skip this step.  Esri has GOT to figure out a way to make installing its products easier.  Many parts of the installation have custom or advanced settings that should be something you do optionally after the initial install. 

The release is 10.1
Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
KimPeter
Esri Contributor
The release is 10.1


There is no Post Installation wizard at 10.1 because enterprise geodatabases are created from the ArcGIS client. If you are setting up an ArcSDE application server, you must do it manually after you have created your geodatabase.

You must alter both the ArcSDE services file and the Windows services file to include an entry for the ArcSDE service port number.  Where the Windows services file resides depends on your version of Windows.  On Windows Server 2008, it is in C:\Windows\System32\drivers\etc.
0 Kudos
JoshWhite
Honored Contributor
Well the previous problem is fixed but now I'm still confused please see the following results of pasting the codes into command line.  esri_sde service was successfully created and registered but I don't understand the next set of problems.  So I guess I created the registry key for the service but apparently not create an ADMIN_DATABASE value in the registry for the service??  I was able to start a local ArcSDE service on Windows though.  Wow, I never thought this would be so complicated to set up.  There needs to be a wizard for this setup that automatically creates these entries.  The install for ArcGIS for Server did this for me with less issues.  How do I just get this finished so that I can actually start using sde??
Microsoft Windows [Version 6.0.6002]
Copyright (c) 2006 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator.CACDOMAIN>cd..

C:\Users>cd..

C:\>sdeservice -o create -d SQLSERVER,MYSERVER\SSINSTANCE
Please enter SDE DBA password:
Successfully created and registered esri_sde service

C:\>sdeservice -o register -d SQLSERVER,MYSERVER\SSINSTANCE
You must provide a registry keyword.
You must provide a key value.

ESRI ArcSDE System Service Utility  Mon Jul 23 13:39:16 2012
-------------------------------------------------------------------------
sdeservice -o register   -r <registry_keyword> -v <value>
                         -d <ORACLE|SQLSERVER|
                            DB2|INFORMIX|COVERAGES|POSTGRESQL>
                         -p <SDE_DBA_Password> [-i <service>]

C:\>-r ADMIN_DATABASE -v mygdb -i sdesvc
'-r' is not recognized as an internal or external command,
operable program or batch file.

C:\>
Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
JoshWhite
Honored Contributor
Actually, it appears I have everything done.  I was able to connect to a database that I had previously created in SQL Server when I had tried this in the past.  It needed to be upgraded to 10.1 but it did that without issue and I was able to import a feature class without issue and add it to ArcMap.  Did I miss anything though by not getting through the previous steps?
Josh White, AICP
Principal Planner

City of Arkansas City
0 Kudos
NAOMIPAUL
Regular Contributor
Hi Josh,

Are you installing Enterprise ArcSDE technology manually? What release of ArcSDE are you installing?

Typically the ArcSDE post-install wizard take care of these steps. Please see step #7 in this Esri KnowledgeBase article:

KB #23821 - How To: Manually install ArcSDE for Oracle on Windows


Hope this helps,


Only problem is that ESRI got rid of the Post Install Wizard. Yet, support keeps bringing it up.

I'm looking for clear, percise, install upgrade instructions for SDE 10.1. I can get in  installed but the services will not stay started.
0 Kudos