Select to view content in your preferred language

ArcSDE 10.2 sdemon -o info -I users -s xxxx -i sde:oracle11g:xxxx -p xxxx -u xxxx

4996
3
05-11-2015 05:48 AM
JoseSanchez
Frequent Contributor

Hello everyone,

How can I run the command in arcSDE 10.2.2:

sdemon -o info -I users -s xxxx -i sde:oracle11g:xxxx  -p xxxx  -u xxxx

I get the error message:

ArcSDE Instance sde:oracle11g:dsde5 Registered Server Tasks on s0140404 at Mon M

ay 11 08:46:03 2015

-------------------------------------------------------------------------

Entry for SDE instance not found in services file, Unable to get users

H:\>

this command works on 10.1 and 10.0

thanks

0 Kudos
3 Replies
ToddBlanchette
Frequent Contributor

Hi Jose!

Try using port 5151 for your instance connection through Oracle in the command line and see if that works.

If not, try adding:

esri_sde     5151/tcp          # arcsde for oracle

to the C:/windows/system32/drivers/etc/services file.

-Todd

0 Kudos
ChristianWells
Esri Regular Contributor

Hi Jose,

With a direct connect in SDE command line, you have a few options for the syntax. The -s option is not needed here as this will be grabbed from your Net Service Name (TNS names) or EZ Connect string.

If possible, can you please confirm the following?:

1. Is the 64-bit Oracle 11g client installed on this machine?

2. Are you using EZ connect or TNS names?

3. Is your Oracle listener using a port other than 1521?

If you are using the EZ connect syntax would be similar to the following:

sdemon -o info -I users -i sde:oracle11g:<server>/<SID> -u username -p password

If you are using TNS names the syntax would be similar to the following:

sdemon -o info -I users -i sde:oracle11g:<TNS Name> -u username -p password

BlakeTerhune
MVP Regular Contributor

What do you have that is tying to you sdemon? Now might be a good time to start finding Alternatives to using SDE command line tools in ArcGIS.

Use the Connections and Locks tab within the Geodatabase Administration tool instead of using sdemon –o info –I users/locks

0 Kudos