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:
The error ORA-29283 in 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.
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.
