 |
database shutdown and error in alertlog |
|
juliet clark
Fri Jul 30, 2010 |
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 |
|
 |
William Hill
Fri Jul 30, 2010 |
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 |
|
|
|
|
Invite Friends
