Restituisci
-
Titolo
Failed to execute Usability OS script on instance : [RAC name] . Failed to run query -
Descrizione
No CPU and Memory appears on the Overview Dashboard from the Database dashboard. Only Disk information appears which comes from the Db agent. The Windows\Linux OS Agent is responsible to collect CPU and Memory.
Db agent log states:
Failed to execute Usability OS script on instance : [RAC name] . Failed to run query of "RAC-RACname" instance. Query [${LOCALE} ${sudo} ps -ef | ${sudo} grep -iw ora_pmon_$instance_name | ${sudo} grep -vc." message. -
Risoluzione
Use Putty Utility to link to the FGLAM agent manager host on Linux by using the same OS user account that was entered
ps -ef | grep -iw ora_pmon_$instance_name | grep -vc
Please, download the Oracle Cartridge release notes based on your version, this will show the following requirements for the FGLAM Agent Manager hosting the Db agents and Os agents:UNIX Server and Programs
The following UNIX programs must be accessible to the user logged on to the UNIX and Linux computers:On all platforms: df, du, awk, iostat, vmstat, uptime, netstat, sed, ps, uname, ls -lIn addition, the following platform-specific programs must be available:On the Linux platform: /proc/vmstat, /proc/net/dev, free, /proc/cpuinfo, getconfOn the Solaris platform: /usr/sbin/prtconf, mpstat, pagesize, psrinfoOn the AIX platform: lsattr, lsdev, pagesize, bindprocessor, lsdev, oslevelOn the HP-UX specific platform: bdf (instead of df), sar, /var/adm/syslog/syslog.log, /usr/sbin/ioscan, getconf, /swapinfo, InfoLog (needs to be enabled)Programs that should be configured to be run using sudoThe sudo utility allows system administrators to grant specific users (or groups of users) the ability to run certain commands that require administrative privileges as root, without having to log in as administrator.The programs that can be run using sudo in the various Linux and UNIX operating systems are as follows:On all platforms, when monitoring the Clusterware using the CRS agent:For running the Clusterware monitoring wizard: test, uname, ps, awk, {CRS_HOME}/bin/olsnodesFor monitoring the Clusterware: {CRS_HOME}/bin/crs_stat, tail, {CRS_HOME}/bin/crsctlOn all platforms: df, du, awk, iostat, vmstat, uptime, netstat, sed, ps, uname, grep, ls -lIn addition, the following platform-specific programs must be available:On the Linux platform: /proc/vmstat, /proc/net/dev, free, /proc/cpuinfo, getconfOn the Solaris platform: /usr/sbin/prtconf, mpstat, pagesize, psrinfoOn the AIX platform: lsattr, lsdev, pagesize, lsdev, bindprocessor, oslevelOn the HP-UX specific platform: bdf (instead of df), sar, /var/adm/syslog/syslog.log, /usr/sbin/ioscan, getconf, /swapinfo, InfoLog (needs to be enabled)