Orabbix:"Another way to monitor Oracle reloaded"

[sybex]

Hi, ...

i changed the config and removed the "dot" ... btw in my inhouse it is working with the dot.

But now i got another error message:

[root@afcarc01p ~]# tail -f /opt/orabbix/log/orabbix.log
 2010-04-26 11:21:47,820 [main] DEBUG Orabbix - Starting configurator...
 2010-04-26 11:21:47,820 [main] DEBUG Orabbix - getConnection for database afcrep01P
 2010-04-26 11:21:48,461 [main] ERROR Orabbix - Error on Configurator for database afcrep01P -->Io exception: Got minus
one from a read call
 2010-04-26 11:21:48,461 [main] ERROR Orabbix - This Database afcrep01P will be removed
 2010-04-26 11:21:48,466 [main] WARN  Orabbix - New Database Founded: adding database afcrep01P
 2010-04-26 11:21:48,466 [main] DEBUG Orabbix - getConnection for database afcrep01P
 2010-04-26 11:21:48,488 [main] ERROR Orabbix - Error on Configurator for database afcrep01P -->Io exception: Got minus
one from a read call
 2010-04-26 11:21:48,488 [main] ERROR Orabbix - This Database afcrep01P will be removed
 2010-04-26 11:21:48,489 [main] DEBUG Orabbix - going in bed...and sleep for 300000 ms 

[dalle]

Hi, ...

i changed the config and removed the "dot" ... btw in my inhouse it is working with the dot.

But now i got another error message:

[root@afcarc01p ~]# tail -f /opt/orabbix/log/orabbix.log
 2010-04-26 11:21:47,820 [main] DEBUG Orabbix - Starting configurator...
 2010-04-26 11:21:47,820 [main] DEBUG Orabbix - getConnection for database afcrep01P
 2010-04-26 11:21:48,461 [main] ERROR Orabbix - Error on Configurator for database afcrep01P -->Io exception: Got minus
one from a read call
 2010-04-26 11:21:48,461 [main] ERROR Orabbix - This Database afcrep01P will be removed
 2010-04-26 11:21:48,466 [main] WARN  Orabbix - New Database Founded: adding database afcrep01P
 2010-04-26 11:21:48,466 [main] DEBUG Orabbix - getConnection for database afcrep01P
 2010-04-26 11:21:48,488 [main] ERROR Orabbix - Error on Configurator for database afcrep01P -->Io exception: Got minus
one from a read call
 2010-04-26 11:21:48,488 [main] ERROR Orabbix - This Database afcrep01P will be removed
 2010-04-26 11:21:48,489 [main] DEBUG Orabbix - going in bed...and sleep for 300000 ms 

seem that something on configuration is wrong, address name, port or something....
i've tryed and works also with "dot" in front of name.... which version of oracle are you using?
i've inluded ojdbc14.jar on my distribution of oracle 10g shouldn'te be this but just in case...

[sybex]

Hi, ...

we are using:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

I will now install the latest java version. Before it was 1.6 update 9.

[dalle]

Hi, ...

we are using:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

I will now install the latest java version. Before it was 1.6 update 9.

we are using oracle 10g Enterprise 10.2.0.4 64bit Production Release on windows 2003r2 so it's the same.
I monitor with this daemon 43 production instances and 22 test/develop instances without trouble, i'm sorry for those problem, i'm looking inside the code to help you.. if i find something i'll notice.
My Zabbix server is RedHat EL5.4 with java-1.6.0-openjdk-1.6.0.0-1.7.b09.el5

[sybex]

Hi, ...

after installing the latest java JRE 1.6.20 i got one of my two databases running.

But the original one i'd tried before have still the same problem. So Orabbix works fine.
Our DBA is now analyzing the situation and comparing the databases.

thx for your great work

[dalle]

Hi, ...

after installing the latest java JRE 1.6.20 i got one of my two databases running.

But the original one i'd tried before have still the same problem. So Orabbix works fine.
Our DBA is now analyzing the situation and comparing the databases.

thx for your great work

FINALLY!!!! I'm so happy to hear this nice day! i wasn't able to find the problem.
Thankyou for your feedback!

[dalle]

new blog

Hi to every one i've moved my blog here

http://www.smartmarmot.com/

nice day

[nayara]

Help

Hello

Sorry for Google translate English.
I am trying to configure orabbix, but it returns the error message below.
Note: the level of logging is as DEBBUG

2010-05-06 17:38:44,269 [main] INFO  Orabbix - Starting Orabbix Version 0.6
 2010-05-06 17:38:44,276 [main] DEBUG Orabbix - Starting configurator...
 2010-05-06 17:38:44,276 [main] DEBUG Orabbix - getConnection for database XXXX
 2010-05-06 17:38:45,304 [main] INFO  Orabbix - Connected as ZABBIX
 2010-05-06 17:38:45,315 [main] INFO  Orabbix - --------- on Database -> XXXX
 2010-05-06 17:38:45,318 [main] DEBUG Orabbix - retrieve connection for dbname ->XXXX
 2010-05-06 17:38:45,335 [main] DEBUG Orabbix - sharedpooldatasource idle connection -->0 active connetion -->1 dbname -->XXXX
 2010-05-06 17:38:45,335 [main] DEBUG Orabbix - Starting ZabbixTrapper for XXXX
 2010-05-06 17:38:45,343 [main] DEBUG Orabbix - going in bed...and sleep for 300000 ms
 2010-05-06 17:38:45,344 [pool-1-thread-1] DEBUG Orabbix - Starting dbJob on database XXXX
 2010-05-06 17:38:45,344 [pool-1-thread-1] DEBUG Orabbix - Actual query is archive statement is select round(A.LOGS*B.AVG/1024/1024/10) from ( SELECT COUNT (*)  LOGS FROM V$LOG_HISTORY WHERE FIRST_TIME >= (sysdate -10/60/24)) A, ( SELECT Avg(BYTES) AVG,  Count(1), Max(BYTES) Max_Bytes, Min(BYTES) Min_Bytes  FROM  v$log) B
 2010-05-06 17:38:45,376 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query archive resultset -->0
 2010-05-06 17:38:45,376 [pool-1-thread-1] DEBUG Orabbix - Actual query is audit statement is select username "username", to_char(timestamp,'DD-MON-YYYY HH24:MI:SS') "time_stamp", action_name "statement", os_username "os_username", userhost "userhost", returncode||decode(returncode,'1004','-Wrong Connection','1005','-NULL Password','1017','-Wrong Password','1045','-Insufficient Priviledge','0','-Login Accepted','--') "returncode" from sys.dba_audit_session where (sysdate - timestamp)*24 < 1 and returncode <> 0 order by timestamp

My config.props

ZabbixServer.Address=X.X.X.X
ZabbixServer.Port=10050

#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=XXXX

#Configuration of Connection pool
#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
XXXX.Url=jdbc:oracle:thin:@myserver:1521:XXXX
XXXX.User=zabbix
XXXX.Password=zzzz


#DB2.Url=jdbc:oracle:thin:@server2.domain.example.com:<LISTENER_PORT>:DB2
#DB2.User=zabbix
#DB2.Password=zabbix_password

#DB3.Url=jdbc:oracle:thin:@server3.domain.example.com:<LISTENER_PORT>:DB3
#DB3.User=zabbix
#DB3.Password=zabbix_password


#Query Parameter Files
OracleQueryListFile=/opt/orabbix/conf/query.props

vlw

[dalle]

please be patience, i don't see the error message, can you help me to find your error?

[nayara]

It turns out that the script connects to the database, executes the command, but only appears in zabbix information free memory, processor load, processor load5, processor load15 and total memory.
I found these entries in the logs.

07-MAY-10 03:40:0412154ErrorError 12154 received                                                              logging on to the standby07-MAY-10 03:45:0412154ErrorPING[ARC5]: Heartbeat fail                                                             ed to connect to standby 'xxxxstb'. Error is 12154.07-MAY-10 03:45:0412154Error                                                             Error 12154 received logging on to the standby07-MAY-10 03:50:0412154ErrorPING[A                                                             RC5]: Heartbeat failed to connect to standby 'xxxxstb'. Error is 12154.07-MAY-1                                                             0 03:50:0412154ErrorError 12154 received logging on to the standby07-MAY-10 03:5                                                             5:04

Thanks for the quick response

[untergeek]

Hmmm. I wonder if you have this set right:

#define here your connection string for each database
XXXX.Url=jdbcracle:thin:@myserver:1521:XXXX
XXXX.User=zabbix
XXXX.Password=zzzz

The XXXX.Url part, are the Xs the same, exact host name as the host that is receiving memory, load and such? Is it the same as the SID (the 1521:XXXX)?

If the hostname currently receiving memory and load information matches the first XXXX, then there is still a problem. If that hostname is the same as the SID, i.e. zabbix hostname, the first and second Xs match, then you're fine. Otherwise, Orabbix is trying to send data to a "host" that isn't defined in Zabbix.

For us, we're having separate Zabbix "hosts" that are simply the SID (since we have many databases) which are separate from the CPU and other stuff (also since we have multiple DB instances on the same physical server).

[nayara]

Hello,
Sorry about the delay in responding.
Today I found the following line in the log. Connection refused This appears to many items.

2010-05-10 10:23:18,989 [Zabbix-sender] WARN  Orabbix - Warning while sending item dgerror  on host XXXX retry number 10 error:java.net.ConnectException: Connection refused

The strange thing is that the connection orabbix can do in SQL db and be able to collect the information.
Via SQLPlus connection is established normally.

[root@zabbix ~]# sqlplus zabbix/zzzz@XXXX

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 10 11:35:36 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

My tnsname.ora

XXXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = myserver) (PORT = 1521))
(CONNECT_DATA = (SERVER = shared) (SERVICE_NAME = xxxx))
)

PS: My version of zabbix is 1.8.1.

[dalle]

this seems more that Orabbix is unable to contact the zabbix server to send the collected items.
Orabbix normally try 10 times to send the collected items to the server, if server don't respond or is anavailable write this message.
Please try do a telnet to your zabbix server configured on your configuration files on definesd port
e.g.
ZabbixServer.Address=192.168.1.1
ZabbixServer.Port=10050
you should be able to do
telnet 192.168.1.1 10050
if you receive a connection refused probably or there is a wrong address, or port or there is a firewall that don't allow connection.
NOTE: the address and the port specified are of zabbix server and not of agent.

Let me know if "telnet 192.168.1.1 10050" work
Nice evening (here at least)
Dalle

[sybex]

Hello
My config.props

ZabbixServer.Address=X.X.X.X
ZabbixServer.Port=[COLOR="red"][B]10050[/B][/COLOR]

vlw

Hi, ...

as far as i know the zabbix server port is not 10050, it is 10051.

give a try ... but this error matches also with the "Connection refused" error from the zabbix-sender.

[dalle]

Hi, ...

as far as i know the zabbix server port is not 10050, it is 10051.

give a try ... but this error matches also with the "Connection refused" error from the zabbix-sender.

yep true... i'm wrong sorry