Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Get "Error using UTL_FILE..." error running healthcheck & none of the suggestions in the mes
Description
I'm getting the following error when trying to read the alert_<SID>.log file. I have tried all the suggestions listed in the message and none of them helped me resolve the issue.
! 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.
declare afile utl_file.file_type; begin if utl_file.is_open(afile) then null; end if; end;
! 2) UTL_FILE_DIR initialization parameter does not include one of these lines: ! utl_file_dir=/oracle/QR1/saptrace/background ! utl_file_dir=* ! 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) ! alert_QR1.log ! QR1alrt.log ! 4) No directory exists in the database for the OS path: /oracle/QR1/saptrace/background, ! 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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.