Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-01157: cannot identify/lock data file string - see DBWR
trace file
- 1 Answers
- 6672 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-02056: 2PC: string: bad two-phase command number string from string
ORA-00402: database changes by release string cannot be used by release string
ORA-09274: szrfc: insufficient role name buffer space
ORA-06444: ssvpstev: Failed with unexpected error number.
QSM-00786: the name string is invalid for directive string
ORA-32130: invalid offset/index refrenced in Bytes
ORA-06110: NETTCP: message send failure
IMG-00604: unable to access destination image data
ORA-13009: the specified date string is invalid
ORA-01191: file string is already offline - cannot do a normal offline
ORA-00226: operation disallowed while alternate controlfile open
ORA-06526: Unable to load PL/SQL library
Oracle Errors 
