Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01157: cannot identify/lock data file string - see DBWR
trace file
- 1 Answers
- 6564 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 |
ORA-09708: soacon: failed to bind socket to port.
ORA-16217: prepare to switchover has not completed
ORA-01506: missing or illegal database name
ORA-00026: missing or invalid session ID
ORA-02440: Create as select with referential constraints not allowed
KUP-11007: conversion error loading table string.string
TNS-01411: Service "string" has number instance(s).
ORA-30190: reserved for future use
ORA-32013: failure in verifying parameters from the restored SPFILE
QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode
PCC-02366: Command line argument MODE=ANSI may not be used with DBMS=V6
ORA-01620: no public threads are available for mounting
Oracle Errors 
