Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



ORA-01157: cannot identify/lock data file string - see DBWR trace file..

Answer / guest

Cause: The background process was either unable to find one
of the data files or failed to lock it because the file was
already in use. The database will prohibit access to this
file but other files will be unaffected. However the first
instance to open the database will need to access all online
data files. Accompanying error from the operating system
describes why the file could not be identified.

Action: Have operating system make file available to
database. Then either open the database or do ALTER SYSTEM
CHECK DATAFILES.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00100: Unable to allocate memory

1 Answers  


ORA-31421: change table does not exist

1 Answers  


PCC-01017: The SQLCA and a SQLCODE variable cannot both be used

1 Answers  


ORA-12571: TNS:packet writer failure

1 Answers  


DRG-13011: language column must be specified when using the multi lexer

1 Answers  






IMG-00549: invalid pixelOrder specfied

1 Answers  


ORA-25116: invalid block number specified in the DUMP DATAFILE/TEMPFILE command

1 Answers  


ORA-07275: unable to send signal to process

1 Answers  


ORA-30625: method dispatch on NULL SELF argument is disallowed

1 Answers  


TNS-01410: Service "string" has number instances.

1 Answers  


PCC-00004: Mismatched IF/ELSE/ENDIF block at line number in file string

1 Answers  


ORA-08462: raw buffer contains invalid decimal data

1 Answers  






Categories