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!
Thanks for your interest.
ReplyDeleteI 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.
Wow, incredible weblog format! How long have you ever been blogging
ReplyDeletefor? you made blogging look easy. The total glance of your web site is excellent,
let alone the content material!
Thanks!
ReplyDeleteGlade it works fast.
I am working on Nagios+HHVM now.
Hope it could be even faster than the current set.
Its like you read my mind! Yoou appear to know a lot about this,
ReplyDeletelike 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.
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..
ReplyDeleteI will put a VPN router on your home network.
ReplyDeleteMy favorite is pfsense.
Give it a try, you will love it.
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
ReplyDeletebut usually people do not speak about such subjects. To the next!
Best wishes!!
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.
ReplyDeleteWonderful article! We will be linking to this particularly great article on
ReplyDeleteour site. Keep up the good writing.
You actually make it appear really easy along with your presentation but I find
ReplyDeletethis 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!
Hi there to every , for the reason that I am truly eager of reading this weblog's post to bee updated daily.
ReplyDeleteIt contains fastidious data.
I think this is one of the so much vital info for me. And i'm satisfied reading your article.
ReplyDeleteHowever wanna statement on few normal issues, The
site taste is ideal, the articles is truly great : D. Good task, cheers
Very good info. Lucky me I found your blog by accident (stumbleupon).
ReplyDeleteI have bookmarked it for later!
What's up to every one, as I am in fact keen of reading this website's post to be updated on a
ReplyDeleteregular basis. It consists of nice information.
What is the easiest way to copy my WordPress blogs to a new hosting company?
ReplyDeleteI 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..
ReplyDeleteCheck ecommerce magento.
ReplyDeleteIt is a lots of work to bring a ecommerce website.
At least be prepare $2,000 as start.
Go Tools->Export on old server, will download a xml file.
ReplyDeleteThen Tools->Import on the new server.
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.
ReplyDeleteI јust like the νaluable info yοս supply for youг articles.
ReplyDeleteI'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!