Ad Widget

**saink** · 24-09-2010, 06:39

thanks,I download tar file.Try to test oracle

**saink** · 24-09-2010, 12:14

Today I try to test on the vmware virtual server ,find SGA share pool（zabbix 141M），oem display 160M，buffer cache， larger pool，java pool is same ，no error in orabbix log；But Server log record some null values error，the Difference of SGA share pool is about 20M？

vim /opt/orabbix/logs/orabbix.log
。。。。。。。。。。

2010-09-24 17:12:07,207 [pool-1-thread-5] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 584 ms
2010-09-24 17:17:07,478 [pool-1-thread-6] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 733 ms
2010-09-24 17:20:58,424 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2010-09-24 17:20:59,662 [main] INFO Orabbix - Connected as ZABBIX
2010-09-24 17:20:59,667 [main] INFO Orabbix - --------- on Database -> orcl
2010-09-24 17:21:00,387 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 642 ms
2010-09-24 17:23:38,090 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2010-09-24 17:23:40,482 [main] INFO Orabbix - Connected as ZABBIX
2010-09-24 17:23:40,485 [main] INFO Orabbix - --------- on Database -> orcl
2010-09-24 17:23:41,172 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 648 ms
2010-09-24 17:28:41,201 [pool-1-thread-2] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 583 ms
2010-09-24 17:33:41,280 [pool-1-thread-3] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 595 ms
2010-09-24 17:38:41,538 [pool-1-thread-4] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 812 ms
2010-09-24 17:43:41,259 [pool-1-thread-5] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 495 ms
2010-09-24 17:48:41,239 [pool-1-thread-6] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 443 ms
2010-09-24 17:53:42,137 [pool-1-thread-7] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 676 ms
2010-09-24 17:58:42,297 [pool-1-thread-8] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 495 ms

vim /tmp/zabbix_agentd.log-----------------------------
5200:20100924:154537.072 Zabbix Agent started. Zabbix 1.8.3 (revision 13928).
5201:20100924:154537.074 zabbix_agentd collector started
5202:20100924:154537.077 zabbix_agentd listener started
5204:20100924:154537.081 zabbix_agentd listener started
5205:20100924:154537.083 zabbix_agentd active check started [127.0.0.1:10051]
5205:20100924:154537.086 No active checks on server: host [Zabbix server] not monitored
5203:20100924:154537.086 zabbix_agentd listener started
5200:20100924:154550.207 Got signal [signal:15(SIGTERM),sender_pid:5220,sender_uid:0,re ason:0]. Exiting ...
5200:20100924:154550.212 Zabbix Agent stopped. Zabbix 1.8.3 (revision 13928).
5302:20100924:154614.666 Zabbix Agent started. Zabbix 1.8.3 (revision 13928).
5303:20100924:154614.667 zabbix_agentd collector started
5304:20100924:154614.671 zabbix_agentd listener started
5305:20100924:154614.672 zabbix_agentd listener started
5306:20100924:154614.673 zabbix_agentd listener started
5307:20100924:154614.897 zabbix_agentd active check started [127.0.0.1:10051]
5307:20100924:154615.188 No active checks on server: host [Zabbix server] not monitored
5302:20100924:154725.206 Got signal [signal:15(SIGTERM),sender_pid:5358,sender_uid:0,re ason:0]. Exiting ...
5302:20100924:154725.207 Zabbix Agent stopped. Zabbix 1.8.3 (revision 13928).
5416:20100924:154732.402 Zabbix Agent started. Zabbix 1.8.3 (revision 13928).
5417:20100924:154732.403 zabbix_agentd collector started
5418:20100924:154732.407 zabbix_agentd listener started
5420:20100924:154732.721 zabbix_agentd listener started
5421:20100924:154732.723 zabbix_agentd active check started [127.0.0.1:10051]
5419:20100924:154732.986 zabbix_agentd listener started
zabbix_agentd [12765]: File [/tmp/zabbix_agentd.pid] exists and is locked. Is this process already running ?
zabbix_agentd [12765]: ERROR: File [/tmp/zabbix_agentd.pid] exists and is locked. Is this process already running ?

vim /tmp/zabbix_server.log
======================
[root@oracle sbin]# vim /tmp/zabbix_server.log

5369:20100924:173743.682 Item [Zabbix server:sensor[temp2]] error: Not supported by Zabbix Agent
5369:20100924:173744.757 Item [Zabbix server:sensor[temp3]] error: Not supported by Zabbix Agent
5368:20100924:173803.321 Item [Zabbix server:vfs.file.cksum[/etc/inetd.conf]] error: Not supported by Zabbix Agent
5367:20100924:173808.383 Item [Zabbix server:vfs.file.cksum[/vmlinuz]] error: Not supported by Zabbix Agent
5370:20100924:173855.267 Item [orcl:system.cpu.util[ ]] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5369:20100924:173926.198 Item [localhost:vfs.file.cksum[/vmlinuz]] error: Not supported by Zabbix Agent
5368:20100924:173929.290 Item [localhost:vfs.file.cksum[/etc/inetd.conf]] error: Not supported by Zabbix Agent
5371:20100924:174010.524 Item [localhost:net.if.in[eth1,bytes]] error: Not supported by Zabbix Agent
5371:20100924:174010.529 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5370:20100924:174141.465 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5369:20100924:174255.794 Item [orcl:system.cpu.util[ ]] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5371:20100924:174410.176 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5368:20100924:174540.626 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5368:20100924:174655.451 Item [orcl:system.cpu.util[ ]] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5367:20100924:174717.005 Item [Zabbix server:vfs.file.size[/var/log/syslog]] error: Not supported by Zabbix Agent
5371:20100924:174721.016 Item [Zabbix server:net.if.in[eth1,bytes]] error: Not supported by Zabbix Agent
5370:20100924:174724.041 Item [Zabbix server:net.if.out[eth1,bytes]] error: Not supported by Zabbix Agent
5370:20100924:174742.184 Item [Zabbix server:sensor[temp1]] error: Not supported by Zabbix Agent

**dalle** · 30-09-2010, 14:57

Originally posted by saink

Today I try to test on the vmware virtual server ,find SGA share pool（zabbix 141M），oem display 160M，buffer cache， larger pool，java pool is same ，no error in orabbix log；But Server log record some null values error，the Difference of SGA share pool is about 20M？

vim /opt/orabbix/logs/orabbix.log
。。。。。。。。。。

2010-09-24 17:12:07,207 [pool-1-thread-5] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 584 ms
2010-09-24 17:17:07,478 [pool-1-thread-6] INFO Orabbix - Done with dbJob on database DB1 QueryList elapsed time 733 ms
2010-09-24 17:20:58,424 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2010-09-24 17:20:59,662 [main] INFO Orabbix - Connected as ZABBIX
2010-09-24 17:20:59,667 [main] INFO Orabbix - --------- on Database -> orcl
2010-09-24 17:21:00,387 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 642 ms
2010-09-24 17:23:38,090 [main] INFO Orabbix - PidFile -> ./logs/orabbix.pid
2010-09-24 17:23:40,482 [main] INFO Orabbix - Connected as ZABBIX
2010-09-24 17:23:40,485 [main] INFO Orabbix - --------- on Database -> orcl
2010-09-24 17:23:41,172 [pool-1-thread-1] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 648 ms
2010-09-24 17:28:41,201 [pool-1-thread-2] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 583 ms
2010-09-24 17:33:41,280 [pool-1-thread-3] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 595 ms
2010-09-24 17:38:41,538 [pool-1-thread-4] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 812 ms
2010-09-24 17:43:41,259 [pool-1-thread-5] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 495 ms
2010-09-24 17:48:41,239 [pool-1-thread-6] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 443 ms
2010-09-24 17:53:42,137 [pool-1-thread-7] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 676 ms
2010-09-24 17:58:42,297 [pool-1-thread-8] INFO Orabbix - Done with dbJob on database orcl QueryList elapsed time 495 ms

vim /tmp/zabbix_agentd.log-----------------------------
5200:20100924:154537.072 Zabbix Agent started. Zabbix 1.8.3 (revision 13928).
5201:20100924:154537.074 zabbix_agentd collector started
5202:20100924:154537.077 zabbix_agentd listener started
5204:20100924:154537.081 zabbix_agentd listener started
5205:20100924:154537.083 zabbix_agentd active check started [127.0.0.1:10051]
5205:20100924:154537.086 No active checks on server: host [Zabbix server] not monitored
5203:20100924:154537.086 zabbix_agentd listener started
5200:20100924:154550.207 Got signal [signal:15(SIGTERM),sender_pid:5220,sender_uid:0,re ason:0]. Exiting ...
5200:20100924:154550.212 Zabbix Agent stopped. Zabbix 1.8.3 (revision 13928).
5302:20100924:154614.666 Zabbix Agent started. Zabbix 1.8.3 (revision 13928).
5303:20100924:154614.667 zabbix_agentd collector started
5304:20100924:154614.671 zabbix_agentd listener started
5305:20100924:154614.672 zabbix_agentd listener started
5306:20100924:154614.673 zabbix_agentd listener started
5307:20100924:154614.897 zabbix_agentd active check started [127.0.0.1:10051]
5307:20100924:154615.188 No active checks on server: host [Zabbix server] not monitored
5302:20100924:154725.206 Got signal [signal:15(SIGTERM),sender_pid:5358,sender_uid:0,re ason:0]. Exiting ...
5302:20100924:154725.207 Zabbix Agent stopped. Zabbix 1.8.3 (revision 13928).
5416:20100924:154732.402 Zabbix Agent started. Zabbix 1.8.3 (revision 13928).
5417:20100924:154732.403 zabbix_agentd collector started
5418:20100924:154732.407 zabbix_agentd listener started
5420:20100924:154732.721 zabbix_agentd listener started
5421:20100924:154732.723 zabbix_agentd active check started [127.0.0.1:10051]
5419:20100924:154732.986 zabbix_agentd listener started
zabbix_agentd [12765]: File [/tmp/zabbix_agentd.pid] exists and is locked. Is this process already running ?
zabbix_agentd [12765]: ERROR: File [/tmp/zabbix_agentd.pid] exists and is locked. Is this process already running ?

vim /tmp/zabbix_server.log
======================
[root@oracle sbin]# vim /tmp/zabbix_server.log

5369:20100924:173743.682 Item [Zabbix server:sensor[temp2]] error: Not supported by Zabbix Agent
5369:20100924:173744.757 Item [Zabbix server:sensor[temp3]] error: Not supported by Zabbix Agent
5368:20100924:173803.321 Item [Zabbix server:vfs.file.cksum[/etc/inetd.conf]] error: Not supported by Zabbix Agent
5367:20100924:173808.383 Item [Zabbix server:vfs.file.cksum[/vmlinuz]] error: Not supported by Zabbix Agent
5370:20100924:173855.267 Item [orcl:system.cpu.util[ ]] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5369:20100924:173926.198 Item [localhost:vfs.file.cksum[/vmlinuz]] error: Not supported by Zabbix Agent
5368:20100924:173929.290 Item [localhost:vfs.file.cksum[/etc/inetd.conf]] error: Not supported by Zabbix Agent
5371:20100924:174010.524 Item [localhost:net.if.in[eth1,bytes]] error: Not supported by Zabbix Agent
5371:20100924:174010.529 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5370:20100924:174141.465 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5369:20100924:174255.794 Item [orcl:system.cpu.util[ ]] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5371:20100924:174410.176 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5368:20100924:174540.626 Item [orcl:uptime] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5368:20100924:174655.451 Item [orcl:system.cpu.util[ ]] error: Got empty string from [192.168.0.75]. Assuming that agent dropped connection because of access permissions
5367:20100924:174717.005 Item [Zabbix server:vfs.file.size[/var/log/syslog]] error: Not supported by Zabbix Agent
5371:20100924:174721.016 Item [Zabbix server:net.if.in[eth1,bytes]] error: Not supported by Zabbix Agent
5370:20100924:174724.041 Item [Zabbix server:net.if.out[eth1,bytes]] error: Not supported by Zabbix Agent
5370:20100924:174742.184 Item [Zabbix server:sensor[temp1]] error: Not supported by Zabbix Agent

I don't have more trouble with this last release...
those error may be that become from a wrong ip on host ORCL
try with a correct IP

**vlam** · 11-11-2010, 06:54

Hi all

I have done all of this exactly like you have it done here but this is the output that I get

Info from server: "Processed 0 Failed 1 Total 1 Seconds spent 0.000075"
sent: 1; skipped: 0; total: 1

**vlam** · 11-11-2010, 07:45

hi all

when I run

sh -x ./check_ora_sendtrap.sh -r -i DGDB0101 -q audit

this is the output that I get

externalscripts]# sh -x ./check_ora_sendtrap.sh -r -i DGDB0101 -q audit
+ source /etc/zabbix/externalscripts/check_ora/globalcfg
++ export ORACLE_BASE=/apps/oracle/product/10g/
++ ORACLE_BASE=/apps/oracle/product/10g/
++ export ORACLE_HOME=/apps/oracle/product/10g/
++ ORACLE_HOME=/apps/oracle/product/10g/
++ export PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:/apps/oracle/product/10g//bin
++ PATH=/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin:/apps/oracle/product/10g//bin
++ export LD_LIBRARY_PATH=/lib/:/usr/lib:/apps/oracle/product/10g//lib
++ LD_LIBRARY_PATH=/lib/:/usr/lib:/apps/oracle/product/10g//lib
++ export TNS_ADMIN=/apps/oracle/product/10g//network/admin
++ TNS_ADMIN=/apps/oracle/product/10g//network/admin
++ export SCRIPTDIR=/etc/zabbix/externalscripts/check_ora
++ SCRIPTDIR=/etc/zabbix/externalscripts/check_ora
++ export CONNFILE=/etc/zabbix/externalscripts/check_ora/credentials
++ CONNFILE=/etc/zabbix/externalscripts/check_ora/credentials
++ export CFGFILE=/etc/zabbix/externalscripts/globalcfg
++ CFGFILE=/etc/zabbix/externalscripts/globalcfg
++ export ZBX_SENDER=/etc/zabbix/bin/zabbix_sender
++ ZBX_SENDER=/etc/zabbix/bin/zabbix_sender
++ export ZBX_SERVER=10.31.13.85
++ ZBX_SERVER=10.31.13.85
++ export ZBX_PORT=10051
++ ZBX_PORT=10051
+ INST=
+ QUERY=
+ CONNECTION=
+ DESCFLAG=
+ QUERYFLAG=
+ '[' - '!=' - ']'
+ getopts hi:q:d:tsr opt
+ case $opt in
+ RFLAG=1
+ getopts hi:q:d:tsr opt
+ case $opt in
+ QFLAG=1
+ INST=DGDB0101
+ getopts hi:q:d:tsr opt
+ case $opt in
+ QUERY=audit
+ getopts hi:q:d:tsr opt
+ '[' '' = 1 ']'
+ '[' '' = 1 ']'
+ '[' '' = 1 ']'
+ '[' 1 = 1 ']'
++ grep 'DGDB0101;' /etc/zabbix/externalscripts/check_ora/credentials
++ cut '-d;' -f2
+ CONNECTION=
++ execquery audit.sql
++ cd /etc/zabbix/externalscripts/check_ora
++ sqlplus -S audit.sql
++ sed -e 's/^\ *//g'
+ RESULT='
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /'
+ '[' -z '
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /' ']'
+ send DGDB0101 audit '
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /'
+ MYHOST=DGDB0101
+ MYKEY=audit
+ MYMSG='
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /'
+ '[' 1 = 1 ']'
+ /etc/zabbix/bin/zabbix_sender -z 10.31.13.85 -p 10051 -s DGDB0101 -k audit -o '
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where <logon> ::= <username>[/<password>][@<connect_identifier>] | /'
Info from server: "Processed 0 Failed 1 Total 1 Seconds spent 0.000047"
sent: 1; skipped: 0; total: 1
+ exit 0

and this is the output of my credentials file

externalscripts]# vi check_ora/credentials
INSTANCE;zabbix/password@ARS

what can cause this not to work

**dalle** · 11-11-2010, 10:19

do you have a sqlplus correct installed on your environment with tnsnames.ora right configured?
i mean you are able to connecto to DGDB0101 with sqlplus?
please consider to use Orabbix instead check_ora that is my first version of software to monitor oracle, Orabbix is pretty much better, and easy to use.

**vlam** · 11-11-2010, 10:41

i have tried to use arobbix but it does not work due to i am running s390x arch and not standard i386 or 64bit

**vlam** · 11-11-2010, 11:08

i have arobbix also on this system but when i try to start it this is the reply that i get

./run.sh
[root@NRSSDB01 scripts]# Warning: -jar not understood. Ignoring.
Exception in thread "main" java.lang.NoClassDefFoundError: orabbix-1.1.0.jar
at gnu.gcj.runtime.FirstThread.run() (/usr/lib64/libgcj.so.5.0.0)
at _Jv_ThreadRun(java.lang.Thread) (/usr/lib64/libgcj.so.5.0.0)
at _Jv_RunMain(java.lang.Class, byte const, int, byte const, boolean) (/usr/lib64/libgcj.so.5.0.0)
at __gcj_personality_v0 (/etc/zabbix/scripts/java.version=1.4.2)
at __libc_start_main (/lib64/tls/libc-2.3.4.so)
at __libc_start_main (/etc/zabbix/scripts/java.version=1.4.2)

**SeMaTech** · 10-03-2011, 21:37

WARN Orabbix - received unexpected response '' for key

Greetings,

Zabbix and Orabbix noob here. We are trying to set up Orabbix to monitor Oracle 11.2. I have attempted to set up orabbix following instructions here http://www.smartmarmot.com/product/o...l-instruction/ and here http://www.zabbix.com/wiki/howto/mon...le_with_zabbix.

Problem we are having is two fold. We are not getting data to show up in charts. Also our orabbix log has lots of received unexpected response '' for key messages in it.

Debug log; config.props; query.props are in attached ZIP.

Any guidance / assistance is greatly appreciated!

Attached Files

orabbix-logs-configs.zip (28.1 KB, 221 views)

**dalle** · 11-03-2011, 10:22

I've found that zabbix server send back as reply
2011-03-10 14:21:56,443 [pool-1-thread-2] WARN Orabbix - received unexpected
response ' followed by 1024 blank space (1K) this is really strange. It's never
happened before.
Which version of Zabbix are you using?
Do you have imported my template? and you have created two host CPATCH and E1TEST on zabbix?
Please be patience I know that are stupid question but those are the most common errors

Originally posted by SeMaTech

Greetings,

Zabbix and Orabbix noob here. We are trying to set up Orabbix to monitor Oracle 11.2. I have attempted to set up orabbix following instructions here http://www.smartmarmot.com/product/o...l-instruction/ and here http://www.zabbix.com/wiki/howto/mon...le_with_zabbix.

Problem we are having is two fold. We are not getting data to show up in charts. Also our orabbix log has lots of received unexpected response '' for key messages in it.

Debug log; config.props; query.props are in attached ZIP.

Any guidance / assistance is greatly appreciated!

**SeMaTech** · 11-03-2011, 21:25

We are running Zabbix 1.8.4 on CentOS5. I have imported the templates from the 'template' folder in the orabbix-1.2.0-RC1 install zip. I have created two hosts CPATCH and E1TEST and have associated them to Template_Oracle. Screen captures of my templates and of the hosts attached. Thanks!!

Attached Files

**dalle** · 14-03-2011, 16:14

Please try to check the zabbix's server logs, or send your log I'll try to see if i find something of strange, because unfortunately I have no clue about your trouble.
Andrea

**SeMaTech** · 16-03-2011, 22:22

zabbix server logs attached; Thanks!

Attached Files

zabbix-server-log.zip (9.7 KB, 253 views)

**dalle** · 18-03-2011, 11:58

Originally posted by SeMaTech

zabbix server logs attached; Thanks!

here in your log I mean there isn't nothing of strange, i'm sorry but i don't know why orabbix don't work

**dalle** · 21-03-2011, 14:59

Originally posted by SeMaTech

zabbix server logs attached; Thanks!

You still have this issue?
let me know If I have some idea I'll help you

Ad Widget

Another way to monitor Oracle

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment