ora-27086 unable to lock file / Alertlog

ORA-27086:unable to lock file – already in use
Cause:the file is locked by another process, indicating that it is currently in use by a database instance.
Action:determine which database instance legitimately owns this file.

If you check the above Picture you will there’s two Pmon process for the same instance, So what you do is the follwing

export ORACLE_SID=swf33
sqlplus / as sysdba
Shutdown immediate;

 After shutdown database another process still up use kill -9 OS command to kill it and startup database.

Thank you
Osama Mustafa

2 thoughts on “ora-27086 unable to lock file / Alertlog

  1. if you are experiencing nfs locks on the NetApp storage use the following linkhttps://wordpress.com/post/ora01157ora01110ora27086aftercrashpreventsdatabase.wordpress.com/17


Leave a Reply to Richy Richy Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com 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.