Actually we managed later on to track down some of the perf issues into a
NATing configuration...
But yes, Oracle DB is kind of an overkill in my humble opinion :-)
Yeah, the OSMC program looks really good this year, but I won't be able to
attend :-( I'll have a look at the slides once they are published.
2013/7/30 Michael Friedrich <[email protected]>
> On 30.07.2013 07:32, Christophe HAEN wrote:
> > Yep, this new socket is really a good thing :-).
> > As for Oracle I am actually very glad that we gave it up, so I don't
> > want to tune anything :-)
>
> i like challenges, and therefore i have an xe install running on one of
> my test vms - also tuned. but still, real oracle dbas will know better
> once they see the amount of data being inserted/updated using idoutils.
> at least they should ;-)
>
> which is why, normal users would likely just need mysql or postgresql
> for their local icinga (web/reporting) setup, and shouldn't target their
> oracle cluster, unless they have a dedicated machine/san/diskset
> available - at least my experience with that, and you may find a
> presentation from last years osmc about that too (in German by Sven
> Wohlfarth, ING-DiBa -
>
> https://blog.netways.de/2013/07/08/osmc-2013-der-countdown-lauft-nur-noch-106-tage/
> )
>
> btw - program for osmc 2013 is online:
> http://www.netways.de/en/osmc/osmc_2013/program/ (meet me there for some
> drinks ;-) )
>
> kind regards,
> Michael
>
> >
> >
> >
> > 2013/7/29 Michael Friedrich <[email protected]
> > <mailto:[email protected]>>
> >
> > On 29.07.2013 18:34, Christophe HAEN wrote:
> > > Another blind guess (but since you seem desperate ^^): the
> > environment
> > > variables (LD_LIBRARY_PATH, ORACLE_HOME and so on) might
> disappear if
> > > the command is ran using "sudo"...
> >
> > true. run "sudo env" and show that one.
> >
> > > However for your information, we tried running icinga with Oracle
> > > something like 2 years ago. It was a major bummer, we had to go
> > > through many problems (similar to yours), we hit deadlocks and
> things
> > > like this. We replaced it with a mysql server, and since then we
> run
> > > happily :-). But maybe things got better with newer versions.
> >
> > 1.9.x marks a milestone using the socket queue, but still there are
> > other limitations with oracle (i.e. planning to put idoutils onto the
> > data warehouse cluster with other databases, and not dedicated).
> > further, you really should get to learn how to tune oracle in terms
> of
> > idoutils performance then too (which isn't trivial if you're just
> > installing software).
> >
> > >
> > > Chris
> > >
> > >
> > > 2013/7/29 Michael Friedrich <[email protected]
> > <mailto:[email protected]>
> > > <mailto:[email protected]
> > <mailto:[email protected]>>>
> > >
> > > On 29.07.2013 18:11, Dinesh wrote:
> > > > Any suggestions please.
> > >
> > > last guess - try setting --with-oracle-lib to the location of
> > > libocilib.so
> > >
> > >
> > > >
> > > >
> > > > On Jul 26, 2013, at 1:00 PM, Dinesh kumar N
> > > <[email protected] <mailto:[email protected]>
> > <mailto:[email protected] <mailto:[email protected]>>
> > > > <mailto:[email protected] <mailto:[email protected]>
> > <mailto:[email protected] <mailto:[email protected]>>>>
> > > wrote:
> > > >
> > > >> I have set the LD_LIBRARY_PATH as below
> > > >>
> > > >> echo $LD_LIBRARY_PATH
> > > >>
> > > >> /usr/local/lib:/opt/app/oracle/product/12.1.0/client_1/lib
> > > >>
> > > >> Also, here is the list of files in the /usr/local/lib directory
> > > >>
> > > >> $ pwd
> > > >>
> > > >> /usr/local/lib
> > > >>
> > > >> $ ls -ltr
> > > >>
> > > >> total 4704
> > > >>
> > > >> -rwxr-xr-x 1 root root 1256986 Jul 26 12:28 libocilib.so.3.12.0
> > > >>
> > > >> -rwxr-xr-x 1 root root 1257074 Jul 26 12:37 libocilib.so.3.12.1
> > > >>
> > > >> lrwxrwxrwx 1 root root 19 Jul 26 12:37 libocilib.so.3 ->
> > > >> libocilib.so.3.12.1
> > > >>
> > > >> lrwxrwxrwx 1 root root 19 Jul 26 12:37 libocilib.so ->
> > > libocilib.so.3.12.1
> > > >>
> > > >> -rwxr-xr-x 1 root root 864 Jul 26 12:37 libocilib.la
> > <http://libocilib.la>
> > > <http://libocilib.la> <http://libocilib.la>
> > > >>
> > > >> -rw-r--r-- 1 root root 2291740 Jul 26 12:37 libocilib.a
> > > >>
> > > >> drwxrwxrwx 2 root root 4096 Jul 26 12:37 pkgconfig
> > > >>
> > > >
> > > >
> > > >
> > >
> >
> ------------------------------------------------------------------------------
> > > > See everything from the browser to the database with AppDynamics
> > > > Get end-to-end visibility with application monitoring from
> > > AppDynamics
> > > > Isolate bottlenecks and diagnose root cause in seconds.
> > > > Start your free trial of AppDynamics Pro today!
> > > >
> > >
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> >
> > >
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> >>
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > icinga-users mailing list
> > > > [email protected]
> > <mailto:[email protected]>
> > > <mailto:[email protected]
> > <mailto:[email protected]>>
> > > > https://lists.sourceforge.net/lists/listinfo/icinga-users
> > >
> > >
> > > --
> > > DI (FH) Michael Friedrich
> > >
> > > mail: [email protected]
> > <mailto:[email protected]>
> > <mailto:[email protected]
> > <mailto:[email protected]>>
> > > twitter: https://twitter.com/dnsmichi
> > > jabber: [email protected]
> > <mailto:[email protected]> <mailto:[email protected]
> > <mailto:[email protected]>>
> > > irc: irc.freenode.net/icinga <http://irc.freenode.net/icinga>
> > <http://irc.freenode.net/icinga> dnsmichi
> > >
> > > icinga open source monitoring
> > > position: lead core developer
> > > url: https://www.icinga.org
> > >
> > >
> >
> ------------------------------------------------------------------------------
> > > See everything from the browser to the database with
> AppDynamics
> > > Get end-to-end visibility with application monitoring from
> > AppDynamics
> > > Isolate bottlenecks and diagnose root cause in seconds.
> > > Start your free trial of AppDynamics Pro today!
> > >
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> >
> > >
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> >>
> > > _______________________________________________
> > > icinga-users mailing list
> > > [email protected]
> > <mailto:[email protected]>
> > > <mailto:[email protected]
> > <mailto:[email protected]>>
> > > https://lists.sourceforge.net/lists/listinfo/icinga-users
> > >
> > >
> > >
> > >
> > > --
> > > Christophe HAEN
> > > CERN PH-LBC 2/R022
> > > Phone : +41 (0)2 27 67 31 25
> > <tel:%2B41%20%280%292%2027%2067%2031%2025>
> > > Mobile : +41 (0)7 64 87 88 57
> > <tel:%2B41%20%280%297%2064%2087%2088%2057>
> > >
> > >
> > >
> >
> ------------------------------------------------------------------------------
> > > Get your SQL database under version control now!
> > > Version control is standard for application code, but databases
> > havent
> > > caught up. So what steps can you take to put your SQL databases
> under
> > > version control? Why should you start doing it? Read more to find
> > out.
> > >
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> >
> > >
> > >
> > > _______________________________________________
> > > icinga-users mailing list
> > > [email protected]
> > <mailto:[email protected]>
> > > https://lists.sourceforge.net/lists/listinfo/icinga-users
> >
> >
> > --
> > DI (FH) Michael Friedrich
> >
> > mail: [email protected] <mailto:
> [email protected]>
> > twitter: https://twitter.com/dnsmichi
> > jabber: [email protected] <mailto:[email protected]>
> > irc: irc.freenode.net/icinga <http://irc.freenode.net/icinga>
> dnsmichi
> >
> > icinga open source monitoring
> > position: lead core developer
> > url: https://www.icinga.org
> >
> >
> >
> ------------------------------------------------------------------------------
> > Get your SQL database under version control now!
> > Version control is standard for application code, but databases
> havent
> > caught up. So what steps can you take to put your SQL databases under
> > version control? Why should you start doing it? Read more to find
> out.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> > <
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> >
> > _______________________________________________
> > icinga-users mailing list
> > [email protected]
> > <mailto:[email protected]>
> > https://lists.sourceforge.net/lists/listinfo/icinga-users
> >
> >
> >
> >
> > --
> > Christophe HAEN
> > CERN PH-LBC 2/R022
> > Phone : +41 (0)2 27 67 31 25
> > Mobile : +41 (0)7 64 87 88 57
> >
> >
> >
> ------------------------------------------------------------------------------
> > Get your SQL database under version control now!
> > Version control is standard for application code, but databases havent
> > caught up. So what steps can you take to put your SQL databases under
> > version control? Why should you start doing it? Read more to find out.
> >
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> >
> >
> >
> > _______________________________________________
> > icinga-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/icinga-users
>
>
> --
> DI (FH) Michael Friedrich
>
> mail: [email protected]
> twitter: https://twitter.com/dnsmichi
> jabber: [email protected]
> irc: irc.freenode.net/icinga dnsmichi
>
> icinga open source monitoring
> position: lead core developer
> url: https://www.icinga.org
>
>
> ------------------------------------------------------------------------------
> Get your SQL database under version control now!
> Version control is standard for application code, but databases havent
> caught up. So what steps can you take to put your SQL databases under
> version control? Why should you start doing it? Read more to find out.
> http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
> _______________________________________________
> icinga-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/icinga-users
>
--
Christophe HAEN
CERN PH-LBC 2/R022
Phone : +41 (0)2 27 67 31 25
Mobile : +41 (0)7 64 87 88 57
------------------------------------------------------------------------------
Get your SQL database under version control now!
Version control is standard for application code, but databases havent
caught up. So what steps can you take to put your SQL databases under
version control? Why should you start doing it? Read more to find out.
http://pubads.g.doubleclick.net/gampad/clk?id=49501711&iu=/4140/ostg.clktrk
_______________________________________________
icinga-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/icinga-users
