Xymon Mailing List Archive search

dbcheck for RAC connections refused

list Xymon User in Richmond
Wed, 29 Jul 2009 18:40:09 -0400
Message-Id: <user-2def01f93d29@xymon.invalid>

On Wed, July 29, 2009 15:29, user-f286aaa49a76@xymon.invalid 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
n.2
username                = XXXX
password                = XXXXXXXXXXXX

[atlast1]
dbtype                  = Oracle
hostname                = lcg3d-a-v-1   # hostname of the rac instance n.2
sid                     = atlast1       # sid of the rac instance n.2
port                    = 1521          # port of listener on rac instance
n.2
username                = XXXX
password                = XXXXXXXXXXX

[atlast2]
dbtype                  = Oracle
hostname                = lcg3d-a-v-2   # hostname of the rac instance n.2
sid                     = atlast2       # sid of the rac instance n.2
port                    = 1521          # port of listener on rac instance
n.2
username                = XXXXX
password                = XXXXXXXXXXXXXXX


[atlast3]
dbtype                  = Oracle
hostname                = lcg3d-a-v-3   # hostname of the rac instance n.2
sid                     = atlast3       # sid of the rac instance n.2
port                    = 1521          # port of listener on rac instance
n.2
username                = XXXXXX
password                = XXXXXXXXXXXXXXXX

[atlast4]
dbtype                  = Oracle
hostname                = lcg3d-a-v-4   # hostname of the rac instance n.2
sid                     = atlast4       # sid of the rac instance n.2
port                    = 1521          # port of listener on rac instance
n.2
username                = XXXXXXXX
password                = XXXXXXXXXXXXXXXXXXX
[SNIP]
Errors
No General Errors
atlas_tag_db
Wed Jul 29 18:52:47 2009:ERROR: Timeout connecting to
DBI:Oracle:host=lcg3d-a-v-4   # hostname of the rac instance n.2;port=1521
# port of listener on rac instance n.2;sid=atlas_tag_db  # sid of the rac
instance n.2!
atlast1
Wed Jul 29 18:52:47 2009:ERROR: Timeout connecting to
DBI:Oracle:host=lcg3d-a-v-1   # hostname of the rac instance n.2;port=1521
# port of listener on rac instance n.2;sid=atlast1       # sid of the rac
instance n.2!
atlast2
Wed Jul 29 18:52:47 2009:ERROR: Timeout connecting to
DBI:Oracle:host=lcg3d-a-v-2   # hostname of the rac instance n.2;port=1521
# port of listener on rac instance n.2;sid=atlast2       # sid of the rac
instance n.2!
atlast3
Wed Jul 29 18:52:47 2009:ERROR: Timeout connecting to
DBI:Oracle:host=lcg3d-a-v-3   # hostname of the rac instance n.2;port=1521
# port of listener on rac instance n.2;sid=atlast3       # sid of the rac
instance n.2!
atlast4
Wed Jul 29 18:52:47 2009:ERROR: Timeout connecting to
DBI:Oracle:host=lcg3d-a-v-4   # hostname of the rac instance n.2;port=1521
# port of listener on rac instance n.2;sid=atlast4       # sid of the rac
instance n.2!

Warnings
No General Warnings
No Hosts Warnings


dbcheck.pl version 1.08 - column dbcheck lifetime 60, tested in ~ 00:00:01
(max 00:02:00)

I use the old and also the new version of dbcheck.pl ...

Any idea why could my enviroment be damaged ?
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.