The following UTL_FILE error may occur when using the Health Check feature under the DBA Menu of TOAD when connected to a database that is lower than Oracle 9i:
! Error using UTL_FILE
! Possible causes:
! 1) You don't have privileges to execute the UTL_FILE package.
! 2) UTL_FILE_DIR initialization parameter does not include one of these lines:
! utl_file_dir=D:\oracle\admin\SID\bdump
! utl_file_dir=*
! 3) alert.log file name is not among the following:
! (if this is the case please inform Quest support)
! alert_SID.log
! SIDalrt.log
It may still result even though the above three steps have been resolved.
WORKAROUND:
Uncheck options 6, 7, 8 and 9 from the "Checks and Options" tab of the Health Check.
This is the only workaround available as TOAD queries new 9i parameters in the UTL_FILE package. These new parameters that we utilize do not exist in any UTL_FILE package that is pre Oracle 9i
STATUS:
Issue fixed in version 9.0.1.8. The latest version of Toad for Oracle can be downloaded here .
