error starting esri_sde service(1060)

Question

Have a windows 2008 R2 client with SDE client installed. The sde database is on a linux machine running oracle 11g. Followed all the instructions from this article:

http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade_guide/index.html#//00940000000w000000.htm

When I start the service I get the error: error starting esri_sde service(1060)

giomgr_sdesvc has this entry in it:
Tue Feb 21 09:44:26 2012 - ****** Spatial Database I/O Manager ******
Tue Feb 21 09:44:26 2012 - SDE System Startup Initiated . . .
Tue Feb 21 09:44:26 2012 - Validated System Paths.
Tue Feb 21 09:44:26 2012 - SDE IOMGR going into background . . .
Tue Feb 21 09:44:26 2012 - System Parameter table 'SERVER_CONFIG' Read.
Tue Feb 21 09:44:27 2012 - Initialized Shared Memory Segment.
Tue Feb 21 09:44:27 2012 - Validated License.
Tue Feb 21 09:44:27 2012 - IOMGR Process ID (PID):           4700
Tue Feb 21 09:44:27 2012 - Initialized Client Tables.
Tue Feb 21 09:44:27 2012 - Server Validated.
Tue Feb 21 09:44:27 2012 - Unable to initialize sockets for listening (-102).Tue Feb 21 09:44:27 2012 - ALL SDE Servers Stopped.
Tue Feb 21 09:44:28 2012 - ********** SDE System Shutdown **********

the sde log looks good has this entry:
ST_Geometry Schema Owner: (SDE) Type Release: 1007
Instance initialized for ((sde)) . . .

Connected to instance . . .
DBMS Connection established...
RDBMS:     "Oracle"
Instance Name:    "sdesvc"
IOMGR Process ID (PID):           4700

Any ideas?

Jon_D · Answer

Hi Jason,

The following article may be helpful for others that encounter the same error.

HowTo:  Install ArcSDE on a machine that is remote from the Oracle RDBMS
http://support.esri.com/en/knowledgebase/techarticles/detail/23753

There is nothing that should have prevented your earlier service from starting if the correct entries existed within both the '%SDEHOME/etc/service.sde' and '%WINDIR%\system32\drivers\etc\services'

This is similar to the process necessary to create an ArcSDE service on Linux or Unix:If any clients will be connecting to the geodatabase using an ArcSDE service, you must alter the operating system services file and the ArcSDE services.sde file. The services.sde file can be found in the $SDEHOME/etc directory.

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002n000000p4000000

It appears as though you already had the "esri_sde" service assigned in both these files which is why you did not see the error using that service name.  The documentation team has been contacted to include reference to this within the online installation guides as well.

Please note that you can always submit online web-help feedback to our documentation team by clicking on the "Feedback" button in the upper right-hand corner of any page
[ATTACH=CONFIG]12398[/ATTACH]

Thanks.

- Jon

feedback.png

JasonReid · Answer

found and solved the problem.

When creating the service I did:
sdeservice -o create -d ORACLE,ORACLE_ID -p *** -n -i SDE

Because this was a distributed installation I had to delete that service and create it this way:

sdeservice -o create -d ORACLE,ORACLE_ID -p *** -n -i esri_sde

ESRI needs to update this help document to reflect this:

http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_oracle_installation_and_upgrade_guide/index.html#/Creating_an_ArcSDE_service_from_a_remote_Windows_server/009400000066000000/