Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27086: skgfglk: unable to lock file - already in use

nawamyOct 4 2010 — edited Oct 4 2010
Hi,

I advance I appreciate your time for assistance.

Thu Sep 30 23:07:08 2010
Errors in file /opt/app/oracle/admin/EDITDATA/bdump/editdata_dbw0_21124.trc:
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/opt/app/oracle/oradata/EDITDATA/users01.dbf'
ORA-27086: skgfglk: unable to lock file - already in use
Linux Error: 11: Resource temporarily unavailable


I am getting this error for last 2-3 days. I need to start up the database manually.

Daily there is crontab schedule which will take the cold backup and startup the database. When I am checking daily morning. DBt is going into MOUNT stage instead of OPEN stage. I have check the script every thing is fine.

Note: This is happening intermetendly. Also is error is happening with different datafiles each time.




Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2010
Added on Oct 4 2010
11 comments
2,336 views