Another way to monitor Oracle

[mfric]

Orabbix - disabled items

Hello, I'd like to ask if orabbix is querying also for disabled items in zabbix when they are queryies in query.props for this item.

Thanks.

[bllack]

Hello,
How can i fix this problem?

root@zab /e/z/externalscripts# ./check_ora.sh -i dbname      
./check_ora.sh: 108: ./check_ora.sh: Bad substitution      
root@zab /e/z/externalscripts# ./check_ora.sh -i dbname -s   
./check_ora.sh: 108: ./check_ora.sh: Bad substitution 

in log at that moment:

 WARN  Orabbix - Error while executing ->pool_misc- on database ->dbname- Exception received ORA-00942: table or view does not exist                                                 
 WARN  Orabbix - Error while executing ->pool_sql_area- on database ->dbname- Exception received ORA-00942: table or view does not exist 

but that tables are exist:

SQL> SELECT TO_CHAR(ROUND(SUM(decode(pool,'shared pool',decode(name,'library cache',0,'dictionary cache',0,'free memory',0,'sql area',                                                                                        
    0,(bytes)/(1024*1024)),0)),2)) pool_misc                                                                   
FROM V$SGASTAT;  2    3                                                                                        
                                                                                                               
POOL_MISC                                                                                                      
----------------------------------------                                                                       
1302,62 

SQL> SELECT    TO_CHAR(ROUND(SUM(decode(pool,'shared pool',decode(name,'sql area',(bytes)/(1024*1024),0),0)),2)) pool_sql_area                                                                                                
FROM V$SGASTAT;  2                                                                                             
                                                                                                               
POOL_SQL_AREA                                                                                                  
----------------------------------------                                                                       
0 

[dalle]

"try to check if path is correct (inside the script) and if you can use-it."
what doed this mean?vi zabbix_send or change the zabbix_send to be root user?

try to call zabbix_send inside your oracle user and see if enviroment's variable are right and everything work
Try to see if you can call zabbix_send try to see if the specified path inside the scripts is right...
just unix's admin stuff

[483]

If you have everything configure on "oracle" user you should be able to use zabbix_send under "oracle" user, try to check if path is correct (inside the script) and if you can use-it.
Your issue seem caused by this kind of error.
let me know
btw It's holyday here so on next week I will not reply

"try to check if path is correct (inside the script) and if you can use-it."
what doed this mean?vi zabbix_send or change the zabbix_send to be root user?

[dalle]

If you have everything configure on "oracle" user you should be able to use zabbix_send under "oracle" user, try to check if path is correct (inside the script) and if you can use-it.
Your issue seem caused by this kind of error.
let me know
btw It's holyday here so on next week I will not reply

[483]

when i use
"UserParameter=pool_free_memery,/etc/zabbix/externalscripts/check_ora/check_ora_sendtrap.sh -i orcl -q pool_free_mem
UserParameter=waitsqlnet,/etc/zabbix/externalscripts/check_ora/check_ora_sendtrap.sh -i orcl -q waits_sqlnet"
write it in the zabbix_agentd.conf.
I can get a number use ,"/etc/zabbix/externalscripts/check_ora/check_ora_sendtrap.sh -i orcl -q waits_sqlnet"
in the terminal it has the answer.but when i use "pool_free_memery","waitsqlnet"as the key of the agent.but i can't get a Item key to monitor in the zabbix web.(I create oracle user .I only can open the oracle using oracle user.I can't open it with the root or zabbix user.how can i chanslate it .and every user can open the oracle).
can you help me?

[dalle]

zabbix server logs attached; Thanks!

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

[dalle]

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

[SeMaTech]

zabbix server logs attached; Thanks!

[dalle]

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]

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!!

[dalle]

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

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]

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!

[vlam]

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

./run.sh
[[email protected] 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)

[vlam]

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