ORA-01157: cannot identify/lock data file string - see DBWR
trace file
- 1 Answers
- 5917 Views
- I also Faced
- E-Mail Answers
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 |
NZE-28870: Name comparison failure
TNS-12571: TNS:packet writer failure
NNO-00315: server is listening on address string
PCC-02445: USING clause valid only on a PREPAREd dynamic statement
ORA-31610: cannot call this function from a non-master process
PROC-00012: Out of heap memory.
RMAN-06153: validation failed for datafile copy
QSM-01035: a row level security policy exists on this table
ORA-24309: already connected to a server
NNL-00267: Address is string
ORA-28521: no heterogeneous capability information available
LSX-00344: namespace values "~1S" and "~2S" differ
Oracle Errors 
