Hi guys,
What is the simplest way I can monitor my Sql databases using hobbit ?
De : Nikesh Maharaj [mailto:NMaharaj at tcta.co.za] 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."
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: johan.boye at latecoere.fr [mailto:johan.boye at latecoere.fr] Sent: donderdag 6 december 2007 11:32 To: hobbit at hswn.dk Subject: RE: [hobbit] Monitoring SQL
De : Nikesh Maharaj [mailto:NMaharaj at tcta.co.za] 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."
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
Le Fri, 7 Dec 2007 14:01:47 +0100, "Klomp, H." <klomph at nlr.nl> 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: johan.boye at latecoere.fr [mailto:johan.boye at latecoere.fr] Sent: donderdag 6 december 2007 11:32 To: hobbit at hswn.dk Subject: RE: [hobbit] Monitoring SQL
De : Nikesh Maharaj [mailto:NMaharaj at tcta.co.za] 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
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
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" <bgmilne at staff.telkomsa.net> To: <hobbit at hswn.dk> Cc: "Klomp, H." <klomph at nlr.nl> 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
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" <bgmilne at staff.telkomsa.net> To: <hobbit at hswn.dk> Cc: "Klomp, H." <klomph at nlr.nl> 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
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:bgmilne at staff.telkomsa.net] Sent: vrijdag 7 december 2007 17:02 To: hobbit at hswn.dk 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
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
Le Thu, 13 Dec 2007 17:43:19 +0200, Buchan Milne <bgmilne at staff.telkomsa.net> 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
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:linuxmasterjedi at free.fr] Sent: donderdag 13 december 2007 18:19 To: hobbit at hswn.dk Subject: Re: [hobbit] Monitoring SQL
Le Thu, 13 Dec 2007 17:43:19 +0200, Buchan Milne <bgmilne at staff.telkomsa.net> 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
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."
<klomph at nlr.nl>
To
14/12/2007 09:15 "'hobbit at hswn.dk'" <hobbit at hswn.dk>
cc
Please respond to Subject
hobbit at hswn.dk 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:linuxmasterjedi at free.fr] Sent: donderdag 13 december 2007 18:19 To: hobbit at hswn.dk Subject: Re: [hobbit] Monitoring SQL
Le Thu, 13 Dec 2007 17:43:19 +0200, Buchan Milne <bgmilne at staff.telkomsa.net> 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
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
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.
Le Fri, 14 Dec 2007 09:09:28 +0100, "Klomp, H." <klomph at nlr.nl> 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 ;)
participants (7)
-
bgmilne＠staff.telkomsa.net
-
Darren.Cotton＠ses-astra.com
-
johan.boye＠latecoere.fr
-
klomph＠nlr.nl
-
linuxmasterjedi＠free.fr
-
NMaharaj＠tcta.co.za
-
rlapuz＠fcpp.fujitsu.com