RE: [hobbit] dbcheck for RAC connections refused

[Martin Flemming <martin.flemming (at) desy.de>]

Hi, Franceso !

Thanks for the hint, it looks better/cleaner now, but the error is still exist ...

"
/usr/lib/hobbit/server #  bin/bbcmd ext/dbcheck.pl -t atlast1
2009-07-30 08:08:28 Using default environment file /usr/lib/hobbit/server/etc/hobbitserver.cfg
Thu Jul 30 08:08:29 2009:ERROR on atlast1: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-1   ;port=1521          ;sid=atlast1      !
"




[it-wgs02] /usr/lib/hobbit/server #  bin/bbcmd perl -d  ext/dbcheck.pl -t atlast1
2009-07-30 08:05:59 Using default environment file /usr/lib/hobbit/server/etc/hobbitserver.cfg

Loading DB routines from perl5db.pl version 1.27
Editor support available.

Enter h or `h h' for help, or `man perldebug' for more help.

Hobbit_fd_lib::CODE(0x9505830)(/usr/lib/hobbit/server/ext/Hobbit_fd_lib.pm:1222):1222:           &load_config ;  DB<1> n
Hobbit_fd_lib::CODE(0x9505830)(/usr/lib/hobbit/server/ext/Hobbit_fd_lib.pm:1223):1223:           &get_disabled_hosts;  DB<1> n
Hobbit_fd_lib::CODE(0x9505830)(/usr/lib/hobbit/server/ext/Hobbit_fd_lib.pm:1224):1224:           my $pv=sprintf "%vd", $^V;  DB<1> n
Hobbit_fd_lib::CODE(0x9505830)(/usr/lib/hobbit/server/ext/Hobbit_fd_lib.pm:1225):1225:           my $sv=$Sys::SigAction::VERSION;  DB<1> n
Hobbit_fd_lib::CODE(0x9505830)(/usr/lib/hobbit/server/ext/Hobbit_fd_lib.pm:1226):1226:           if (($pv =~ /5\.8\.0/) && ($sv !~ /0\.09/)) {  DB<1> n
main::(ext/dbcheck.pl:39):      my ($orahome, @listahost, $dbhost, $port, $username, $password, $dbtype, $sid,$onlycustomcheck);  DB<1> n
main::(ext/dbcheck.pl:40):      my (%warnhash,%alerthash,$invobjignore,$invobjwarn,@invobjwlist,@invobjilist,$checkuserlist,%customcheck);  DB<1> n
main::(ext/dbcheck.pl:41):      my ($sendtv,$singlesendas,%selcmd,$raccheck, @KeyToCheck,@CustomKeyToCheck);  DB<1> n
main::(ext/dbcheck.pl:43):      my %DBCHECK = (main::(ext/dbcheck.pl:44):                     oracle           => [ "fulltest","conn","audit","tablespace","extent","hitcache","memreq",
main::(ext/dbcheck.pl:45):                                           "rollback","invobj","locks","session" ],
main::(ext/dbcheck.pl:46):                     oracledef        => [ "Database","ChkConn::fast","Audit::fast","TblSpace::fast","Extent::slow",
main::(ext/dbcheck.pl:47):                                           "HitCache::fast","MemReq::fast", "RollBack::slow","InvObj::fast",
main::(ext/dbcheck.pl:48):                                           "Locks::fast","Session::fast" ],
main::(ext/dbcheck.pl:49):                     informix         => [ "fulltest","conn","tablespace" ],
main::(ext/dbcheck.pl:50):                     informixdef      => [ "Database","ChkConn::fast","TblSpace::fast" ],
main::(ext/dbcheck.pl:51):                     sqlserver        => [ "fulltest","conn","tablespace" ],
main::(ext/dbcheck.pl:52):                     sqlserverdef     => [ "Database","ChkConn::fast","TblSpace::fast" ],
main::(ext/dbcheck.pl:53):                     mysql            => [ "fulltest","conn","mysqlperf" ],
main::(ext/dbcheck.pl:54):                     mysqldef         => [ "MySQL","ChkConn::fast","mysqlperf::fast" ],
main::(ext/dbcheck.pl:55):                     db2              => [ "fulltest","conn","tablespace" ],
main::(ext/dbcheck.pl:56):                     db2def           => [ "DB2","ChkConn::fast","TblSpace::fast" ],
main::(ext/dbcheck.pl:57):                   );  DB<1> n
main::(ext/dbcheck.pl:59):      my $CHECKLIST = [ "pinlib:95:90", "blbuff:95:90", "rowcache:95:90", "tblsp:90:95", "hitcache:95:90", "rollback:90:95",
main::(ext/dbcheck.pl:60):                                      "session:90:95", "process:90:95", "memreq:90:95", "extent:90:95" ];  DB<1> n
main::(ext/dbcheck.pl:63):              @listahost=&Hobbit_fd_lib::get_server_to_test($TEST) if (! (at) listahost);  DB<1> n
main::(ext/dbcheck.pl:64):              &Hobbit_fd_lib::execute_thread(\&execute_db_test ,@listahost);  DB<1> n
Thu Jul 30 08:06:27 2009:ERROR on atlast1: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-1   ;port=1521          ;sid=atlast1      !

Debugged program terminated.  Use q to quit or R to restart,
  use O inhibit_exit to avoid stopping after program termination,
  h q, h R or h O to get additional info.
main::(ext/dbcheck.pl:65):              exit;
  DB<1>

... and the logfile e.g.

Thu Jul 30 11:45:37 2009:ERROR on atlas_tag_db: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-4   ;port=1521         ;sid=atlas_tag_db  !
Thu Jul 30 11:45:37 2009:ERROR on atlast1: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-1   ;port=1521          ;sid=atlast1      !
Thu Jul 30 11:45:37 2009:ERROR on atlast3: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-3  ;port=1521          ;sid=atlast3       !
Thu Jul 30 11:45:37 2009:ERROR on atlast2: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-2   ;port=1521          ;sid=atlast2       !
Thu Jul 30 11:45:37 2009:ERROR on atlast4: Timeout connecting to DBI:Oracle:host=lcg3d-a-v-4  ;port=1521         ;sid=atlast4   !



Any suggestions for further debugging ?

thanks & cheers

	martin


On Thu, 30 Jul 2009, Francesco Duranti wrote:

> Hi,
> dbcheck.pl (and the other scripts in the package) use the CONFIG::IniFiles to read configuration data. CONFIG::Inifiles allow comment line starting with "#" and ";" but I think it will not recognize the "#" comment at the middle of a line so if you need comments you should put them alone on the line before or next to the line to comment on.
>
> On some of the sample config file I've put some comment next to parameters and this could probably generate confusion. I'll change the sample config file and put this behavious also in the documentation I'm writing for the next version (the actual documentation is not really well written and organized).
>
>
> Francesco
>
>
> On Wed, July 29, 2009 15:29, martin.flemming (at) desy.de wrote:
> > Hi !
> >
> > I want to use dbcheck.pl from
> >
> > http://sourceforge.net/projects/hobbit-perl-cl/
> >
> > .. but unfortunatley something is going wrong, i get only
> > "Connection Refused" Messages and no data  .. :-(
> >
> > My config is below:
> [SNIP]
> > dbcheck.ini:
> >
> > oraclehome              = /opt/products/oracle-client/10.2g/
> > username                = XXXX
> > password                = XXXXXXXXXXXXXXXXXXXXXXX
> >
> >
> > [atlas_tag_db]
> > dbtype                  = Oracle
> > oraclerac               = yes
> > hostname                = lcg3d-a-v-4   # hostname of the rac instance n.2
> > sid                     = atlas_tag_db  # sid of the rac instance n.2
> > port                    = 1521          # port of listener on rac instance
>
>
> I don't use this code, but your error output suggests that it's trying to
> use your hostname, sid, and port from dbcheck.ini exactly as written,
> comments and all.  I don't see anything in the sample dbcheck.ini file
> that suggests that you can use trailing comments in the way that you are
> doing, so perhaps you should try without those.
>
>
> To unsubscribe from the hobbit list, send an e-mail to
> hobbit-unsubscribe (at) hswn.dk