Don't panic!

  

Cry about...
Oracle Troubleshooting

DBV-00100: Specified FILE (XXXX) not accessible

Symptom:

Using the verification tool ‘dbverfNN’ produces the error:

DBV-00100: Specified FILE (XXXX) not accessible

where ‘XXXX’ is the name of the file that ‘dbverf’ was invoked on.

Possible Causes and Remedies

  1. The file does not exist or was incorrectly specified. Check that the specified file exists.
  2. The datafile to be verified must end with ‘.dbf’. Try renaming the file (be careful, the file must be renamed and Oracle informed that it has been renamed).
  3. The file is in use, and is therefore locked and so the utility cannot open it. Shutdown Oracle and try again. (Possibly NT only.)
  4. If the database has been shutdown then it is possible that that Oracle service has the file locked. Try stopping the service ‘OracleService<SID>’. (NT only.)

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.