Ad Widget

**dalle** · 25-10-2010, 16:01

Orabbix 1.1.0-rc1

THIS IS A CANDIDATE RELEASE so don't use this on production environment.

The release is available for download on my website and on sourceforge.
Any feedback is really appreciate.

more infos are available here

**Varamaster** · 26-10-2010, 17:31

Same database name

Hi, I have a problem, the database development has the same database production name ....

As I can check both databases? in zabbix not allow the same "host" name ...

**dalle** · 27-10-2010, 08:29

Originally posted by Varamaster

Hi, I have a problem, the database development has the same database production name ....

As I can check both databases? in zabbix not allow the same "host" name ...

you can't use the same host for two different object there is no way

**brian** · 16-11-2010, 00:52

ORA-02003: invalid USERENV parameter

I am trying to get Orabbix to work but I am facing some problem.

Server is Debian 6.0 (squeeze)
Java(TM) SE Runtime Environment (build 1.6.0_22-b04)
Zabbix Server version is 1.8.3
Orabbix version 1.0.4
Oracle9i Release 9.2.0.8.0 - Production
JServer Release 9.2.0.8.0 - Production

Orabbix is configured with one database:

Code:

ZabbixServerList=ZabbixServer
ZabbixServer.Address=192.168.10.20
ZabbixServer.Port=10051

DatabaseList=TST
TST.Url=jdbc:oracle:thin:@192.168.10.60:1521:TST
TST.User=zabbix
TST.Password=********

Orabbix is started, host TST is created in Zabbix. In latest data I see all the items, but only with 0 or null values. The log file:

Code:

 2010-11-15 23:32:58,542 [main] DEBUG Orabbix - Starting configurator...
 2010-11-15 23:32:58,542 [main] DEBUG Orabbix - getConnection for database TST
 2010-11-15 23:32:58,571 [main] INFO  Orabbix - Note: TST.MaxActive null
 2010-11-15 23:32:58,571 [main] INFO  Orabbix - Note: TST.MaxWait null
 2010-11-15 23:32:58,571 [main] INFO  Orabbix - Note: TST.MaxIdle null
 2010-11-15 23:32:59,070 [main] INFO  Orabbix - Connected as ZABBIX
 2010-11-15 23:32:59,072 [main] INFO  Orabbix - --------- on Database -> TST
 2010-11-15 23:32:59,089 [main] DEBUG Orabbix - Retrieve connection for dbname ->TST
 2010-11-15 23:32:59,110 [main] DEBUG Orabbix - Database TST is alive
 2010-11-15 23:32:59,111 [main] DEBUG Orabbix - sharedpooldatasource idle connection -->0 active connetion -->1 dbname -->TST
 2010-11-15 23:32:59,111 [main] DEBUG Orabbix - Starting ZabbixTrapper for TST
 2010-11-15 23:32:59,113 [main] DEBUG Orabbix - going in bed...and sleep for 300000 ms
 2010-11-15 23:32:59,113 [pool-1-thread-1] DEBUG Orabbix - Starting dbJob on database TST QueryList
 2010-11-15 23:32:59,114 [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 on database=TST
 2010-11-15 23:32:59,152 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query archive on database=TST resultset -->0
 2010-11-15 23:32:59,152 [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 on database=TST
 2010-11-15 23:32:59,154 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbblockgets statement is select to_char(sum(decode(name,'db block gets', value,0))) "block_gets" FROM v$sysstat on database=TST
 2010-11-15 23:32:59,157 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query dbblockgets on database=TST resultset -->395845175
 2010-11-15 23:32:59,157 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbconsistentgets statement is select to_char(sum(decode(name,'consistent gets', value,0))) "consistent_gets" FROM v$sysstat on database=TST
 2010-11-15 23:32:59,159 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query dbconsistentgets on database=TST resultset -->1517055034
 2010-11-15 23:32:59,160 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbhitratio statement is select ( sum(decode(name,'consistent gets', value,0)) + sum(decode(name,'db block gets', value,0)) - sum(decode(name,'physical reads', value,0))) / (sum(decode(name,'consistent gets', value,0)) + sum(decode(name,'db block gets', value,0)) ) * 100 "hit_ratio" FROM v$sysstat on database=TST
 2010-11-15 23:32:59,163 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query dbhitratio on database=TST resultset -->95.06946062548106501879732922335626134066
 2010-11-15 23:32:59,163 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbphysicalread statement is select sum(decode(name,'physical reads', value,0)) "phys_reads" FROM v$sysstat on database=TST
 2010-11-15 23:32:59,165 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query dbphysicalread on database=TST resultset -->94316298
 2010-11-15 23:32:59,165 [pool-1-thread-1] DEBUG Orabbix - Actual query is dbversion statement is select COMP_ID||' '||COMP_NAME||' '||VERSION||' '||STATUS||' <br />' from dba_registry union SELECT ' - SERVERNAME = <b>'||UTL_INADDR.get_host_name ||'</b> - SERVERADDRESS = <b>'||UTL_INADDR.get_host_address||'</b> <br />'from dual union SELECT ' - DB_NAME = <b>'||SYS_CONTEXT ('USERENV', 'DB_NAME') ||'</b> - INSTANCE_NAME = <b>' ||SYS_CONTEXT ('USERENV', 'INSTANCE_NAME')||'</b> <br />' FROM dual on database=TST
 2010-11-15 23:32:59,177 [pool-1-thread-1] ERROR Orabbix - Error on DBEnquiry on query=dbversion on database=TST Error returned is java.sql.SQLException: ORA-02003: invalid USERENV parameter

 2010-11-15 23:32:59,177 [pool-1-thread-1] WARN  Orabbix - I'm going to return  for query dbversion on database=TST
 2010-11-15 23:32:59,177 [pool-1-thread-1] DEBUG Orabbix - Actual query is hitratio_body statement is select gethitratio*100 "get_pct" FROM v$librarycache where namespace ='BODY' on database=TST
 2010-11-15 23:32:59,179 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query hitratio_body on database=TST resultset -->84.66183574879227053140096618357487922705
 2010-11-15 23:32:59,179 [pool-1-thread-1] DEBUG Orabbix - Actual query is hitratio_sqlarea statement is select gethitratio*100 "get_pct" FROM v$librarycache where namespace ='SQL AREA' on database=TST
 2010-11-15 23:32:59,180 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query hitratio_sqlarea on database=TST resultset -->97.11830921647775281522044664536982843342
 2010-11-15 23:32:59,180 [pool-1-thread-1] DEBUG Orabbix - Actual query is hitratio_table_proc statement is select gethitratio*100 "get_pct" FROM v$librarycache where namespace = 'TABLE/PROCEDURE' on database=TST
 2010-11-15 23:32:59,181 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query hitratio_table_proc on database=TST resultset -->99.8508959723543198167592362749269642483
 2010-11-15 23:32:59,182 [pool-1-thread-1] DEBUG Orabbix - Actual query is lio_current_read statement is SELECT to_char(sum(decode(name,'db block gets',value,0))) FROM V$SYSSTAT WHERE NAME ='db block gets' on database=TST
 2010-11-15 23:32:59,184 [pool-1-thread-1] DEBUG Orabbix - resultset returned from query lio_current_read on database=TST resultset -->395845175
 2010-11-15 23:32:59,184 [pool-1-thread-1] DEBUG Orabbix - Actual query is locks statement is select    sn.USERNAME ||'@'||sn.machine, '|SID->' || m.SID, '|Serial->'|| sn.SERIAL#, '|Lock Type->'||m.TYPE, decode(LMODE, 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_type, decode(REQUEST, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'Row-X (SX)', 4, 'Share', 5, 'S/Row-X (SSX)', 6, 'Exclusive') lock_requested, '|Time (Sec)->'||m.CTIME "Time(sec)", '|ID1->'||m.ID1, '|ID2->'||m.ID2, '|SQL Text->'||t.SQL_TEXT from  v$session sn, v$lock m , v$sqltext t where   t.ADDRESS =sn.SQL_ADDRESS and   t.HASH_VALUE =sn.SQL_HASH_VALUE and     ((sn.SID =m.SID and m.REQUEST !=0) or   (sn.SID =m.SID and m.REQUEST =0 and LMODE !=4 and (ID1, ID2) in (select s.ID1, s.ID2 from    v$lock S where  REQUEST !=0 and  s.ctime > 5 and        s.ID1 =m.ID1 and        s.ID2 =m.ID2))) order by sn.USERNAME, sn.SID, t.PIECE  on database=TST

If someone would point me to the right direction I would really appreciate it.

**brian** · 16-11-2010, 11:03

One addition

Since orabbix was started on the Zabbix server the load on the Oracle server jump up from 0.5 to 15. Below cou can see the CPU Load graph. The downfalls are the times when orabbix was killed and restarted.

Any hints?

Attached Files

**dalle** · 16-11-2010, 11:27

with relase 1.1.0-rc1 or with 1.0.x?
please let me know

**brian** · 16-11-2010, 11:49

Thanks for the quick reply. With latest stable (1.0.4)

I also attached the full log from yesterday evening till now.

Attached Files

orabbix.log.zip (8.8 KB, 156 views)

**dalle** · 16-11-2010, 12:09

Originally posted by brian

Thanks for the quick reply. With latest stable (1.0.4)

I also attached the full log from yesterday evening till now.

Thank you! for this feedback it's really strange.. probably introduced by jdbc I'm looking about.
Here in my environment is never happened

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

Originally posted by brian

Since orabbix was started on the Zabbix server the load on the Oracle server jump up from 0.5 to 15. Below cou can see the CPU Load graph. The downfalls are the times when orabbix was killed and restarted.

Any hints?

I've verified and it's never happened to me. I'm sorry but I can't reproduce your issue.
If happen again please let me know.

**brian** · 19-11-2010, 19:07

I am starting orabbix now on zabbix server. I will let you now. If the problem exists is it worth trying the 1.1.0rc version?

**brian** · 19-11-2010, 20:49

The problem still exists, you can see the cpu load below. Later I will try the 1.1 version.
If I can I help you debug this problem, please let me know.

Attached Files

**dalle** · 20-11-2010, 17:26

on which operating system is running?
Are you using official JVM from Oracle 1.6? i know that there are some problem with openjdk
mmm it's so strange....

**brian** · 20-11-2010, 20:18

Zabbix server:
Debian 6.0 (Squeeze)
Zabbix server 1.8.3
java version:
Java(TM) SE Runtime Environment (build 1.6.0_22-b04) (it is the sun-java6-jre package)

Oracle Server
RHEL4
Oracle 9.2.0.8
Java version (I don't know if it is important, as orabbix is running on the zabbix server)
java version "1.4.2"
gcj (GCC) 3.4.6 20060404 (Red Hat 3.4.6-10)

**dalle** · 20-11-2010, 23:55

seem all right
Orabbix on my environment run on RedHat EL 5.5 with th same release of Java, and on Windows 2003 Server R2 x64 and on an AIX 5.3 too
so it's not about java release i was hoping about

Can I log on your system?

**brian** · 22-11-2010, 14:07

Originally posted by dalle

seem all right
Orabbix on my environment run on RedHat EL 5.5 with th same release of Java, and on Windows 2003 Server R2 x64 and on an AIX 5.3 too
so it's not about java release i was hoping about

Can I log on your system?

I don't think it is possible, as they are production servers, but if you let me know what to test, I will do it.

Ad Widget

Orabbix:"Another way to monitor Oracle reloaded"

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment