topic Re: Remove Orphaned Geodatabase Locks in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785838#M1793 <HTML><HEAD></HEAD><BODY><P>Which user are you connected with while trying to disconnect? It seems from the screenshot that the user doesn't have permission to disconnect.</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">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</SPAN></P></BLOCKQUOTE><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/manage-connections-oracle.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/manage-connections-oracle.htm">Manage connections to Oracle—Help | ArcGIS Desktop</A>&nbsp;</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/geodatabase-administrator-oracle.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/geodatabase-administrator-oracle.htm">The geodatabase administrator in Oracle—Help | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Tue, 11 Sep 2018 16:24:21 GMT Asrujit_SenGupta 2018-09-11T16:24:21Z Remove Orphaned Geodatabase Locks https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785837#M1792 <HTML><HEAD></HEAD><BODY><P>How does one go about removing an orphaned lock on a feature class?&nbsp; I've reviewed the geodatabase administration information which suggested the following.</P><P></P><P>Right-click on the schema,&nbsp;select&nbsp;<STRONG>Geodatabase Administration &gt; Disconnect User</STRONG>.<STRONG>&nbsp;</STRONG> However,&nbsp;it causes this error.</P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/421618_pastedImage_1.png" /></P><P></P><P>Any suggestions out there?</P><P></P><P>Todd</P></BODY></HTML> Tue, 11 Sep 2018 16:17:55 GMT https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785837#M1792 ToddMcNeil2 2018-09-11T16:17:55Z Re: Remove Orphaned Geodatabase Locks https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785838#M1793 <HTML><HEAD></HEAD><BODY><P>Which user are you connected with while trying to disconnect? It seems from the screenshot that the user doesn't have permission to disconnect.</P><P></P><BLOCKQUOTE class="jive_macro_quote jive-quote jive_text_macro"><P><SPAN style="color: #4d4d4d; background-color: #fefefe;">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</SPAN></P></BLOCKQUOTE><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/manage-connections-oracle.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/manage-connections-oracle.htm">Manage connections to Oracle—Help | ArcGIS Desktop</A>&nbsp;</P><P></P><P><A class="link-titled" href="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/geodatabase-administrator-oracle.htm" title="http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/geodatabase-administrator-oracle.htm">The geodatabase administrator in Oracle—Help | ArcGIS Desktop</A>&nbsp;</P></BODY></HTML> Tue, 11 Sep 2018 16:24:21 GMT https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785838#M1793 Asrujit_SenGupta 2018-09-11T16:24:21Z Re: Remove Orphaned Geodatabase Locks https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785839#M1794 <HTML><HEAD></HEAD><BODY><P>That makes sense.&nbsp; I'll check with my DBA administrators to see if I have an account with those privileges.&nbsp; If I don't, I'll have one created.</P></BODY></HTML> Tue, 11 Sep 2018 16:38:36 GMT https://community.esri.com/t5/geodatabase-questions/remove-orphaned-geodatabase-locks/m-p/785839#M1794 ToddMcNeil2 2018-09-11T16:38:36Z