topic Re: sdemon -o info -I users with Oracle Diret connect in Data Management Questions

sdemon -o info -I users with Oracle Diret connect

JoseSanchez — Mon, 10 Mar 2014 15:02:42 GMT

Hi all

How do I run a sdemon -o info -I users in 10.1/10.2 using Oracle Dierct connect?

Thanks

Re: sdemon -o info -I users with Oracle Diret connect

WilliamCraft — Mon, 10 Mar 2014 15:21:38 GMT

Here's the syntax required:

sdemon -o info -I <{users | users_long | config | stats | locks | vars | instances}>
[-q] {[-i {<service> | <port#> | <direct connection>}]
[-s <server_name>] | [-H <sde_directory>]}
[-u <user_name>] [-p <user_password>] [-D <database_name>]

Here's an 11g example assuming your TNSNAMES.ora file is up to date:

sdemon -o info -I users -i sde:oracle11g:DATABASENAME -s SERVERNAME -u sde -p password -D DATABASENAME@password

Re: sdemon -o info -I users with Oracle Diret connect

EmadAl-Mousa — Mon, 10 Mar 2014 15:24:11 GMT

if you are using direct-connect, you can connect using "sde" user account through ArcCatalog and check the list of connections hitting your geodatabase (which is equivalent to sdemon -o info I users command).

sdemon -o info -I users ------> is SDE command line that can be used if you install the ArcSDE binary on your database server OR install ArcSDE for windows platform on your local machine.

Re: sdemon -o info -I users with Oracle Diret connect

VinceAngelo — Mon, 10 Mar 2014 15:54:08 GMT

The 'sdemon' utility communicates with the application server daemon. If you're not
using an application server, you should use the Geodatabase Administation ArcGIS tool
that access the geodatabase system tables directly.

- V

Re: sdemon -o info -I users with Oracle Diret connect

JoseSanchez — Mon, 10 Mar 2014 16:06:28 GMT

Hi all,

I am getting the following error message "Entry for SDE instance not found in services file, Unable to get users"

Re: sdemon -o info -I users with Oracle Diret connect

WilliamCraft — Mon, 10 Mar 2014 16:10:32 GMT

Hi all,

I am getting the following error message "Entry for SDE instance not found in services file, Unable to get users"

How about telling us which version of Oracle you're running. Are you running the SDEMON command from the database server directly or from a client machine? You should heed Vince's and Emad's advice if you're not using the ArcSDE application service altogether. My post above was simply to provide the syntax that would help from a direct connect standpoint.

Re: sdemon -o info -I users with Oracle Diret connect

JoseSanchez — Mon, 10 Mar 2014 16:16:51 GMT

Hi

I am using Oracle Client 11G and ArcGIs 10.2 or 10.1. I am runiing SDE commands from my workstation

when I type:
C:\>sdemon -o info -I users -s <server name> -i <service number> It works fine
ArcSDE Instance 5192 Registered Server Tasks on s0140404 at Mon Mar 10 13:12:06
2014
-------------------------------------------------------------------------
S-ID User Host:OS Started

but when I type the same command with an oracle direct connection, it does not work and shows the message "Entry for SDE instance not found in services file, Unable to get users"

C:\> sdemon -o info -I users -s <server name> -i sde:oracle11g:<instance name>

Re: sdemon -o info -I users with Oracle Diret connect

WilliamCraft — Mon, 10 Mar 2014 16:58:43 GMT

My apology; the post I made above is wrong and I think this is really what Vince was saying above. Using direct connect syntax with the SDEMON command will not work because that would mean you are trying to use the ArcSDE service daemon to talk directly to the database. I don't believe it is designed to work this way, though other SDE commands do accept the direct connect syntax. Alternatively, you can use SQL to query the PROCESS_INFORMATION ArcSDE system table to obtain information about your Oracle user-schema geodatabase or you can use the tools within ArcCatalog as suggested by Vince and Emad.

Re: sdemon -o info -I users with Oracle Diret connect

VinceAngelo — Mon, 10 Mar 2014 17:27:18 GMT

I just used a direct connect syntax to connect to a PostgreSQL database with 'sdemon',
so it is possible.

You will have to use the correct 10.1+ syntax for the database:

SDEHOME must be defined for an install with the appropriate drivers

PATH must include SDEHOME/bin and the appropriate 64-bit database install

Use '-i sde:<dbkeyword>:<databaseref_and_opts>', with '-u' and -p' flags

No '-s' parameter (it's ignored)

Specify the correct database ('-D') if non-Oracle

Remember that your Direct Connect will be reflected in the connection list.

And keep in mind that both 'sdemon' and the application server are deprecated
at 10.2, so this is a short-term fix.

- V

Re: sdemon -o info -I users with Oracle Diret connect

JoseSanchez — Mon, 10 Mar 2014 18:39:24 GMT

Currently I can run:

C:\>sdemon -o info -I users -s <server name> -i <service number>
ArcSDE Instance 5192 Registered Server Tasks on s0140404 at Mon Mar 10 13:12:06
2014
-------------------------------------------------------------------------
S-ID User Host:OS Started

But using the Geodatabase Administration dialog box with a regular user that is schema owner but not SDE owner I can not see the "Connections" tab.

Re: sdemon -o info -I users with Oracle Diret connect

VinceAngelo — Mon, 10 Mar 2014 20:05:38 GMT

The 'sdemon' on the port runs with SDE privileges; if you want the tool to do otherwise
you'll want to take it up in ideas.esri.com or the "Alternatives" sticky thread.

- V

Re: sdemon -o info -I users with Oracle Diret connect

EmadAl-Mousa — Tue, 11 Mar 2014 02:42:10 GMT

Currently I can run:

C:\>sdemon -o info -I users -s <server name> -i <service number>
ArcSDE Instance 5192 Registered Server Tasks on s0140404 at Mon Mar 10 13:12:06
2014
-------------------------------------------------------------------------
S-ID User Host:OS Started

But using the Geodatabase Administration dialog box with a regular user that is schema owner but not SDE owner I can not see the "Connections" tab.

as vince mentioned, "SDE" user requires more permissions and privileges then any other Oracle user, because "SDE" administer's the Geodatabase. i don't think other users should have the privilege to view connections hitting the geodatabase.

Re: sdemon -o info -I users with Oracle Diret connect

JoseSanchez — Tue, 11 Mar 2014 12:32:09 GMT

The old way works fine for me

C:\>sdemon -o info -I users -s <server name> -i <service number>

I disagree with the idea that only SDE should have access to the list of users that are connected.

We are not SDE administrators but we run the command "sdemon -o info -I users" from time to time to check who is connected and for example see the number of connections when ArcGIS runs slow.

Re: sdemon -o info -I users with Oracle Diret connect

VinceAngelo — Tue, 11 Mar 2014 15:44:08 GMT

The point is that you won't be able to use 'sdemon' after 10.2.x, with or without a
Direct Connect on the command line, because it won't exist. If you have requirements
for non-privileged users to be using privileged tools, you should be voicing them to Esri
in an official channel (Ideas, marketing office,...), not just as a post in the User Forums.

- V