Orabbix:"Another way to monitor Oracle reloaded"

[harishgupta111]

here is the attached log file.

[dalle]

here is the attached log file.

2011-12-02 02:47:43,689 [pool-1-thread-14] DEBUG Orabbix - Starting dbJob on database OrderPath QueryList
2011-12-02 02:47:43,691 [pool-1-thread-14] DEBUG Orabbix - sending <req><host>T3JkZXJQYXRo</host><key>YWxpdmU=</key><data>MQ==</data></req>
2011-12-02 02:47:43,692 [pool-1-thread-14] DEBUG Orabbix - received OK
after "OK" i see a lot of "null" values... I have no clue from where they come from
you can try to use .trim to trim the input

[dalle]

here is the attached log file.

wait a sec. you have difined as TEXT your item right?
because on screenshot i see number!
let me know

[harishgupta111]

here is the attached screen shot of ITEM

[harishgupta111]

hi

Hey Dalli,

Thanks buddy.

Its done.

actually mistake is on my side...
This was the error because of privileges
Exception received ORA-01031: insufficient privileges

Thanks very much

[dalle]

Hey Dalli,

Thanks buddy.

Its done.

actually mistake is on my side...
This was the error because of privileges
Exception received ORA-01031: insufficient privileges

Thanks very much

Well, bufff
because I had no clue about your issue

[Minken]

Couldn't find the answer in the thread so i'm asking, i'm having a problem with a requirement, "ensure the name of your host in Zabbix is the same name of the SID or Oracle instance name". The reason is that I wish to monitor several embedded Oracle databases spread out over different networks. However the Oracle database instances are all named the same for all the installations. That means that the centralized Zabbix installation will have to have multiple hosts with the same identical name also and that doesn't seem to be possible correct?

Now I'm wondering, is there a way around this?

[dalle]

Couldn't find the answer in the thread so i'm asking, i'm having a problem with a requirement, "ensure the name of your host in Zabbix is the same name of the SID or Oracle instance name". The reason is that I wish to monitor several embedded Oracle databases spread out over different networks. However the Oracle database instances are all named the same for all the installations. That means that the centralized Zabbix installation will have to have multiple hosts with the same identical name also and that doesn't seem to be possible correct?

Now I'm wondering, is there a way around this?

Yes there is a way!
If you have all your instances called e.g. ORCL but on different server you can simply call them inside the configuration file ORCL_SERVER1, ORCL_SERVER2 etc... afte you need to create inside zabbix ORCL_SERVER1, ORCL_SERVER2 etc..
and inside the config file you should do something like:
ORCL_SERVER1.Url=jdbcracle:thin:@SERVER1.EXAMPLE.COM:1521:ORCL
ORCL_SERVER2.Url=jdbcracle:thin:@SERVER2.EXAMPLE.COM:1521:ORCL
ORCL_SERVER3.Url=jdbcracle:thin:@SERVER3.EXAMPLE.COM:1521:ORCL

I hope everything is clear in case of dubt feel free to ask!
let me know
Andrea

[Minken]

Thanks that should do it! Just another quick question, has anyone tried Orabbix with Zabbix 2.0 (1.9.x)?

[jehster]

Hello,

I'd like to use Orabbix to monitor my Oracle servers, but beetwen my zabbix and oracle, there is a zabbix proxy.
I admit that I did not read all the thread (quite big ), but I did not find any information about this with search engine.

Is it possible to monitor oracle servers using Orabbix even if we have proxies ?

regards
Jerome

[dalle]

Hello,

I'd like to use Orabbix to monitor my Oracle servers, but beetwen my zabbix and oracle, there is a zabbix proxy.
I admit that I did not read all the thread (quite big ), but I did not find any information about this with search engine.

Is it possible to monitor oracle servers using Orabbix even if we have proxies ?

regards
Jerome

Yes I know this thread it's become quite huge
If you can connect to your oracle databases there are no problem at all. I mean if your proxy/firewall has a "proxy agent" and you can permit connection between your zabbix server and Oracle this should be enough.
If you can't connect to oracle you can't monitor your databases.

regards
Andrea

[jehster]

When I talk about proxies, I mean Zabbix proxies. These ones can connect to Oracle. Zabbix server can't.
Is it mandatory that zabbix server can connect to Oracle ? Can't I install Orabbix on zabbix proxy or ,better, on oracle servers ?

(actually, I make it work on Oracle server, but I can't get values on zabbix server :/ )

[dalle]

When I talk about proxies, I mean Zabbix proxies. These ones can connect to Oracle. Zabbix server can't.
Is it mandatory that zabbix server can connect to Oracle ? Can't I install Orabbix on zabbix proxy or ,better, on oracle servers ?

(actually, I make it work on Oracle server, but I can't get values on zabbix server :/ )

I'm sorry I didn't undestood I never tried to send Orabbix's data to a proxy.
You can install Orabbix where you want on linux, unix(aix/hp-ux) or windows I have an Orabbix installed on a Linux server and another one on windows (neither of them has a Zabbix installed)
Let me know

[harishgupta111]

hi

Hi,

I am trying to install orabbix on HP-UX 11.23. here is the code of my run.sh file

When am trying to execute this command. Its giving me error:

/opt/orabbix: log4j:WARN No appenders could be found for logger (Orabbix).
log4j:WARN Please initialize the log4j system properly.

I checkd all the path. But not getting ny idea... Please tell me why this problem is coming.

Thanks in advance.

[dalle]

Whate there is inside the log4j config file specified by
-Dlog4j.configuration=/opt/orabbix/conf/log4j.properties
please let me know

Hi,

I am trying to install orabbix on HP-UX 11.23. here is the code of my run.sh file

When am trying to execute this command. Its giving me error:

/opt/orabbix: log4j:WARN No appenders could be found for logger (Orabbix).
log4j:WARN Please initialize the log4j system properly.

I checkd all the path. But not getting ny idea... Please tell me why this problem is coming.

Thanks in advance.