nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Schema Locks - Oracle

RamakrishnaBillakanti

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.

Schema.png

タグ付けされた投稿をもっと見る

Accepted answers

All comments

BirajaNayak

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

RamakrishnaBillakanti

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

RamakrishnaBillakanti

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.

User35489

Billakanti,

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

AsrujitSengupta

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

RamakrishnaBillakanti

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

Anonymous User

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.

RamakrishnaBillakanti

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

Anonymous User

Hello,

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

Thanks.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.