INSTALLATION DOCUMENTS BY RAVI

Saturday, November 18, 2017

Resolution : ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

When we are working with oracle database some times the database may not open with the below errors:

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\DEV_SVCTBL.DBF'














Solution:

To resolve this error issue the below sql commands and try to open the database

1. select name from v$datafile where file#=6;
2. alter database datafile 6 OFFLINE DROP;
3.alter database open;







When we try to open the database again we may get data file error






Repeat this step until all the error data files got dropped
Ones this got resolved we can open the database















5 comments:

  1. I wanted to thank you for this excellent read!! I definitely loved every little bit of it. I have you bookmarked your site to check out the new stuff you post Seattle Locksmith

    ReplyDelete
  2. I admit, I have not been on this web page in a long time... however it was another joy to see It is such an important topic and ignored by so many, even professionals. I thank you to help making people more aware of possible issues. inbraakbeveiliging Nieuwegein

    ReplyDelete
  3. There are different organizations that are making network gadgets that will control a wide range of kinds of locks like locks found in a place of business or clinic. slotenservice-slotenmaker.nl

    ReplyDelete
  4. East london locksmith services is an established 24 hour Hackney locksmith company. Whether you have been locked out, lost your keys or require a lock replaced, call us and we will send out a certified engineer. who will aim to attend within 30 minutes of your call. Hackney Loksmith

    ReplyDelete
  5. Each phase of locking is extraordinary and accompanies its own arrangement of happenings. https://slotenservice-denhaag070.nl/

    ReplyDelete

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...