-
Title
OS monitoring fails due to missing security permissions on Linux and Unix hosts -
Description
Messages similar to the following are occuring in the Oracle database agent logs preventing OS monitoring from occurring.
YYYY-MM-DD HH:MM:SS.SSS ECHO
ERROR [br6t.tms.example.com-lowPriorityPool-51-[DBO_OS_General_Network][YYYY-MM-DD HH:MM:SS.SSS]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBOGeneralNetworkProcessor processor of DBO_OS_General_Network collection of DBO-RAC-NODE-thifsp02.tms.example.com-br6t.tms.example.com instance.
java.lang.RuntimeException: Failed to execute collection [DBO_OS_General_Network], reason=Failed to run query of DBO-RAC-NODE-thifsp02.tms.example.com-br6t.tms.example.com instance.
at com.quest.qsi.fason.core.collection.processor.AbstractQueryProcessor.handleError(AbstractQueryProcessor.java:357)
Caused by: java.lang.RuntimeException: Failed to run query of DBO-RAC-NODE-thifsp02.tms.example.com-br6t.tms.example.com instance.
at com.quest.qsi.fason.oracle.common.reader.OracleUnixReader.runQuery(OracleUnixReader.java:99)
Caused by: java.lang.NumberFormatException: For input string: "Ipkts"
at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source)YYYY-MM-DD HH:MM:SS.SSS ECHO
ERROR [br6t.tms.example.com-lowPriorityPool-51-[DBO_OS_General_Process][YYYY-MM-DD HH:MM:SS.SSS]] com.quest.qsi.fason.oracle.collection.processor.DBOInstanceProcessor - Failed to run DBONumberOfCpuProcessor processor of DBO_OS_General_Process collection of DBO-RAC-NODE-thifsp01.tms.example.com-br6t.tms.example.com instance.
java.lang.RuntimeException: Failed to execute collection [DBO_OS_General_Process], reason=Failed to run query of DBO-RAC-NODE-thifsp01.tms.example.com-br6t.tms.example.com instance.
at com.quest.qsi.fason.core.collection.processor.AbstractQueryProcessor.handleError(AbstractQueryProcessor.java: -
Cause
Permissions were not granted at the OS level.
-
Resolution
Please refer to the database cartridge release notes or the Foglight for Databases deployment guide available for download from here for the most current list of required permissions for Oracle monitoring.