Administration Utility Error

Question

Good Day Guys,

When i tried to run the command SDELAYER
SDELAYER -O DESCRIBE_LONG
it throughs an error

"
[sde@LinuxServer etc]$ sdelayer -o describe_long

Error: SDE not running on server (-101).
Error: Cannot get configuration information
"

Where my service is up and running. I tried restarting the ArcSDE service, it did not worked out...

My Environment: Oracle 11.2.0.3, RHEL6, ArcSDE 10.1(SP1)

Please look into this issue...

Thanks
-Abdullah Saleh

VinceAngelo · Answer

Best practice is to forget the SDE user exists.  It should not be used to get layer
properties -- That's the job of the table owner or a browse user to whom SELECT
access has been granted.  If you use the SDE user casually, there will be a moment
when you regret it; hopefully it won't involve a complete database restore to fix.

- V

User35489 · Answer

I can't think of a single reason why that command should ever be run as user SDE.
The SDE user should be reserved for ArcSDE instance administration.  The SDE
user should not ever own spatial data (treat it like a restricted admin account).

- V

I too agree with you, Vince...
Actually the command is run by the SDE User, but the layer is owned by another user. It was just to show the example. Actual command looks like this

$ sdelayer -o describe_long -i 5151 -l LayerOwner.LayerName,ColumnName -u sde -s ServerName

Thanks for your inputs.
Regards
-AS

VinceAngelo · Answer

I can't think of a single reason why that command should ever be run as user SDE.
The SDE user should be reserved for ArcSDE instance administration.  The SDE
user should not ever own spatial data (treat it like a restricted admin account).

- V