topic Re: Schema Locks - Oracle in Geodatabase Questions

Schema Locks - Oracle

RamakrishnaBillakanti — Mon, 22 Aug 2016 13:53:48 GMT

Schema Locks Grayed Out for the Data Owner and Geodatabase Administrator. I'm trying to identify all the locks that exist on a feature class using ArcCatalog. Its an Orancle Database on which I running these operations. I've attached the screenshot for more information. Please let me know what might be causing this strange behaviour on the geodatabase. Thanks.

Re: Schema Locks - Oracle

Anonymous User — Mon, 22 Aug 2016 14:08:56 GMT

Hello,

Please make database connection SDE account or Admin account to see locks or kill locks sessions.

Thanks.

Re: Schema Locks - Oracle

RamakrishnaBillakanti — Mon, 22 Aug 2016 14:19:39 GMT

Hi Avinash,

I've already used SDE account as well as Data Owner Account to view the locks. It is not showing, Do I need to grant any permissions on the sys tables

Re: Schema Locks - Oracle

Anonymous User — Mon, 22 Aug 2016 14:26:55 GMT

Hello Rama,

SDE account have permission in SYS DB if not please do that.
SDE account work as master user.

or you can use SDEMON command to view locks

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>]
sdemon

Thanks.

Re: Schema Locks - Oracle

RamakrishnaBillakanti — Mon, 22 Aug 2016 15:09:21 GMT

Avinash, Do I need to run in command prompt ? Is there any documentation for running this. Thank you for helping me in troubleshooting.

Re: Schema Locks - Oracle

AlexanderBrown5 — Mon, 22 Aug 2016 16:46:19 GMT

Rama,

Be aware that if your ArcSDE is 10.3 or newer, the SDE command line has been deprecated.

For running ArcSDE 10.2 and prior:

ArcSDE Administration Command Reference

Some additional information for ArcSDE:

What's new in ArcGIS for Desktop—Help | ArcGIS for Desktop

Alternatives to using SDE command line tools in ArcGIS | Support Services Blog

~Alex

Re: Schema Locks - Oracle

AsrujitSengupta — Mon, 22 Aug 2016 20:05:58 GMT

To disconnect users from a geodatabase in Oracle, the geodatabase administrator must either be added to the DBA role or granted ALTER SYSTEM and SELECT_CATALOG_ROLE privileges.

Manage connections in Oracle—Help | ArcGIS for Desktop

Try granting these permissions to the SDE schema and then check in Geodatabase Administrator window in ArcCatalog

Re: Schema Locks - Oracle

User35489 — Tue, 23 Aug 2016 11:48:20 GMT

Billakanti,

Mention version for Geodatabase/ArcSDE and Oracle database and ArcGIS Client, please.

Re: Schema Locks - Oracle

RamakrishnaBillakanti — Tue, 23 Aug 2016 17:26:26 GMT

Hi ASenGupta-esristaff‌ Thank you for your response, Granting those permission on the schema made locks click able (meaning they are no more grayed out). But still I tried editing a layer and looking for the locks using ArcCatalog, It was suppose to show the schema lock but It didn't. Do you think is there anything I need grant permission on. Thank you again for your help.

Re: Schema Locks - Oracle

RamakrishnaBillakanti — Tue, 23 Aug 2016 17:27:11 GMT

Hi Abdullah Environment is on Oracle 12 C, ArcGIS Desktop 10.4 and Geodatabase Version is also 10.4.

Re: Schema Locks - Oracle

BirajaNayak — Sat, 27 Aug 2016 00:05:11 GMT

Hi Rama,

You got all permission right once you followed Asrujit's suggestion. In Arcatalog, you can use filter to get feature class and it's locks. If you can not see, then close Arccatalog and reopen to try again. Sometimes, Arcatalog cache it out and you may not see update information on the same session.

If you still have issue, then log a tech support call.

Thanks,

Biraja