Linux-x86_64 Error 37 No Locks Available
Contents |
No locks available Yesterday, as usual the cron job triggered a datapump export job against a database on a Linux Server. Immediately post running the export job it ora-27086 unable to lock file - already in use control file got failed. When i look into the dump logfile i found below sort ora 27086 unable to lock file already in use expdp of errors. Export: Release 11.2.0.3.0 - Production on Sat Mar 8 05:53:37 2014 Copyright (c) 1982, 2011, Oracle and/or its ora-27086 unable to lock file - already in use rman restore affiliates. All rights reserved. ;;; Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning and Automatic Storage Management options ORA-39000: bad dump file specification ORA-31641: unable to
[errno 37] No Locks Available
create dump file "/oraexp/NTLSNDB/Data_Pump_Export_NTLSNDB_FULL_030814_0553_01.dmp" ORA-27086: unable to lock file - already in use Linux-x86_64 Error: 37: No locks available Additional information: 10 I verified at database level whether the dump directory, its path and the proper read & write privileges are granted on the directory. Yes everything was fine at database end. I believed this could be an issue of nfs mount option at OS level. We ora-27086 expdp are using an NFS shared mount point for all of the servers it needs to get mounted with proper options on each server to get it used by the database. I could see this mount point is mounted properly with recommended options by Oracle. Then i checked the logs at OS level, then i found the issue is related to nfslock services. The nfslock service is not running on this database. this service helps the client to lock a file in the related NFS mount point on the server to create a file and make write operations. >cat messages | grep lockd Mar 8 04:03:31 demoserver kernel: lockd: cannot monitor 10.207.80.179 Mar 8 04:03:31 demoserver kernel: lockd: failed to monitor 10.207.80.179 Mar 8 04:20:27 demoserver kernel: lockd: cannot monitor 10.207.80.179 Mar 8 04:20:27 demoserver kernel: lockd: failed to monitor 10.207.80.179 Further i came to know that t the server got rebooted couple of days ago for a reason, after reboot the nfslock services did not startup automatically. So manually we started the services. Note that If the nfslock services need to get auto start after a reboot then we need to use chkconfig nfslock on. Later the
14 09:34:57 EST 2013 Errors in file /u01/app/oracle/admin/rdmetdev/udump/rdmetdev_ora_6321.trc: ORA-27050: function called with invalid FIB/IOV structure Additional information: 2 ORA-27086: unable ora-00210 ora-00202 ora-27086 to lock file - already in use Linux-x86_64 Error: 37: No locks
Linux-x86_64 Error: 11: Resource Temporarily Unavailable
available Additional information: 10 usually this problem occurred because NFS is Hanged,and can check OS logs to find "statd:
Ora-27086: Unable To Lock File - Already In Use Netapp
server localhost not responding, timed out". 1- Check rpc.stat is working and you can restart again , and you have to Restart NFS Services also Stop : # service nfslock stop# http://shafiulladba.blogspot.com/2014/03/nfs-locking-issue-while-data-pump.html service nfs stop# service portmap stop# umount /proc/fs/nfsd Start : # service portmap start# service nfs start# service nfslock start# mount -t nfsd nfsd /proc/fs/nfsd Please follow the order, also note that when you restart the NFS service the server could hang at most for 1 minute. Finally you should Reboot your server. Thank you Osama Mustafa Posted by Osama Mustafa at http://osamamustafa.blogspot.com/2013/02/ora-27086-unable-to-lock-file-already.html 8:07:00 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest Labels: Linkedin Osama Mustafa, ORA-27086: unable to lock file - already in use, Oracle Osama, Osama, Osama ACE, Osama blog, Osama mustafa, Osama mustafa blog No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Oracle ACE About Me Osama Mustafa Osama Mustafa is a database specialist, Oracle ACE Director , Certified Oracle Professional (10g, 11g), Certified Ethical hacker (Penetration testing), and Sun System Administrator.Osama currently works as an Oracle Instructor in the Middle East. He also works on troubleshooting and the implementation of database projects.He spends his free time on Oracle OTN forums and publishes many articles, including Oracle database articles, in his bloghttp://osamamustafa.blogspot.com. View my complete profile Soical Network Linked In My Twitter My Book oracle penetration testing Blogroll Kevin Closson Kellyn PotVin-Gorman Gokhan Atil Blog HeliFromFinland Blog Archive ► 2016 (27) ► October (6) ► September (2) ► August (4) ► June (1) ► May (3) ► April (5) ► March (1) ► February (1) ► January (4) ► 2015 (71) ► December (3) ► Nov
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! http://www.dba-oracle.com/t_ora_27086_unable_to_lock_file.htm Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson http://www.linuxforums.org/forum/servers/181574-error-linux-x86_64-error-37-no-locks-available.html Blog
ORA-27086 Tips Oracle Database Tips by Burleson Consulting February 15, 2015 Question: I am running a job and I am getting this ORA-27086 error: ORA-27050: function called with invalid FIB/IOV structure unable to Additional information: 2 ORA-27086: unable to lock file - already in use Linux-x86_64 Error: 37: No locks available Additional information: 10 What is the cause of the ORA-27086 error? Answer: The oerr utility shows this for the ORA-27086 error: ORA-27086: unable to lock file - already in use Cause: the file is locked unable to lock by another process, indicating that it is currently in use by a database instance. Action: determine which database instance legitimately owns this file. This is not an Oracle error, it has an external cause an you will want to contact your OS systems administrator. See MOSC Note 1418233.1 titled "Archiving Redo Logs Fails With ORA-19510, ORA-27086 Linux-x86_64 Error: 37: No locks available" 1. As an emergency workaround, this error can usually be remedied by re-booting the server. 2. In Linux and AIX you can fix the error by changing /etc/filesystems. In Linux, the option line, using nolock instead of llock -- LINUX# cat /etc/filesystems. . . option=nolock 3. The ORA-27086 error can also happen when NFS is hung. You can check your OS logs to find "statd: server localhost not responding, timed out".4. Check rpc.stat is working and you can restart again , and you have to Restart NFS Services. Here is how to bounce NFS:Today's Posts Advanced Search Find the answer to your Linux question: Entire Site Articles Downloads Forums Linux Hosting Forum GNU Linux Zone Servers Error - Linux-x86_64 Error: 37: No locks available If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. ** If you are logged in, most ads will not be displayed. ** Linuxforums now supports the Tapatalk app for your mobile device. Results 1 to 2 of 2 Thread: Error - Linux-x86_64 Error: 37: No locks available Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Enjoy an ad free experience by logging in. Not a member yet? Register. 08-10-2011 #1 msachikanta View Profile View Forum Posts Private Message View Articles Just Joined! Join Date Aug 2011 Posts 14 Error - Linux-x86_64 Error: 37: No locks available Hi, While cloning Oracle 10.2.0.5 Database we are getting the below error. Can some one help on this issue. ----------------------------------------------------------------------------------------------------------------------------------------------------------------------- SQL*Plus: Release 10.2.0.5.0 - Production on Sat Aug 6 12:10:08 2011 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. Connected to an idle instance. ORACLE instance shut down. Connected to an idle instance. ORACLE instance started. Total System Global Area 1073741824 bytes Fixed Size 2101672 bytes Variable Size 427822680 bytes Database Buffers 629145600 bytes Redo Buffers 14671872 bytes CREATE CONTROLFILE REUSE SET DATABASE "PMFPCIT" * ERROR at line 1: ORA-01503: CREATE CONTROLFILE failed ORA-00200: control file could not be created ORA-00202: control file: '/oradata2/datafiles/cntrl02.dbf' ORA-27086: unable to lock file - already in use Linux-x86_64 Error: 37: No locks available Additional information: 10 --------------------------------------------------- Regards, Sachikanta Mishra Reply With Quote 08-10-2011 #2 msachikanta View Profile View Forum Posts Private Message View Articles Just Joined! Join Date Aug 2011 Posts 14 Added more points related to the issue. while running "perl adpreclone.pl dbTier".. Reply With Quote Quick Navigation Servers Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums