I’ve found a bug inside a check_ora_sendtrap.sh on line 58:
echo ” -s for sqlplus login connection and return time in second”
in particular there was an escape character and the line appear so:
echo ” -s for sqlplus login connection and return time in seco
without a correct termination, pleas download the new release 1.2.2 at
https://sourceforge.net/projects/checkora/
Note: there’s a trouble when import the template of mine inside zabbix server 1.8.1 i don’t know why but happen just on this release. if you find an error like this:
Added new application Template_Oracle:Oracle
Added new item Template_Oracle:ALERTLOG
Added new item Template_Oracle:alertlog.warn
Added new item Template_Oracle:archive
Added new item Template_Oracle:audit
…..
Added new item Template_Oracle:pinhitratio_
Incorrect key format ‘key_name[param1,param2,…]’
Internal zabbix error
No such monitored parameter (session) for host (Template_Oracle)
Unknown ZABBIX internal error
<description>Pin hit ratio – TABLE/PROCEDURE</description>
<ipmi_sensor></ipmi_sensor>
<delay>300</delay>
<history>90</history>
<trends>365</trends>
<status>0</status>
<units>%</units>
<multiplier>0</multiplier>
<delta>0</delta>
<formula>1</formula>
<lastlogsize>0</lastlogsize>
<logtimefmt></logtimefmt>
<delay_flex></delay_flex>
<params>DSN=<database source name>\nuser=<user name>\npassword=<password>\nsql=<query ></params>
<trapper_hosts></trapper_hosts>
<snmp_community>public</snmp_community>
<snmp_oid>interfaces.ifTable.ifEntry.ifInOctets. 1</snmp_oid>
<snmp_port>161</snmp_port>
<snmpv3_securityname></snmpv3_securityname>
<snmpv3_securitylevel>0</snmpv3_securitylevel>
<snmpv3_authpassphrase></snmpv3_authpassphrase>
<snmpv3_privpassphrase></snmpv3_privpassphrase>
<applications>
<application>Oracle</application>
</applications>
</item>
