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

[JoseSanchez]

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

[ToddBlanchette]

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

[ChristianWells]

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]

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