topic Re: ARCSDE installation in ArcGIS Enterprise Questions

ARCSDE installation

JoshWhite — Fri, 13 Jul 2012 19:32:30 GMT

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.

Re: ARCSDE installation

DerekLaw — Mon, 16 Jul 2012 05:57:28 GMT

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,

Re: ARCSDE installation

BubbaHey — Mon, 16 Jul 2012 11:13:53 GMT

Also, here is some information on services.sde file:

http://resources.arcgis.com/en/help/main/10.1/index.html#/The_services_sde_file/00290000001z000000/

Re: ARCSDE installation

JoshWhite — Tue, 17 Jul 2012 12:23:48 GMT

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

Re: ARCSDE installation

KimPeter — Tue, 17 Jul 2012 15:34:02 GMT

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.

Re: ARCSDE installation

JoshWhite — Mon, 23 Jul 2012 12:44:49 GMT

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:\>

Re: ARCSDE installation

JoshWhite — Mon, 23 Jul 2012 18:13:34 GMT

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?

Re: ARCSDE installation

NAOMIPAUL — Tue, 24 Sep 2013 12:06:11 GMT

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.