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 |
LFI-00114: Append is not allowed with string.
ORA-16518: unable to allocate virtual instance id
PCB-00635: This attribute is only valid for Internal LOB types
ORA-30691: failed to allocate system resources while registering a TCP/IP connection for data traffic detection
RMAN-00575: timeout while trying to write to dbms_pipe
TNS-00093: argument is only supplied to either status or trace_on
ORA-27077: too many files open
ORA-01255: cannot shutdown - file string in recovery manager backup
ORA-06109: NETTCP: message receive failure
KUP-11001: files not from the same unload operation
ORA-02024: database link not found
ORA-39024: wrong schema specified for job