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