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-01157: cannot identify/lock data file [HELP!PLEASE!!]

869265Oct 12 2011 — edited Oct 12 2011

I'm running Oracle 11gR2. When I tried to start Oracle from sqlplus, I got the following errors:

ORA-01110: data file 8: '/dev/raw/raw8'
ORA-01157: cannot identify/lock data file 8 - see DBWR trace file

I used "shutdown abort" to shutdown the Oracle. I am sure that there were 2 sessions committing changes to the database while I was shutting down the Oracle. Is there anyone know how to deal with this problem?

Great thanks for any help!!

This post has been answered by Hemant K Chitale on Oct 12 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 9 2011

Added on Oct 12 2011

#general-database-discussions

9 comments

9,580 views