R: [hobbit] RE [hobbit] Database test: dbcheck.pl on deadcat and sourceforge
The script will monitor all the database from a single host that have access to the database and the database client installed. The better thing to do is to run them on the server where you have all the configuration of hobbit in a unique place but it can also be run on a client (not tested but should work). To run them you can use the hobbitlaunch.cfg or clientlaunch.cfg (if you're running on a client).
To do all the check i use 2 section in the hobbitlaunch.cfg of the hobbit server to check the database with different timing. I use to launch a fast check every 5 minutes that will only check for connection, audit table, tablespace, session and cache (because i graph them and i want the 5 minutes data) and a slow test that do the rest of the check (rollback and extent check on some of the database I'm checking take 10-15 minutes to run so i prefer to run them every 4 hour).
[dbfast] ENVFILE /home/bbtest/server/etc/hobbitserver.cfg NEEDS hobbitd CMD $BBHOME/ext/dbcheck.pl fast LOGFILE $BBSERVERLOGS/bb-dbfast.log INTERVAL 5m [dbslow] ENVFILE /home/bbtest/server/etc/hobbitserver.cfg NEEDS hobbitd CMD $BBHOME/ext/dbcheck.pl slow LOGFILE $BBSERVERLOGS/bb-dbslow.log INTERVAL 240m
I will check for the 2 problem you got. If you not did it try to run bbcmd dbcheck.pl instead of running directly the command (or launch bbcmd bash and then run the ./dbcheck.pl). I also got a problem on the extent check, a new version will be available during this week to solve those problems and to add some documentation :D
Thanks for the report
Francesco
-----Messaggio originale----- Da: thomas.seglard.enata at cnp.fr [mailto:thomas.seglard.enata at cnp.fr] Inviato: lunedì 7 agosto 2006 14.18 A: hobbit at hswn.dk Oggetto: [hobbit] RE [hobbit] Database test: dbcheck.pl on deadcat and sourceforge
Hello Francesco !
Thans for all your scripts and work ! It looks amazing... However I don't understand the way it works. Sorry.... I'm talking about the dbcheck test. Here are my questions :
These scripts have to be executed on the hobbit server or on Hobbit clients ?
In both cases, have we to setup hobbitlaunch.cfg or clientlaunch.cfg to run the check ?
I'm running Hobbit v4.1.2p1 and when launching dbcheck.pl I got this output :
[hobbit at psu155 ext]$ ./dbcheck.pl Use of uninitialized value in concatenation (.) or string at ./dbcheck.pl line 806. Use of uninitialized value in concatenation (.) or string at ./dbcheck.pl line 78. Could not open the disabled hosts directory: No such file or directory Could not close the DISABLED directory handle: No such file or director
I commented out corresponding lines and these warnings disappear.
Thanks again for all your hard work ! Best regards,
Thomas
"Francesco Duranti" <fduranti at q8.it> a écrit sur 06/08/2006 18:44:15 :
Hello all, I've just released the first version of a perl script to check oracle/informix/sqlserver databases. It can be found on deadcat and at http://sourceforge.net/projects/hobbit-perl-cl/
This perl script will get data from the Database Server using DBI/DBD Perl Library. At this moment it will work with SQLServer,Oracle and Informix (I will add mysql in the near future). For sqlserver and informix for now only connection and database space are checked. For oracle there are many tests done (mostly the same as the bb-roracle.ksh + some custom ones):Connection, Audit table report, Tablespace, Extent, PinLib/HitCache, Memory Request, Invalid Objects, Rollback, Locks, Sessions and Processes. The program was fully tested under Hobbit but should work also on BB. The tests are not done if the connection test is failing. Sessions and Cache statistics are also gathered for graphs by hobbit.
Thanks all :D
Francesco
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite au titre de ce message, s'il a ete altere, deforme ou falsifie.
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
Thanks for support ! Here is output when using bbcmd :
[hobbit at psi200 server]$ ./bin/bbcmd ext/dbcheck.pl 2006-08-07 16:18:45 Using default environment file /Soft/HOBBIT-4.1.2p1/server/etc/hobbitserver.cfg Environment checking /Soft/HOBBIT-4.1.2p1/data/disabled
It's better ! But nothing appears on my Hobbit display... So I'm missing something. I've set up a section into dbcheck.ini like this :
[psu155] # hostname of one oracle server dbtype = Oracle hostname = psu155 sid = HALSE1 username = vantage password = vantage port = 1521 tbl.SYSTEM = 101:101
and added this line to my bb-hosts :
0.0.0.0 psu155 # noconn dbcheck
And still no new column on my display. I'm checking port and names. Sincerly,
Thomas
"Francesco Duranti" <fduranti at q8.it> a écrit sur 07/08/2006 15:50:39 :
The script will monitor all the database from a single host that have access to the database and the database client installed. The better thing to do is to run them on the server where you have all the configuration of hobbit in a unique place but it can also be run on a client (not tested but should work). To run them you can use the hobbitlaunch.cfg or clientlaunch.cfg (if you're running on a client).
To do all the check i use 2 section in the hobbitlaunch.cfg of the hobbit server to check the database with different timing. I use to launch a fast check every 5 minutes that will only check for connection, audit table, tablespace, session and cache (because i graph them and i want the 5 minutes data) and a slow test that do the rest of the check (rollback and extent check on some of the database I'm checking take 10-15 minutes to run so i prefer to run them every 4 hour).
[dbfast] ENVFILE /home/bbtest/server/etc/hobbitserver.cfg NEEDS hobbitd CMD $BBHOME/ext/dbcheck.pl fast LOGFILE $BBSERVERLOGS/bb-dbfast.log INTERVAL 5m [dbslow] ENVFILE /home/bbtest/server/etc/hobbitserver.cfg NEEDS hobbitd CMD $BBHOME/ext/dbcheck.pl slow LOGFILE $BBSERVERLOGS/bb-dbslow.log INTERVAL 240m
I will check for the 2 problem you got. If you not did it try to run bbcmd dbcheck.pl instead of running directly the command (or launch bbcmd bash and then run the ./dbcheck.pl). I also got a problem on the extent check, a new version will be available during this week to solve those problems and to add some documentation :D
Thanks for the report
Francesco
-----Messaggio originale----- Da: thomas.seglard.enata at cnp.fr [mailto:thomas.seglard.enata at cnp.fr] Inviato: lunedì 7 agosto 2006 14.18 A: hobbit at hswn.dk Oggetto: [hobbit] RE [hobbit] Database test: dbcheck.pl on deadcat and sourceforge
Hello Francesco !
Thans for all your scripts and work ! It looks amazing... However I don't understand the way it works. Sorry.... I'm talking about the dbcheck test. Here are my questions :
These scripts have to be executed on the hobbit server or on Hobbit clients ?
In both cases, have we to setup hobbitlaunch.cfg or clientlaunch. cfg to run the check ?
I'm running Hobbit v4.1.2p1 and when launching dbcheck.pl I got this output :
[hobbit at psu155 ext]$ ./dbcheck.pl Use of uninitialized value in concatenation (.) or string at./dbcheck.pl line 806. Use of uninitialized value in concatenation (.) or string at ./dbcheck.pl line 78. Could not open the disabled hosts directory: No such file ordirectory Could not close the DISABLED directory handle: No such file or director
I commented out corresponding lines and these warnings disappear.
Thanks again for all your hard work ! Best regards,
Thomas
"Francesco Duranti" <fduranti at q8.it> a écrit sur 06/08/2006 18:44:15 :
Hello all, I've just released the first version of a perl script to check oracle/informix/sqlserver databases. It can be found on deadcat and at http://sourceforge.net/projects/hobbit-perl-cl/
This perl script will get data from the Database Server using DBI/DBD > > Perl Library. At this moment it will work with SQLServer,Oracle and Informix (I will add mysql in the near future). For sqlserver and informix for now only connection and database space > > are checked. For oracle there are many tests done (mostly the same as > > the bb-roracle.ksh + some custom ones):Connection, Audit table report, Tablespace, Extent, PinLib/HitCache, Memory Request, Invalid Objects, > > Rollback, Locks, Sessions and Processes. The program was fully tested under Hobbit but should work also on BB. > > The tests are not done if the connection test is failing. Sessions and Cache statistics are also gathered for graphs by hobbit.
Thanks all :D
Francesco
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite au titre de ce message, s'il a ete altere, deforme ou falsifie.
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.
To unsubscribe from the hobbit list, send an e-mail to hobbit- unsubscribe at hswn.dk
To unsubscribe from the hobbit list, send an e-mail to hobbit-unsubscribe at hswn.dk
Ce message (et toutes ses pieces jointes eventuelles) est confidentiel et etabli a l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme a sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse. L'internet ne permettant pas d'assurer l'integrite de ce message, CNP Assurances et ses filiales declinent toute responsabilite au titre de ce message, s'il a ete altere, deforme ou falsifie.
This message and any attachments (the "message") are confidential and intended solely for the addressees. Any unauthorised use or dissemination is prohibited. E-mails are susceptible to alteration. Neither CNP Assurances nor any of its subsidiaries or affiliates shall be liable for the message if altered, changed or falsified.
participants (2)
-
fduranti＠q8.it
-
thomas.seglard.enata＠cnp.fr