This is what i normally do to check a RAC DB + single RAC instance
in the configuration:
oraclehome = /usr/local/oracle/10.2.0/client/
bbdisplay = localhost
bbconncolumn = ChkConn::fast
bbauditcolumn = Audit::fast
bbtablespacecolumn = TblSpace::fast
bbextentcolumn = Extent::slow
bbhitcachecolumn = HitCache::fast
bbmemreqcolumn = MemReq::fast
bbrollbackcolumn = RollBack::slow
bbinvobjcolumn = InvObj::fast
bblockscolumn = Locks::fast
bbsessioncolumn = Session::fast
bbsessionuserlist = yes
username = userxxx
password = pwxxxxx
[CL10G]
oraclerac = yes
bbhitcachecolumn = HitCache:notest
bbmemreqcolumn = MemReq:notest
[CL10G1]
hostname = itromdb21
bbauditcolumn = Audit:notest
bbtablespacecolumn = TblSpace:notest
bbextentcolumn = Extent:notest
bbrollbackcolumn = RollBack:notest
bblockscolumn = Locks:notest
bbinvobjcolumn = InvObj:notest
[CL10G2]
hostname = itromdb22
bbauditcolumn = Audit:notest
bbtablespacecolumn = TblSpace:notest
bbextentcolumn = Extent:notest
bbrollbackcolumn = RollBack:notest
bblockscolumn = Locks:notest
bbinvobjcolumn = InvObj:notest
In tnsnames.ora (under ORACLE_HOME/network/admin) I've those
configuration:
CL10G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITROMDB21)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ITROMDB22)(PORT = 1521))
(LOAD_BALANCE = no)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cl10g)
)
)
CL10G2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITROMDB22)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cl10g)
(INSTANCE_NAME = cl10g2)
)
)
CL10G1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ITROMDB21)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cl10g)
(INSTANCE_NAME = cl10g1)
)
)
With this setting I normally use the tnsnames.ora configuration
for RAC (I was able to check RAC database only using tnsnames.ora not directly.
You can try to remove the hostname and port from the db
configuration for the RAC.
If the SID is equal to the name of the DB to check (the one in [])
you can also remove the sid line from the configuration.
You can also try to connect with a telnet to the hostname and
listener port to see if it answer (or better you can configure on
the client the tnsnames.ora and do a tnsping to see if the instances are answering).
As you can see I don't do some checks on the RAC itselft or on the
single instances... For example I don't test memreq and hitcache on
the RAC and I don't check TblSpace, Extent, Rollback, locks,
invalid objects on the single instances.
Please check also on the configuration file and remove all ending
space after host or port or sid. I don't know if it can create
problems (I'll check this also and remove those from the
configuration option for the next version).
Let me know if this work for you or you have other problems.
Francesco
-----Original Message-----
From: Martin Flemming [mailto:martin.flemming (at) desy.de]
Sent: giovedì 30 luglio 2009 11.47
To: hobbit (at) hswn.dk
Subject: RE: [hobbit] dbcheck for RAC connections refused
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,
main:: $port, $username, $password, $dbtype,
$sid,$onlycustomcheck);
main:: DB<1> n
main:: (ext/dbcheck.pl:40): my
main::
(%warnhash,%alerthash,$invobjignore,$invobjwarn,@invobjwlist,@invob
jilist,$checkuserlist,%customcheck);
main:: DB<1> n
main:: (ext/dbcheck.pl:41): my
main:: ($sendtv,$singlesendas,%selcmd,$raccheck,
main:: @KeyToCheck,@CustomKeyToCheck); DB<1> n
main:: (ext/dbcheck.pl:43): my %DBCHECK =
main:: (main::(ext/dbcheck.pl:44): oracle
main:: => [
main::
"fulltest","conn","audit","tablespace","extent","hitcache","memreq"
,
main:: (ext/dbcheck.pl:45):
main:: "rollback","invobj","locks","session" ],
main:: (ext/dbcheck.pl:46): oracledef => [
main::
"Database","ChkConn::fast","Audit::fast","TblSpace::fast","Extent::
slow",
main:: (ext/dbcheck.pl:47):
main:: "HitCache::fast","MemReq::fast",
"RollBack::slow","InvObj::fast",
main:: (ext/dbcheck.pl:48):
main:: "Locks::fast","Session::fast" ],
main:: (ext/dbcheck.pl:49): informix => [
main:: "fulltest","conn","tablespace" ],
main:: (ext/dbcheck.pl:50): informixdef => [
main:: "Database","ChkConn::fast","TblSpace::fast" ],
main:: (ext/dbcheck.pl:51): sqlserver => [
main:: "fulltest","conn","tablespace" ],
main:: (ext/dbcheck.pl:52): sqlserverdef => [
main:: "Database","ChkConn::fast","TblSpace::fast" ],
main:: (ext/dbcheck.pl:53): mysql => [
main:: "fulltest","conn","mysqlperf" ],
main:: (ext/dbcheck.pl:54): mysqldef => [
main:: "MySQL","ChkConn::fast","mysqlperf::fast" ],
main:: (ext/dbcheck.pl:55): db2 => [
main:: "fulltest","conn","tablespace" ],
main:: (ext/dbcheck.pl:56): db2def => [
main:: "DB2","ChkConn::fast","TblSpace::fast" ],
main:: (ext/dbcheck.pl:57): ); DB<1> n
main:: (ext/dbcheck.pl:59): my $CHECKLIST = [ "pinlib:95:90",
main:: "blbuff:95:90", "rowcache:95:90", "tblsp:90:95",
"hitcache:95:90",
main:: "rollback:90:95",
main:: (ext/dbcheck.pl:60):
main:: "session:90:95", "process:90:95", "memreq:90:95", "extent:90:95"
main:: ]; DB<1> n
main:: (ext/dbcheck.pl:63):
main:: @listahost=&Hobbit_fd_lib::get_server_to_test($TEST) if
main:: (! (at) listahost); DB<1> n
main:: (ext/dbcheck.pl:64):
main:: &Hobbit_fd_lib::execute_thread(\&execute_db_test
,@listahost);
main:: 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.