Skip to main content
NetApp Knowledge Base

How to clear NFS locks during network crash or outage for Oracle or other database files

  1. Last updated
  2. Save as PDF
Views:
3,930
Visibility:
Public
Votes:
1
Category:
ontap-9
Specialty:
nas
Last Updated:

Applies to

  • ONTAP 9
  • Stale NLM locks

Description

  • This solution details steps to resolve Oracle or other database hangs due to stale locks 
    • The long term solution is to troubleshoot with Oracle or other appropriate database vendor to properly remove locks on shutdown or crash recovery
  • The purpose of this document is to give a very thorough step-by-step procedure for removing NFS locks from a controller following an event that has disrupted the controller/host network or an event that has resulted in an Oracle or other database being shutdown in a strange manner
    • Such as a UNIX host crash or shutdown while the database is still open
  • Events such as these often result in a hung database or a database that cannot be opened because old locks still exist on the controller-stored data files.
  • Symptoms resolved by the following procedure
    • Oracle database does not respond, appears to be hung, and no error messages generated
    • Oracle database does not open and error messages are generated
    • Database does not respond (hung) 
    • UNIX host crash or shutdown with the database still open
    • Database cannot be opened because old locks still exist on the controller-stored data files 

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.