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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center