Running Database | Diagnose | Health Check (with alert log options checked) against an 11g database and the following errors are displayed:
! Error using UTL_FILE
! Possible causes:
! 1) You don't have privileges to execute the UTL_FILE package.
! To verify, try executing this pl/sql block in Editor.
! If you don't have the required privileges, it will give an error.
if utl_file.is_open(afile) then
! 2) UTL_FILE_DIR initialization parameter does not include one of these lines:
! utl_file_dir=d:oracleproductdiag dbmssidsid race
! To verify, look under DBA -> Oracle Parameters
! 3) alert.log file name is not among the following:
! (if this is the case please inform Quest support)
! 4) No directory exists in the database for the OS path: d:\oracle\product\diag\ dbms\sid\sid\trace,
! or directory exists but privileges have not been granted for it.
! Toad attempted to use directory: TOAD_BDUMP_DIR. Verify READ/WRITE privileges on this directory.
All 4 possible errors have been checked, and everything appears in place.
Waiting for fix in a future release of Toad for Oracle
This Defect ID only applies to a Health Check run against an 11g database. If these errors are received in a 10g database please ensure all 4 possible problem areas described above are addressed.