Quick Search:
 
 Oracle Database Error: ORA-01157      [Return To Oracle Error Index] Jump to:  
Oracle Error: ORA-01157

Error Description:
Cannot identify/lock data file string - see DBWR trace file

Error 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.


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2025 psoug.org