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

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

JoseSanchez — Mon, 11 May 2015 12:48:13 GMT

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

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

ToddBlanchette — Mon, 11 May 2015 13:44:55 GMT

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

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

ChristianWells — Mon, 11 May 2015 14:34:37 GMT

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

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

BlakeTerhune — Thu, 04 Jun 2015 21:15:24 GMT

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