topic Re: Specify a valid port# for SDE service using '-i' option when installing/upgrading in Data Management Questions

Specify a valid port# for SDE service using '-i' option when installing/upgrading geo

EmadAl-Mousa — Wed, 11 Jan 2012 06:21:42 GMT

Hi,

i am trying to create user schema geodatabase with ArcSDE 10 SP2 and Oracle11G.

the default port for my ArcSDE service is "5161"

whenever i try executing the sdesetup command as the following:

sdesetup -o install -d ORACLE11G -u XXXX -i 5161:XXXX -l authorizationkey.ecp

the error i receive is the following:

Specify a valid port# for SDE service using '-i' option when installing/upgrading geodatabase

can anybody help with this?

do i need to add another entry in "services.sde" file with different port for user schema geodatabase?

Regards,
Emad

Re: Specify a valid port# for SDE service using '-i' option when installing/upgrading

BenLin — Thu, 12 Jan 2012 23:27:16 GMT

Hi Emad,

Couple things we can check here first.

1. Make sure your have a valid ArcSDE service using the port number 5161, that means you can startup the service like:
sdemon -o start -i 5161 -p password

2. Make sure the service entry is present in both $SDEHOME/etc/services.sde file and the system services file. In Windows, check C:\WINDOWS\system32\drivers\etc\services file; in Linux/UNIX, check /etc/services file. You shall have a similar line (only one) using the port 5161, like following:
esri_sde 5161/tcp

3. Run the sdesetup command from the SDEHOME/bin folder, like:
C:\> cd %sdehome%/bin
C:\Program Files\ArcGIS\ArcSDE\ora11gexe\bin> sdesetup -o install -d ORACLE11G -i 5161:test -u test -p password -l authorizationkey.ecp

or

$ cd $SDEHOME/bin
$ ./sdesetup -o install -d ORACLE11G -i 5161:test -u test -p password -l authorizationkey.ecp

Regards,
Ben

Re: Specify a valid port# for SDE service using '-i' option when installing/upgrading

EmadAl-Mousa — Sat, 14 Jan 2012 05:02:40 GMT

Hi Ben,

Thanks for your response. We are hosting our ArcSDE engine on IBM AIX 6.1 Unix Server.

when i execute the commands to start and shutdown (sdemon -o start -i 5161 -p password) the service, it works fine.

from the Unix File System under /etc/service

the entries are pointing to the port 5151 (please check the attached image).

Should i change it to 5161 to match my $SDEHOME/etc/services.sde file entry ?

Thanks,
Emad

Re: Specify a valid port# for SDE service using '-i' option when installing/upgrading

BenLin — Tue, 17 Jan 2012 14:56:52 GMT

Hi Emad,

Yes, the service entry needs to be matched in both $SDEHOME/etc/services.sde file and the /etc/services file.

The 5151 is the default port number for ArcSDE service. Just make sure you have the same entry in both $SDEHOME/etc/services.sde file and the system services file. You can have either: "esri_sde 5161/tcp" or: "esri_sde 5151/tcp" in those two services files, but you cannot have both entries in the same services files.

If you need two ArcSDE services, then you will need two different services' names as following:

esri_sde 5151/tcp
new_esri_sde 5161/tcp

Regards,
Ben

Re: Specify a valid port# for SDE service using '-i' option when installing/upgrading

EmadAl-Mousa — Wed, 18 Jan 2012 01:50:01 GMT

Thanks Ben for Your Support.

Regards,
Emad