-
Title
Alert log viewer ERROR: UTL_FILE failed with "ORA-29283" on RAC environment -
Description
Using TOAD's alert log viewer gets the following error: UTL_FILE failed with ORA-29283 trying to open logs files.
These are the steps taken:1. Select Database | Diagnose | Alert Log Viewer.
2. Select a history length in the Amount to load field.
3. Click Green Triangle. -
Cause
The error
ORA-29283in Oracle indicates an invalid file operation, specifically when the path traverses a symbolic link. This error occurs when Oracle attempts to access a file using a path that includes a symbolic link, and Oracle does not support accessing files through symbolic links for security reasons. -
Resolution
Make sure the user account must have the EXECUTE privilege on Oracle's UTL_File package. The SYS schema has this privilege by default.
To resolve this issue, you should ensure that the file path used in your Oracle operation does not include any symbolic links. Use the actual path to the file instead of any symbolic link path.
Workaround 1
1) Create a DIRECTORY object that points to the folder containing the Oracle alert log and does not include a symbolic link in that path
2) Select that DIRECTORY using "Select File from Database Server
Workaround 2
Use FTP to copy the alert log file to your local workstation, then open it by using the folder icon button beside the green arrow. -
Additional Information
For more assistance please contact your DBA support or Oracle support. This is not a Toad issue.