Posted in Netapp

ora-27086 unable to lock file already in use netapp nfs

So….the server crashed and after reboot I got something like this:

Wed DEC 04 22:51:55 EST 2013
ORA-00210: cannot OPEN the specified control file
ORA-00202: control file: '/path/control01.ctl'
ORA-27086: unable TO LOCK file - already IN USE
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: 8
Wed DEC 04 22:51:55 EST 2013
ORA-205 signalled during: ALTER DATABASE   MOUNT...

This is a classic symptom of a Netapp problem, which likes to hold file locks open on NFS mounts.
There is a standard procedure for clearing those locks; see, for instance, document 429912.1 on Metalink.

As root on the NetApp, from the prompt:

priv set advanced
sm_mon -l 
# to check where are the locks do this:
lock status -h <DB_SERVER>
# to break the locks do this:
lock break -h <DB_SERVER>
Advertisements

Author:

I am an Oracle DBA with experience in Maximum Availability technology such as RAC, Data Guard, Grid Control and ASM. I worked with version 9i through 12c on a number of operating systems. Next to that I have an extensive experience with PL/SQL, Oracle eBusiness Suite and shell scripting. Specialties: Oracle RAC & ASM (Configuration/Monitoring/Tuning) Oracle Data Guard (Configuration/Monitoring/Tuning) EM12c (Installation / troubleshooting) SQL & PLSQL *nix Shell scripting

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.