When navigating to the Alert Log dashboard of a selected DB, the following is seen:
"An error occurred while trying to retrieve data to this screen. If this issue persists, contact Quest Support. More Details."
When the "More Details" is clicked, the following is displayed:
"Failed to execute query on host xxx. Reason : [tail: cannot open ' /patch/log.log' for reasin: Permission Denied..."
Adjust Linux permissions to grant other users access to the alert log file.
Set the correct permissions, for example chmod 644, on the directory where the Oracle alert log is located (location is outlined when the "More Details" is clicked).
For example, modify the permissions to allow read and execute access to all subdirectories up to the alert log file, and read access to the file itself.
sudo chmod o+rx /opt/oracle/diag/rdbms/orcldb/ORCLDB/
sudo chmod o+rx /opt/oracle/diag/rdbms/orcldb/ORCLDB/trace
chmod o+r /opt/oracle/diag/rdbms/orcldb/ORCLDB/trace/alert_ORCLDB.log
