Orabbix install requirement

[newbie01.oracle]

Hi all,

Am wanting to install Orabbix for Zabbix but am very lost on what are the requirement.

From http://www.smartmarmot.com/product/o...ll-instruction, it does not mention whether I need to install Orabbix on the Zabbix client or in the Zabbix server, I assume it is only on the Zabbix client, is that correct?

Am very new to Zabbix and am mainly an Oracle DBA so am not sure what to do really.

I did all the steps mentioned in http://www.smartmarmot.com/product/o...ll-instruction on the Zabbix client, is that correct or should I be doing these on the Zabbix server instead?

Following are excerpts from the orabbix.log. FYI, am only testing DB1 which is AMSXXX and as per the log, connection was established but there seems to be issue sending the information back to the Zabbix server.

I confirmed via telnet to the Zabbix server that I can connect to the Zabbix server.

 2010-06-16 00:29:34,528 [main] INFO  Orabbix - Connected as SYSTEM
 2010-06-16 00:29:34,530 [main] INFO  Orabbix - --------- on Database -> AMSXXX
 2010-06-16 00:29:34,549 [main] ERROR Orabbix - Error on Configurator for database DB2 -->Io exception: Invalid number format for port number
 2010-06-16 00:29:34,549 [main] ERROR Orabbix - This Database DB2 will be removed
 2010-06-16 00:29:34,550 [main] ERROR Orabbix - Error on Configurator for database DB3 -->Io exception: Invalid number format for port number
 2010-06-16 00:29:34,550 [main] ERROR Orabbix - This Database DB3 will be removed
 2010-06-16 00:29:34,557 [main] WARN  Orabbix - New Database Founded: adding database DB2
 2010-06-16 00:29:34,558 [main] ERROR Orabbix - Error on Configurator for database DB2 -->Io exception: Invalid number format for port number
 2010-06-16 00:29:34,558 [main] ERROR Orabbix - This Database DB2 will be removed
 2010-06-16 00:29:34,558 [main] WARN  Orabbix - New Database Founded: adding database DB3
 2010-06-16 00:29:34,558 [main] ERROR Orabbix - Error on Configurator for database DB3 -->Io exception: Invalid number format for port number
 2010-06-16 00:29:34,558 [main] ERROR Orabbix - This Database DB3 will be removed
 2010-06-16 00:29:34,804 [Zabbix-sender] WARN  Orabbix - Warning while sending item archive value 0 on host DB1 retry number 0 error:java.io.Interr
uptedIOException: operation interrupted
 2010-06-16 00:29:34,804 [Zabbix-sender] WARN  Orabbix - Warning while sending item archive value 0 on host DB1 error:java.io.InterruptedIOExceptio
n: operation interrupted
 2010-06-16 00:29:36,000 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'archive'
 2010-06-16 00:29:36,220 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'audit'
 2010-06-16 00:29:36,441 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'dbblockgets'
 2010-06-16 00:29:37,005 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'dbconsistentgets'
 2010-06-16 00:29:37,227 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'dbhitratio'
 2010-06-16 00:29:37,485 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'dbphysicalread'
 2010-06-16 00:29:38,000 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'dbversion'
 2010-06-16 00:29:38,220 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'hitratio_body'
 2010-06-16 00:29:38,472 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'hitratio_sqlarea'
 2010-06-16 00:29:39,000 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'hitratio_table_proc'
 2010-06-16 00:29:39,286 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'lio_current_read'
 2010-06-16 00:29:39,520 [Zabbix-sender] WARN  Orabbix - received unexpected response '' for key 'locks'

Any feedback and assistance will be very much appreciated. Thanks in advance.

[mwiewior]

Error on Configurator for database DB2 -->Io exception: Invalid number format for port number

There is clearly something wrong with port number. The db section should look like similar to mine:

DB1.Url=jdbcracle:thin:@hostname:1521BNAME
DB1.User=zabbix
DB1.Password=xxxx

If you're running oracle 11g with the ACL permissions you need to create additional
policies that are not included in the orabbix guide. If you encounter any problems I can be of help - I managed to configure orabbix for 11r2 a few days ago.

[newbie01.oracle]

Hi,

Thanks for your response. I've fixed that problem and all seems okay now ... but ... I don't seem to be getting anything or not sure where the data in the Zabbix server are.

Am using the example template. I don't know how to check on Zabbix if any data are send to the Zabbix server. Do you know how to check that something has been uploaded to the Zabbix server?

From the log, it has the following so I assume it ran fine but not sure how to check on the Zabbix server.

2010-06-16 11:36:32,666 [main] INFO  Orabbix - Starting Orabbix Version 0.6
 2010-06-16 11:36:35,923 [main] INFO  Orabbix - Connected as ZABBIX
 2010-06-16 11:36:36,384 [main] INFO  Orabbix - --------- on Database -> AMSXXX
 2010-06-16 11:36:49,897 [pool-1-thread-1] INFO  Orabbix - Done with dbJob on database DB1 elapsed time 13230 ms
 2010-06-16 11:41:49,845 [pool-1-thread-2] INFO  Orabbix - Done with dbJob on database DB1 elapsed time 12935 ms

I change the log to DEBUG mode and it shows that the SQL are getting executed against the Oracle database, so that means I got data. Note below from the log file

 2010-06-16 12:30:07,215 [pool-1-thread-1] DEBUG Orabbix - Actual query is session_active statement is select count(*) from v$session where TYPE!='BACKGROUND' and status='ACTIVE'
 2010-06-16 12:30:07,437 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query session_active resultset -->4
 2010-06-16 12:30:07,437 [pool-1-thread-1] DEBUG Orabbix - Actual query is session_inactive statement is select SUM(Decode(Type, 'BACKGROUND', 0, Decode(Status, 'ACTIVE', 0, 1))) FROM V$SESSION
 2010-06-16 12:30:07,644 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query session_inactive resultset -->1
 2010-06-16 12:30:07,644 [pool-1-thread-1] DEBUG Orabbix - Actual query is session statement is select count(*) from v$session
 2010-06-16 12:30:07,880 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query session resultset -->19

But on Zabbix Latest Data, I don't see Oracle in the list of Items. On the Graphs, I can see the Oracle lists on the Graph drop down list, i.e. Archivelog, Sessions etc. but no data, so where are the data going to? Am I supposed to see Oracle when I click on Zabbix Latest Data?

BTW, I do have an Oracle11g database, can you tell me what are the things that I have to consider as far as the ACL that you mentioned is concern?

FYI, am currently testing this on an Oracle10g database for the meantime, the logs that you are seeing here are for the Oracle10g database.

Your help will be very much appreciated ... thanks in advance.

[mwiewior]

You need to add hosts to monitoring that have the same names as you put in the orabbix configuration files and apply oracle_template on them. This is it.

As far as ACL in 11g is concerned I needed to to the following - I'm not telling this is the safest solution you can think of tuning it a bit - but it is a good point to start:

DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'zabbix_acl_file.xml', 
    description  => 'ACL for ORABBIX plugin for ZABBIX',
    principal    => 'ZABBIX',
    is_grant     => TRUE, 
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

  COMMIT;
END;
/

BEGIN
  DBMS_NETWORK_ACL_ADMIN.add_privilege ( 
    acl         => 'zabbix_acl_file.xml', 
    principal   => 'ZABBIX',
    is_grant    => TRUE, 
    privilege   => 'resolve', 
    position    => NULL, 
    start_date  => NULL,
    end_date    => NULL);

  COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'zabbix_acl_file.xml',
    host        => '*', 
    lower_port  => NULL,
    upper_port  => NULL);

  COMMIT;
END;
/

[newbie01.oracle]

Hi,

Thanks for a very quick response.

I believe I got what you mean, but I just want to make sure if I understand it correctly.

Below is an excerpt from the template that I imported to the Zabbix server. Does that mean the <hosts> line should have the name of the host/server before I do the import? FYI, the host is already getting monitored and is part of an existing Host group.

The template that am using is similar to the one that the author posted in another topic.

From orabbix.log, it shows something as below. Not sure where is the <host>REIx</host> is coming from? I don't have REIx define anywhere?

I've uploaded the orabbix files that am using, hopefully you can check and advise if there is anything wrong somewhere. FYI, I took out the jar files and other big files otherwise I will not be able to attach the zip files.

I've uploaded a screenshot of what the Hosts look like now and I have one named Template_Oracle which is the name that is on the <host name="Template_Oracle"> line of the XML file, is this what you mean that I have to do on Zabbix?

 2010-06-18 06:16:05,630 [Zabbix-sender] DEBUG Orabbix - received OK
 2010-06-18 06:16:05,630 [Zabbix-sender] DEBUG Orabbix - sending <req><host>REIx</host><key>c2dhX2ZpeGVk</key><data>MS45NQ==</data></req>
 2010-06-18 06:16:05,631 [Zabbix-sender] DEBUG Orabbix - received OK
 2010-06-18 06:16:05,631 [Zabbix-sender] DEBUG Orabbix - sending <req><host>REIx</host><key>c2dhX2phdmFfcG9vbA==</key><data>MTAw</data></req>
 2010-06-18 06:16:05,631 [Zabbix-sender] DEBUG Orabbix - received OK

<?xml version="1.0"?>
<zabbix_export version="1.0" date="15.04.10" time="10.32">
        <hosts>
                <host name="Template_Oracle">
                        <useip>0</useip>
                        <dns></dns>
                        <ip>0.0.0.0</ip>
                        <port>10050</port>
                        <status>3</status>
                        <groups>
                                <group>Templates</group>
                        </groups>

You need to add hosts to monitoring that have the same names as you put in the orabbix configuration files and apply oracle_template on them. This is it.

As far as ACL in 11g is concerned I needed to to the following - I'm not telling this is the safest solution you can think of tuning it a bit - but it is a good point to start:

DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'zabbix_acl_file.xml', 
    description  => 'ACL for ORABBIX plugin for ZABBIX',
    principal    => 'ZABBIX',
    is_grant     => TRUE, 
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);

  COMMIT;
END;
/

BEGIN
  DBMS_NETWORK_ACL_ADMIN.add_privilege ( 
    acl         => 'zabbix_acl_file.xml', 
    principal   => 'ZABBIX',
    is_grant    => TRUE, 
    privilege   => 'resolve', 
    position    => NULL, 
    start_date  => NULL,
    end_date    => NULL);

  COMMIT;
END;
/

BEGIN
DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'zabbix_acl_file.xml',
    host        => '*', 
    lower_port  => NULL,
    upper_port  => NULL);

  COMMIT;
END;
/

[newbie01.oracle]

Hi mwiewior

I kept on repeating what you said over and over and over ... "You need to add hosts to monitoring that have the same names as you put in the orabbix configuration files and apply oracle_template on them" ... and guess what, it is finally working now ... am getting data across ...

From the log, the host tag still says gibberish ... oh well, maybe that is by design

 2010-06-19 01:48:02,625 [Zabbix-sender] DEBUG Orabbix - sending <req>[B]<host>QU1TWFhY</host>[/B]<key>ZGdlcnJvcg==</key><data>bm9uZQ==</data></req>

Anyway, now am excited to know if you know what I have to do to generate graphs for tablespaces? That is for example, if I want to create graphs of the tablespace usage?

Any advise/suggestion will be very much appreciated. Thanks a lot again for your help.

[dantony79]

can you post me the steps you used in this.

i have few doubts . Where do i need to install the orabbix on the zabbix server or client where the database is installed.

i did everything as per this website

http://www.zabbix.com/wiki/howto/mon...le_with_zabbix.

but unable to start it as it throws java exception error.

[root@zabbix-server ~# Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/log4j/Level
at main.main(main.java:67)
Caused by: java.lang.ClassNotFoundException: org.apache.log4j.Level
at java.net.URLClassLoader$1.run(URLClassLoader.java: 217)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.j ava:205)
at java.lang.ClassLoader.loadClass(ClassLoader.java:3 19)
at sun.misc.Launcher$AppClassLoader.loadClass(Launche r.java:294)
at java.lang.ClassLoader.loadClass(ClassLoader.java:2 64)
at java.lang.ClassLoader.loadClassInternal(ClassLoade r.java:332)

[root@zabbix-server ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 5.5 (Tikanga)
[root@zabbix-server ~]# java -version
java version "1.6.0_0"
OpenJDK Runtime Environment (IcedTea6 1.6) (rhel-1.13.b16.0.1.el5-x86_64)
OpenJDK 64-Bit Server VM (build 14.0-b16, mixed mode)

If you do not mind could you reply with the steps you have done to make this working.

Thanks,

[dalle]

i'm using
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_21-b06)
Java HotSpot(TM) 64-Bit Server VM (build 17.0-b16, mixed mode)
btw Level is contained inside log4j.jar please verify that is present (as should be on mine distribution) and let me know if you have problem.. anyway download mine last release

[dantony79]

Unable to figure out what is happening after upgrading java to version &quot;1.6.0_21&quot;

ERROR Orabbix - Error on Configurator for database TEST -->No suitable driver found for
WARN Orabbix - New Database Founded: adding database TEST
ERROR Orabbix - Error on Configurator getConnection while getting TEST .Url null
ERROR Orabbix - Error on Configurator getConnection while getting TEST .User null
ERROR Orabbix - Error on Configurator getConnection while getting TEST .Password null
INFO Orabbix - Note: TEST .MaxActive null
INFO Orabbix - Note: TEST .MaxWait null
INFO Orabbix - Note: TEST .MaxIdle null
ERROR Orabbix - Error on Configurator for database TEST -->No suitable driver found for

[root@ed-zab-test logs]# java -version
java version "1.6.0_21"
Java(TM) SE Runtime Environment (build 1.6.0_21-b06)
Java HotSpot(TM) 64-Bit Server VM (build 17.0-b16, mixed mode)

[dalle]

TEST .Url mean that after "TEST" vront on your dblist there is a blank space
ora an hidden char
because Orabbix is trying to find <DBNAME>.Url
and your <dbname> seem be 'TEST '
i've already give my response about

[hezhengyuan2007]

About Zabbix Orabbix problem

Hi all
I have a problem about orabbix.
at first. I download a file name is orabbix-1.2.0-RC3.zip
unzip orabbix-1.2.0-RC3.zip
conf
config.props
I update conf.props result:
#comma separed list of Zabbix servers
ZabbixServerList=ZabbixServer1

ZabbixServer1.Address=192.168.1.174
ZabbixServer1.Port=10051

#ZabbixServer2.Address=IP_ADDRESS_OF_ZABBIX_SERVER
#ZabbixServer2.Port=PORT_OF_ZABBIX_SERVER

#pidFile
OrabbixDaemon.PidFile=./logs/orabbix.pid
#frequency of item's refresh
OrabbixDaemon.Sleep=300
#MaxThreadNumber should be >= than the number of your databases
OrabbixDaemon.MaxThreadNumber=100

#put here your databases in a comma separated list
DatabaseList=DB1

#Configuration of Connection pool
#if not specified Orabbis is going to use default values (hardcoded)
#Maximum number of active connection inside pool
DatabaseList.MaxActive=10
#The maximum number of milliseconds that the pool will wait
#(when there are no available connections) for a connection to be returned
#before throwing an exception, or <= 0 to wait indefinitely.
DatabaseList.MaxWait=100
DatabaseList.MaxIdle=1

#define here your connection string for each database
DB1.Url=jdbcracle:thin:@192.168.1.179:1521:ORCL
DB1.User=system
DB1.Password=orcl
#Those values are optionals if not specified Orabbix is going to use the general values
DB1.MaxActive=10
DB1.MaxWait=100
DB1.MaxIdle=1
DB1.QueryListFile=./conf/query.props

#DB2.Url=jdbcracle:thin:@server2.domain.example.com:<LISTENER_P ORT>B2
#DB2.User=zabbix
#DB2.Password=zabbix_password
#DB2.QueryListFile=./conf/query.props


#DB3.Url=jdbcracle:thin:@server3.domain.example.com:<LISTENER_P ORT>B3
#DB3.User=zabbix
#DB3.Password=zabbix_password
#DB3.QueryListFile=./conf/query.props


#Query Parameter Files
#this still remain as DEFAUL query file for all databases
QueryListFile=/opt/orabbix/conf/query.props


*********************************************
My zabbix server already start
now
1.I don't know how config zabbix page.
2.at zabbix page how save host?
3.save host how relative to start run.bat?
4.how receive data?
5.how save data to database?

Thanks.

[matw]

WARN Orabbix - received unexpected response ZBX_NOTSUPPORTED

Hi!
I installed orabbix 1.2.3 on Zabbix 2.0.3 / SLES 11.
I used installation Orabbix_Install_v0.6.pdf and I think all steps are correctly installed (no errors are occured):

I get following message in the log:

2013-04-24 15:13:30,093 [main] INFO Orabbix - Starting Orabbix Version 1.2.3
2013-04-24 15:13:30,118 [main] INFO Orabbix - Orabbix started with pid:26498
2013-04-24 15:13:30,118 [main] INFO Orabbix - PidFile -> /opt/orabbix/logs/orabbix.pid
2013-04-24 15:13:30,335 [main] INFO Orabbix - DB Pool created: org.apache.commons.dbcp.datasources.SharedPoolData Source@680c680c
2013-04-24 15:13:30,335 [main] INFO Orabbix - URL=jdbcracle:thin:@kitty-02:1521:MT1
2013-04-24 15:13:30,335 [main] INFO Orabbix - maxPoolSize=10
2013-04-24 15:13:30,335 [main] INFO Orabbix - maxIdleSize=1
2013-04-24 15:13:30,335 [main] INFO Orabbix - maxIdleTime=1800000ms
2013-04-24 15:13:30,335 [main] INFO Orabbix - poolTimeout=100
2013-04-24 15:13:30,335 [main] INFO Orabbix - timeBetweenEvictionRunsMillis=-1
2013-04-24 15:13:30,335 [main] INFO Orabbix - numTestsPerEvictionRun=3
2013-04-24 15:13:31,324 [main] INFO Orabbix - Connected as ZABBIX
2013-04-24 15:13:31,338 [main] INFO Orabbix - --------- on Database -> mt1
2013-04-24 15:13:31,385 [pool-1-thread-1] WARN Orabbix - received unexpected response 'ZBXD

I think my config.props is OK.

Where is the error?