-
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
-
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
Last edited by PAVB; 07-22-2010 at 05:21 PM.
Reason: typo
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
yes there are but that has it's own separat location for the file location!
-
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
-
Originally Posted by midora
I see the stale status on that file.. how can i remove that status!!!!
I would ask Sysadmin for help.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|