database shutdown and error in alertlog

Hi all,

Can you please guide me. It has started since two days getting error in alert log. Also databse shutdown by itself at night. Then i have to restart it ever morning since two days: here is the text from Alertlog file:

Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu Jul 22 00:07:20 2010
Doing block recovery for fno: 2 blk: 78
Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use
SVR4 Error: 11: Resource temporarily unavailable
Additional information: 8
Thu Jul 22 00:07:20 2010
LGWR: terminating instance due to error 313
Instance terminated by LGWR, pid = 22648

what is the solution?

thanks

Quote:

---

Originally Posted by midora

Thu Jul 22 00:07:20 2010
Errors in file /LOcation/DBISNTANCE/admin/bdump/DBISNTANCE_lgwr_22648.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log'
ORA-27086: skgfglk: unable to lock file - already in use

---

27086, 00000, "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.

Other instances running on same box?

Either way, ask sysadmin to check status of file /LOcation/DBISNTANCE/oradata/DBISNTANCE_redo02.log

yes there are but that has it's own separat location for the file location!

Quote:

---

Originally Posted by midora

yes there are but that has it's own separat location for the file location!

---

well something is messing with that file, the error is clear

Hi,

I see the stale status on that file.. how can i remove that status!!!!

look at the error

some process has the file open - find that process and sort it out

Quote:

---

Originally Posted by midora

I see the stale status on that file.. how can i remove that status!!!!

---

I would ask Sysadmin for help.