Sunday, January 13, 2013

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
export ORACLE_HOME=
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 comments:

  1. I found so many interesting stuff in your blog especially its discussion.
    Serrurier d'Evry

    ReplyDelete
  2. if you are experiencing nfs locks on the NetApp storage use the following link
    https://wordpress.com/post/ora01157ora01110ora27086aftercrashpreventsdatabase.wordpress.com/17

    ReplyDelete