Restituisci
-
Titolo
Sudo "command not found" in Oracle agent log -
Descrizione
When monitoring an Oracle instance using sudo, commands are not found. An error similar to the following is printed in the database agent log file.
ERROR [HOSTNAME-INSTANCE-lowPriorityPool-29216-[DBO_Usability][2019/06/27 11:17:35]] com.quest.qsi.fason.oracle.core.usability.OracleUnixUsabilityOSReader - Failed to execute Usability OS script on instance : [HOSTNAME-INSTANCE] . Failed to run query of "HOSTNAME-INSTANCE" instance. Query [#${LOCALE} ${sudo} ps -ef | ${sudo} grep -iw ora_pmon_$instance_name | ${sudo} grep -vc grep]. Params [{instance_name=INSTANCE}]Caused by: com.quest.qsi.fason.framework.connections.common.exceptions.FrameworkQueryException: bash: line 14: ps: command not foundbash: line 14: grep: command not foundbash: line 14: grep: command not found- Profile:SSH Connection Profile {Host = HOSTNAME, Agent = HOSTNAME-INSTANCE, Port = 22, Environment = {PATH=/usr/bin/sudo}}Running the same sudo command by logging into the host and using the Foglight monitoring id works successfully. -
Causa
When the OS user works from the command line using sudo but not in the agent, then the OS users might not have the path to the sudo binary in the $PATH variable. -
Risoluzione
Add a PATH for the sudo command to use- Navigate to Administration | Agents | Agent Status
- Select the Oracle database agent
- Edit the properties for the agent
- Click the link to modify the private properties for the agent
- Scroll down to OS Monitored Connection Profile (Unix)
- In "Environment Variables" add a row:
Name = PATH, value = <full path to sudo binary>. - Save the changes
- Return to the Agent Status page
- Deactivate the Oracle agent
- Activate the Oracle agent
The default path for linux should usually be /usr/bin/sudo, but for all unix, or even some customized linux distributions, it could really be anywhere (for example /usr/local/bin/sudo, or even /opt/bin/sudo, or /srv/bin/sudo, etc.)Assuming it is in the PATH—which it should be— then users can discover it by usingsudocmd=`which sudo`