RE: Lk issue /control file locked . How to start the database?

Kunwar,

There are a variety of reasons that you can get into a hole that you can’t start the database or interact with it because of cluster ware problems.

The error message you saw can be simple Cluster ware bugs that happen sometimes or if someone removed /tmp/.oracle by cleaning up space this will cause problems with cluster ware.

Do you have root privileges on the server in order to bounce cluster ware and are you allowed to shut down all the databases on the specific server (which will happen when you shut down cluster ware)?      

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Mladen Gogala Sent: Friday, February 12, 2021 10:21 PM To: kunwar singh <krishsingh.111_at_gmail.com> Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: Re: Lk issue /control file locked . How to start the database?  

What OS are you using, what version of database? How are you trying to start it up? From pfile? spfile? What is exactly locking your control files? If you are using an operating system, try fuser or lsof to find that out. If you are using something that resembles an operating system, try using process explorer. If you're not a DBA, how in the world did you find yourself in a position of trying to revive an unresponsive database? Also "no backup of any kind" sounds extremely funny. Try calling Oracle Consulting, they are probably able to revive your database.

On 2/13/21 1:03 AM, kunwar singh wrote:

No, sorry.  

On Sat, Feb 13, 2021 at 12:55 AM Mladen Gogala <gogala.mladen_at_gmail.com <mailto:gogala.mladen_at_gmail.com> > wrote:

Is this some kind of a joke?

On 2/13/21 12:42 AM, kunwar singh wrote:
> $ srvctl status db -d ORCLDB
> ****Unable to retrieve Oracle Clusterware home.
> Start Oracle Clusterware stack and try again.

-- 
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com

-- 

Cheers,
Kunwar

-- 
Mladen Gogala
Database Consultant
https://dbwhisperer.wordpress.com


--
http://www.freelists.org/webpage/oracle-l