| unable to lock file - alread y in use [message #120482] |
Fri, 20 May 2005 02:34  |
shreeram.wagh
Messages: 1
Registered: May 2005
|
Junior Member |
|
|
Hi
I am running oracle 9i databse on solaris platform.
While the backup was going I have shutdown the database. When now I am trying to start it , it does not start and gives folowing error
ORA-00202: controlfile: <>/cntrlBD2.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
ALso in ps -ef , I see all the oracle background processes running. But when I try to connect thru sql it says database not available...I cannot restart the server for some reason. Can I kill those background processes by kill -9 command and then restart the database.
Please advice
Regards
|
|
|
|
| Re: unable to lock file - already in use [message #120522 is a reply to message #120482] |
Fri, 20 May 2005 05:50  |
Frank Naude
Messages: 4580
Registered: April 1998
|
Senior Member |
|
|
A reboot would be the easiest. However, if you want to do it manually:
1) Kill all the Oracle background processes (make sure you are on the right machine as this command will kill all Oracle database processes instantly!!!)
$ s -fu oracle | grep ora_ | awk '{print "kill -9 " $2}' | ksh
2) Execute the "ipcs" command (Unix) and "ipcrm -s ..." / "ipcs -m ..." to get rid of all Oracle's semaphores and shared memory segments.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
