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
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
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
ReplyDeleteI 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
ReplyDeleteThere 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
ReplyDeleteEast 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
ReplyDeleteEach phase of locking is extraordinary and accompanies its own arrangement of happenings. https://slotenservice-denhaag070.nl/
ReplyDelete