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 |
PLS-00656: field 'string' not available in input argument
DRG-11209: filename for string exceeds maximum length of string
TNS-00114: Internal error- Allocation of addresses not performed
PCC-00146: Illegal value for host option, ignored
ORA-38496: Expression Filter index is not in a valid state
PCC-02399: Illegal CHAR_MAP option value for DBMS=V6. Option ignored.
NZE-28780: invalid data access method specified by the parameter
ORA-01341: LogMiner out-of-memory
ORA-29288: invalid file name
SQL*Loader-00627: Character set conversion graph not available.
DRG-11622: URL store: unknown HTTP error getting string
TNS-02403: Bad alias string or alias not present in tnsnames.ora