no active checks on server [IP]: host [Name] not found

[Amar]

Hi friends,
we have configured zabbix 2.4 for windows and linux server monitoring.
now we are trying for ORACLE monitoring using python/pyora module.

we are facing 2 problems
1)templates/items showing 'Not Supported'.
2)in zabbix logs also 'no active checks on server'

would appreciate any help.

Deepak Jain

[Amar]

no active checks on server [IP]: host [Name] not found

Hi guys,

I searched everything but didn't get the solution for "Not supporting items" in the template and back-end.

will appreciate if any body help us in this.

Deepak jain

[Amar]

Received value [The system cannot find the path specified] is not suitable for value

Hi,

I am getting below error after importing ORACLE Template in zabbix for monitoring.

Received value [The system cannot find the path specified] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]
And
Not supported in template

Could anybody help or guide me, how to monitor Oracle DB in ZABBIX.

Thank you,
Deepak J.

[Atsushi]

It will command or directory in which you try to run does not exist.
Failed to run it has been returned string of error.
That error messages is 'The system cannot find the path specified'.

What do you use the template?
Are those that are published somewhere?
The item that becomes the error is, What is the item?
Please tell me details for the item.

[Amar]

correct pyora.xml or not for Zabbix Agent base ORACLE monitoring

Thanks dear for your reply ...
we see 'The system cannot find the path specified' in 'Latest value' column in 'Latest Data' tag
same error we observe in /var/log/zabbix/zabbix_server.log

we are using xml 3.0 template which is available at below site, which i think is for SNMP not for zabbix agnet[not very sure]
we use pyora scripts integrated and run/invoke by python from /home/oracle/Pyora/pyora.py
not sure where it catches the output and hand it over to xml to format and show us in frontend.

for rest we followed word to word using below available links.

http://bicofino.io/2013/12/09/monitoring-oracle-with-zabbix/

https://github.com/bicofino/Pyora

even item 'oracle/version on oracle' created by pyora.xml is not showing the latest data on above said column.

Also not supporting other available items.

Please help understaning that whether we are using right pyora.xml or not.
We are initially trying monitoring ORACLE using zabbix agnet not SNMP.

Deepak Jain

[asteroidyorkton]

First try if the item works using Zabbix_get.

/usr/bin/zabbix_get -s 10.1.1.1 -k agent.hostname

10.1.1.1 is your agent IP.
-k agent.hostname is the key. Change that to whatever key it shows in the template item key section.

Find the reason why its not working, usually zabbix agent issue or something.

/usr/bin/zabbix_get -s 10.1.1.1 -k pyora[*]
replace * with the correct parameter to test it using zabbix_get.

I hope you restarted zabbix agent after adding user parameter? Try increasing DebugLevel=4 in agent and check the logs while you test zabbix_get

Here is one example. In agent.conf -> UserParameter=mysql.version,mysql -V -> mysq.version is the key, mysql -V is the command that's run when you use the key. And its output is the result you would see in latest data or zabbix_get.
/usr/bin/zabbix_get -s 10.1.1.1 -k mysql.version


"no active checks on server and hostname not found" is because you have not added that host to zabbix or hostname mismatch in agent.conf. Double check Hostname in agent.conf and zabbix -> Configuration -> hosts

[Atsushi]

Do not use the Windows platform?
Do you have set the path that can run on the Windows platform to UserParameter?