When trying to open the alert.log dashboard the following error appears:
"Failed to execute queryon host MyHost. Reason : [tail: cannot open input- Profile:SSH Connection Profile {Host = MyHost, Agent = MyAgent. Port = 22, Environment = {} " Query: [${LOCALE} ${sudo} tail -$lines $file_name"]."
In the log file the following error can be found:
ECHO <fb8be857-fbcf-4747-973d-295a8570e581/DB_Oracle/5.7.5.2/DB_Oracle/MyAgent-agent> ERROR [MyAgent-lowPriorityPool-71-[DBO_Alert_Log]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBOReadAlertLogProcessor processor of DBO_Alert_Log collection of MyHost-MyInstance instance.
java.lang.RuntimeException: Failed to execute collection [DBO_Alert_Log], reason=Failed to run query of "MyHost-MyInstance" instance. Query [${LOCALE} ${sudo} tail -$lines $file_name]. Params [{file_name=/my/path/to/diag/rdbms/SID/trace/alert_SID.log, lines=500}]
Make sure that the OS user the Oracle agent is using to connect the monitored machine is able to access the alert.log of the database and is able to execute the "tail" command.
For testing please run the following command (please set the correct path to your alert.log):
tail -20 /my/path/to/diag/rdbms/SID/trace/alert_SID.log
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center