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

[EmadAl-Mousa]

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

[BenLin]

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

[EmadAl-Mousa]

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

[BenLin]

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

[EmadAl-Mousa]

Thanks Ben for Your Support.

Regards,
Emad