Wednesday, December 4, 2013

ORA-27086: unable to lock file - already in use Netapp NFS

My 10.2 database crashed suddenly.
Can't login by # sqlplus / as sysdba
Can't shutdown it

I have to reboot the server.

Got error after OS is back:


Wed Dec 04 22:51:55 EST 2013
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/oracle_drives/oracle_sys/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.

ORA-01157 ORA-01110 ORA-27086 after crash prevents database from opening (Doc ID 429912.1)
Modified: 01-Mar-2013

As root on the NetApp, from the prompt:

priv set advanced
lock status -h
sm_mon -l
lock status -h


Thanks Team!!!
I am able to bring it back on line after that.

This Server changed the Hostname about 6 months ago.
The Netapp promtp still shows the old Hostname.
That could be the reason.

Reference:https://forums.oracle.com/thread/653757

Please Notice part of the reference I don't agree with:
Do not copy control*.ctl files before you know what are you doing.
In my case, I did not touch any control or data file.
Only restart the Oracle instance several times.

Best Luck!

28 comments:

  1. Hello this is somewhat of off topic but I was wanting to know if blogs use WYSIWYG editors or if
    you have to manually code with HTML. I'm starting a
    blog soon but have no coding experience so I wanted to get advice from someone with experience.
    Any help would be greatly appreciated!

    ReplyDelete
  2. Pretty! This has been an incredibly wonderful article.
    Thanks for supplying this information.

    ReplyDelete
  3. You could definitely see your skills within the work you write.
    The world hopes for more passionate writers
    like you who are not afraid to mention how they believe.

    All the time go after your heart.

    ReplyDelete
  4. I’m not that much of a internet reader to be honest but your blogs really nice, keep it
    up! I'll go ahead and bookmark your website to come back in the future.
    All the best

    ReplyDelete
  5. Thanks for your interest.
    I know 0 of HTML, and no idea what is WYS or WYG.

    I use wordpress to build my own blog.
    Easy to use and lots of options.

    Let me know if you need any help.

    ReplyDelete
  6. Wow, incredible weblog format! How long have you ever been blogging
    for? you made blogging look easy. The total glance of your web site is excellent,
    let alone the content material!

    ReplyDelete
  7. Great blog here! Also your site lots up fast!
    What host are you the usage of? Can I am getting your associate
    hyperlink on your host? I want my web site loaded up as fast as yours lol

    ReplyDelete
  8. Thanks!
    Glade it works fast.
    I am working on Nagios+HHVM now.
    Hope it could be even faster than the current set.

    ReplyDelete
  9. I think this is one of the most significant information
    for me. And i'm glad reading your article. But should remark on
    few general things, The website style is ideal,
    the articles is really great : D. Good job, cheers

    ReplyDelete
  10. Its like you read my mind! Yoou appear to know a lot about this,
    like youu wrote the bolok in it or something. I think that you can do with a
    few pics to drive the message home a little bit, buut other than that, this is magnificent
    blog. A fantastic read. I will definitely be back.

    ReplyDelete
  11. My home computer is hooked up to a router. I would like to have access to my home computer's webcam through my work computer. . My home computer is hooked up through a DSL modem and is always on.. My work computer obviously has access to the Internet..

    ReplyDelete
  12. I will put a VPN router on your home network.
    My favorite is pfsense.
    Give it a try, you will love it.

    ReplyDelete
  13. A motivating discussion is worth comment. I do believe that you need to publish more on this issue, it may not be a taboo subject
    but usually people do not speak about such subjects. To the next!

    Best wishes!!

    ReplyDelete
  14. Hi it's me, I am also visiting this web page regularly, this website is genuinely good and the viewers are genuinely sharing fastidious thoughts.

    ReplyDelete
  15. Wonderful article! We will be linking to this particularly great article on
    our site. Keep up the good writing.

    ReplyDelete
  16. You actually make it appear really easy along with your presentation but I find
    this topic to be really one thing which I think I would never
    understand. It sort of feels too complicated and very wide for me.

    I am taking a look forward in your next publish, I'll
    try to get the hang of it!

    ReplyDelete
  17. Hi there to every , for the reason that I am truly eager of reading this weblog's post to bee updated daily.
    It contains fastidious data.

    ReplyDelete
  18. I think this is one of the so much vital info for me. And i'm satisfied reading your article.

    However wanna statement on few normal issues, The
    site taste is ideal, the articles is truly great : D. Good task, cheers

    ReplyDelete
  19. Very good info. Lucky me I found your blog by accident (stumbleupon).
    I have bookmarked it for later!

    ReplyDelete
  20. What's up to every one, as I am in fact keen of reading this website's post to be updated on a
    regular basis. It consists of nice information.

    ReplyDelete
  21. What is the easiest way to copy my WordPress blogs to a new hosting company?

    ReplyDelete
  22. I want to make my own website to sell things but I have no idea where to start.. I don't no what websites to go on, or how much it will be (or if there's any way i can do it for free?). Can someone give me as much information as possible and a website where i can start please?. I need as much help as possible..

    ReplyDelete
  23. Check ecommerce magento.
    It is a lots of work to bring a ecommerce website.
    At least be prepare $2,000 as start.

    ReplyDelete
  24. Go Tools->Export on old server, will download a xml file.
    Then Tools->Import on the new server.

    ReplyDelete
  25. hello everyone. I am planning to start a website with my partner in Australia. But now, later, we get know that a website with the same concept is already exist in UK and they have patent themselves. so does this can cause us a problem. second thing is how we can set the term and conditions and privacy policy. I would be very grateful for your response. thank you.

    ReplyDelete
  26. I јust like the νaluable info yοս supply for youг articles.
    I'll bookmark your աeblog and test again right here reǥularly.
    I'm slighly certai Ӏ will be tolod a lot of new stuff right right here!
    Goooɗ luck for the following!

    ReplyDelete
  27. Aw, this was an incredibly good post. Spending some time and
    actual effort to make a top notch article…
    but what can I say… I procrastinate a whole lot and never manage to get
    nearly anything done.

    ReplyDelete
  28. I feel that is one of the most significant information for me.
    And i am satisfied reading your article. However wanna remark on few basic
    things, The site style is ideal, the articles is in point of fact nice :
    D. Excellent process, cheers

    ReplyDelete