-
Title
"Error using UTL_FILE to examine alert log" while using Health Check. -
Description
When using Database | Health Check I get the following error message:
! Error using UTL_FILE to examine alert log!
! 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=/oracle/app/oracle/admin/TLE/bdump
! utl_file_dir=*
! 3) alert.log file name is not among the following:
! (if this is the case please inform Quest support)
! alert_TLE.log
! TLEalrt.log -
Resolution
TOAD is hardcoded to look in the default UTL_FILE directory for the alert logs. The workarond is to set utl_file to either of the following:
utl_file_dir=/oracle/app/oracle/admin/dprprd/bdump
or
utl_file_dir=*
Alternatively:
Disable option #6 under the 'Checks and Options' tab of the Database Health Check window.
This issue has been submitted as an enhancement request for future release.