[hobbit] Monitoring SQL

[Darren.Cotton at ses-astra.com]

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.