Monitoring SQL
list Nikesh Maharaj
Hi guys, What is the simplest way I can monitor my Sql databases using hobbit ?
list Johan Boyé
De : Nikesh Maharaj [mailto:user-000aaf9a8455@xymon.invalid] Hi guys, What is the simplest way I can monitor my Sql databases using hobbit ?
I would recommand "dbcheck.pl" from the package http://sourceforge.net/project/showfiles.php?group_id=173266 I'm free for extra information, I just setup on Linux "Les informations contenues dans ce message electronique peuvent etre de nature confidentielles et soumises a une obligation de secret. Elles sont destinees a l'usage exclusif du reel destinataire. Si vous n'etes pas le reel destinataire, ou si vous recevez ce message par erreur, merci de le detruire immediatement et de le notifier a son emetteur." "The information contained in this e-mail may be privileged and confidential. It is intended for the exclusive use of the designated recipients named above. If you are not the intended recipient or if you receive this e-mail in error, please delete it and immediately notify the sender."
list H. Klomp
Hi All, Can someone tell me what I need to install on the hobbit server to get dbcheck.pl working with oracle ? I think I may need to install some oracle client software, but what is neccessary ? Regards, Bert Klomp
▸
-----Original Message-----
From: user-08b3b26d089f@xymon.invalid [mailto:user-08b3b26d089f@xymon.invalid]
Sent: donderdag 6 december 2007 11:32
To: user-ae9b8668bcde@xymon.invalid
Subject: RE: [hobbit] Monitoring SQL
De : Nikesh Maharaj [mailto:user-000aaf9a8455@xymon.invalid] Hi guys, What is the simplest way I can monitor my Sql databases using hobbit ?
I would recommand "dbcheck.pl" from the package http://sourceforge.net/project/showfiles.php?group_id=173266 I'm free for extra information, I just setup on Linux "Les informations contenues dans ce message electronique peuvent etre de nature confidentielles et soumises a une obligation de secret. Elles sont destinees a l'usage exclusif du reel destinataire. Si vous n'etes pas le reel destinataire, ou si vous recevez ce message par erreur, merci de le detruire immediatement et de le notifier a son emetteur." "The information contained in this e-mail may be privileged and confidential. It is intended for the exclusive use of the designated recipients named above. If you are not the intended recipient or if you receive this e-mail in error, please delete it and immediately notify the sender."
list L.M.J
Le Fri, 7 Dec 2007 14:01:47 +0100,
▸
"Klomp, H." <user-b644cde19b47@xymon.invalid> a écrit :
Hi All, Can someone tell me what I need to install on the hobbit server to get dbcheck.pl working with oracle ? I think I may need to install some oracle client software, but what is neccessary ? Regards, Bert Klomp
Hello Klomp No, dbcheck.pl needs some perl extension who will handle the oracle connexion, no need a Oracle Client installed ;)
▸
-----Original Message-----From: user-08b3b26d089f@xymon.invalid [mailto:user-08b3b26d089f@xymon.invalid] Sent: donderdag 6 december 2007 11:32 To: user-ae9b8668bcde@xymon.invalid Subject: RE: [hobbit] Monitoring SQLDe : Nikesh Maharaj [mailto:user-000aaf9a8455@xymon.invalid] Hi guys, What is the simplest way I can monitor my Sql databases using hobbit ?I would recommand "dbcheck.pl" from the package http://sourceforge.net/project/showfiles.php?group_id=173266 I'm free for extra information, I just setup on Linux
list Buchan Milne
▸
On Friday 07 December 2007 15:01:47 Klomp, H. wrote:
Hi All, Can someone tell me what I need to install on the hobbit server to get dbcheck.pl working with oracle ? I think I may need to install some oracle client software, but what is neccessary ?
Oracle client libraries, and perl DBD::Oracle. You may get more hints on the easiest way to get it running if you tell us what OS this is. Regards, Buchan
list Ryan Jay B. Lapuz
Hi All, I have the same problem with Bert. Our Oracle database is installed in SunOS 5.6 and 5.9. Any help is much appreciated. Thanks in advance! Regards, Ryan ----- Original Message ----- From: "Buchan Milne" <user-9b139aff4dec@xymon.invalid> To: <user-ae9b8668bcde@xymon.invalid> Cc: "Klomp, H." <user-b644cde19b47@xymon.invalid> Sent: Saturday, December 08, 2007 12:01 AM Subject: Re: [hobbit] Monitoring SQL
▸
On Friday 07 December 2007 15:01:47 Klomp, H. wrote:Hi All, Can someone tell me what I need to install on the hobbit server to get dbcheck.pl working with oracle ? I think I may need to install some oracle client software, but what is neccessary ?Oracle client libraries, and perl DBD::Oracle. You may get more hints on the easiest way to get it running if you tell us what OS this is. Regards, Buchan
list L.M.J
▸
Hi All, I have the same problem with Bert. Our Oracle database is installed in SunOS 5.6 and 5.9. Any help is much appreciated. Thanks in advance! Regards, Ryan
dbcheck.pl is not capricious at all. Just check out if you installed all perl libs needed such are DBD:Oracle and some pcre stuff. Good luck
▸
----- Original Message ----- From: "Buchan Milne" <user-9b139aff4dec@xymon.invalid> To: <user-ae9b8668bcde@xymon.invalid> Cc: "Klomp, H." <user-b644cde19b47@xymon.invalid> Sent: Saturday, December 08, 2007 12:01 AM Subject: Re: [hobbit] Monitoring SQLOn Friday 07 December 2007 15:01:47 Klomp, H. wrote:Hi All, Can someone tell me what I need to install on the hobbit server to get dbcheck.pl working with oracle ? I think I may need to install some oracle client software, but what is neccessary ?Oracle client libraries, and perl DBD::Oracle. You may get more hints on the easiest way to get it running if you tell us what OS this is. Regards, Buchan
list H. Klomp
Dear Buchan, Sorry for the inconvenience. I forgot to mention our Operating system. The Hobbit server is running on Redhat Enterprise Server. Oracle is also running on a RedHat Linux system. I hope this is enough information for you to be able to help me in pointing out what I need to install to get dbcheck.pl running for Oracle. Thanks in advance, Bert Klomp
▸
-----Original Message-----
From: Buchan Milne [mailto:user-9b139aff4dec@xymon.invalid]
Sent: vrijdag 7 december 2007 17:02
To: user-ae9b8668bcde@xymon.invalid
Cc: Klomp, H.
Subject: Re: [hobbit] Monitoring SQL
On Friday 07 December 2007 15:01:47 Klomp, H. wrote:Hi All, Can someone tell me what I need to install on the hobbit server to get dbcheck.pl working with oracle ? I think I may need to install some oracle client software, but what is neccessary ?
Oracle client libraries, and perl DBD::Oracle. You may get more hints on the easiest way to get it running if you tell us what OS this is. Regards, Buchan
list Buchan Milne
▸
On Monday 10 December 2007 10:04:37 Klomp, H. wrote:
Dear Buchan, Sorry for the inconvenience. I forgot to mention our Operating system. The Hobbit server is running on Redhat Enterprise Server. Oracle is also running on a RedHat Linux system. I hope this is enough information for you to be able to help me in pointing out what I need to install to get dbcheck.pl running for Oracle.
If the Hobbit server is on the same server as the Oracle server, I think you just need perl DBD::Oracle. If not, you need to install the oracleinstantclient rpm on the Hobbit server, then perl DBD::Oracle. I think freshrpms.net has a perl-DBD-Oracle package. Ryan, the OS of the Oracle server is irrelevant, only the OS of the Hobbit server is relevant. Regards, Buchan
list L.M.J
Le Thu, 13 Dec 2007 17:43:19 +0200,
▸
Buchan Milne <user-9b139aff4dec@xymon.invalid> a écrit :
On Monday 10 December 2007 10:04:37 Klomp, H. wrote:Dear Buchan, Sorry for the inconvenience. I forgot to mention our Operating system. The Hobbit server is running on Redhat Enterprise Server. Oracle is also running on a RedHat Linux system. I hope this is enough information for you to be able to help me in pointing out what I need to install to get dbcheck.pl running for Oracle.If the Hobbit server is on the same server as the Oracle server, I think you just need perl DBD::Oracle. If not, you need to install the oracleinstantclient rpm on the Hobbit server, then perl DBD::Oracle. I think freshrpms.net has a perl-DBD-Oracle package. Ryan, the OS of the Oracle server is irrelevant, only the OS of the Hobbit server is relevant. Regards, Buchan
I *think* (check out the README files in dbcheck.pl) you don't need any client to check databases nor tnsnames.ora
list H. Klomp
With only the dbcheck.pl I get the message that dbcheck can't find the oraclehome directory. According to our oracle dba I need a local part of oracle to be able to send commands to the database. I will try to install the orcaleinstantclient and the install the perl DBD::Oracle module. Just installing the perl module also generates the message that the oraclehome is not found. I have to wait for our Oracle DBA to continue testing but keep you all informed. Thanks for the tips you send so far.
▸
Regards,
Bert Klomp
-----Original Message-----
From: L.M.J [mailto:user-78bb6d5d9024@xymon.invalid]
Sent: donderdag 13 december 2007 18:19
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Monitoring SQL
Le Thu, 13 Dec 2007 17:43:19 +0200,
Buchan Milne <user-9b139aff4dec@xymon.invalid> a écrit :
On Monday 10 December 2007 10:04:37 Klomp, H. wrote:Dear Buchan, Sorry for the inconvenience. I forgot to mention our Operating system. The Hobbit server is running on Redhat Enterprise Server. Oracle is also running on a RedHat Linux system. I hope this is enough information for you to be able to help me in pointing out what I need to install to get dbcheck.pl running for Oracle.If the Hobbit server is on the same server as the Oracle server, I think you just need perl DBD::Oracle. If not, you need to install the oracleinstantclient rpm on the Hobbit server, then perl DBD::Oracle. I think freshrpms.net has a perl-DBD-Oracle package. Ryan, the OS of the Oracle server is irrelevant, only the OS of the Hobbit server is relevant. Regards, Buchan
I *think* (check out the README files in dbcheck.pl) you don't need any client to check databases nor tnsnames.ora
list Darren Cotton
Bert,
For myself I also had to install the oracle instantclient (with the sqlplus
bit also) as I have addition sql queries running on my box.
Therefore If I am reading it right I think it may mean that your
ORACLE_HOME variable is simply not set. In my config /etc/profile I have
the following entries (oracle related):
export ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client
export ORACLE_BASE=/usr/lib/oracle/10.2.0.3
export LD_LIBRARY_PATH=/usr/lib/oracle/10.2.0.3/client/lib
export LD_RUN_PATH=/usr/lib/oracle/10.2.0.3/client
export TNS_ADMIN=/usr/lib/oracle/10.2.0.3/client/network/admin
Obviously you should replace the path of the local oracle installation with
those of yours.
Check if that helps...
Darren Cotton
"Klomp, H."
<user-b644cde19b47@xymon.invalid>
To
14/12/2007 09:15 "'user-ae9b8668bcde@xymon.invalid'" <user-ae9b8668bcde@xymon.invalid>
cc
Please respond to Subject
user-ae9b8668bcde@xymon.invalid RE: [hobbit] Monitoring SQL
▸
With only the dbcheck.pl I get the message that dbcheck can't find the
oraclehome directory.
According to our oracle dba I need a local part of oracle to be able to
send commands to the database.
I will try to install the orcaleinstantclient and the install the perl
DBD::Oracle module.
Just installing the perl module also generates the message that the
oraclehome is not found.
I have to wait for our Oracle DBA to continue testing but keep you all
informed.
Thanks for the tips you send so far.
Regards,
Bert Klomp
-----Original Message-----
From: L.M.J [mailto:user-78bb6d5d9024@xymon.invalid]
Sent: donderdag 13 december 2007 18:19
To: user-ae9b8668bcde@xymon.invalid
Subject: Re: [hobbit] Monitoring SQL
Le Thu, 13 Dec 2007 17:43:19 +0200,
Buchan Milne <user-9b139aff4dec@xymon.invalid> a écrit :
On Monday 10 December 2007 10:04:37 Klomp, H. wrote:Dear Buchan, Sorry for the inconvenience. I forgot to mention our Operating system. The Hobbit server is running on Redhat Enterprise Server. Oracle is also running on a RedHat Linux system. I hope this is enough information for you to be able to help me in pointing out what I need to install to get dbcheck.pl running for Oracle.If the Hobbit server is on the same server as the Oracle server, I think you just need perl DBD::Oracle. If not, you need to install the oracleinstantclient rpm on the Hobbit server, then perl DBD::Oracle. I think freshrpms.net has a perl-DBD-Oracle package. Ryan, the OS of the Oracle server is irrelevant, only the OS of the
Hobbit
server is relevant. Regards, Buchan
I *think* (check out the README files in dbcheck.pl) you don't need any client to check databases nor tnsnames.ora
DISCLAIMER:
This e-mail contains proprietary information some or all of which may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this e-mail.
list L.M.J
Le Fri, 14 Dec 2007 09:09:28 +0100,
▸
"Klomp, H." <user-b644cde19b47@xymon.invalid> a écrit :
With only the dbcheck.pl I get the message that dbcheck can't find the oraclehome directory. According to our oracle dba I need a local part of oracle to be able to send commands to the database. I will try to install the orcaleinstantclient and the install the perl DBD::Oracle module. Just installing the perl module also generates the message that the oraclehome is not found.
Sorry to confuse you. I through the client was not needed. I have it anyway on the box for other stuffs. Get the client running by configuring tnsnames.ora and dbcheck.pl will do the rest ;)
list Johan Boyé
You should post on the mailing list too. Check the file README.dbcheck, most of the information are there. Basicaly, you copy dbcheck.pl & dbcheck.sh to ext/ and dbcheck.ini to etc/ Good luck ;)
-----Message d'origine----- De : Nikesh Maharaj [mailto:user-000aaf9a8455@xymon.invalid] Envoyé : mercredi 19 décembre 2007 13:03 À : BOYE Johan Objet : RE: [hobbit] Monitoring SQL Hi, I have downloaded and extracted the files. Where can I find the docs to install this please ? Thanks
▸
-----Original Message----- From: user-08b3b26d089f@xymon.invalid [mailto:user-08b3b26d089f@xymon.invalid]De : Nikesh Maharaj [mailto:user-000aaf9a8455@xymon.invalid] Hi guys,What is the simplest way I can monitor my Sql databases using hobbit ?I would recommand "dbcheck.pl" from the package http://sourceforge.net/project/showfiles.php?group_id=173266 I'm free for extra information, I just setup on Linux
"Les informations contenues dans ce message électronique peuvent être de nature confidentielles et soumises à une obligation de secret. Elles sont destinées à l'usage exclusif du réel destinataire. Si vous n'êtes pas le réel destinataire, ou si vous recevez ce message par erreur, merci de le détruire immédiatement et de le notifier à son émetteur."
▸
"The information contained in this e-mail may be privileged and confidential. It is intended for the exclusive use of the designated recipients named above. If you are not the intended recipient or if you receive this e-mail in error, please delete it and immediately notify the sender."