ORA-01157: cannot identify/lock data file string - see DBWR
trace file
- 1 Answers
- 6077 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 |
PCC-02442: Expecting a value between 1 and 65535 inclusive
ORA-01271: Unable to create new file name for file string
ORA-31502: invalid number supplied for supplemental_processes
NZE-28814: Cannot convert a number in Oracle format to native format.
ORA-32153: Environment not specified
DRG-10103: illegal value for argument: string
ORA-09742: sppst: error during a post.
SQL*Loader-00268: UNRECOVERABLE keyword may be used only in direct path.
ORA-09853: snyRemovePort: bad return code from request.
ORA-06790: TLI Driver: poll failed
ORA-00710: new tablespace name is the same as the old tablespace name
ORA-34276: (MXDCL33) (Precision, Scale) arguments can only be used with a NUMBER variable or dimension.
Oracle Errors 
