I have charts come up but they are not being populated. The only charts that have data populated are rollback segments and invalid objects. Not sure why the data is not coming in for the other charts. I am using xymon 4.3.27 which I just installed for the first time. I finally got rid of my BigBrother BTF hack and converted to xymon. One of my issues is this dbcheck charts not coming up with data.
Does anyone have any suggestions?
From: Xymon [mailto:xymon-bounces at xymon.com] On Behalf Of Deepak Chaudhary
Sent: Wednesday, April 19, 2017 3:12 PM
To: xymon at xymon.com
Subject: Re: [Xymon] Graphs for Oracle Monitoring
I was able to figure it out reading some documentation.
In case, if anyone gets stuck, add like last few lines -
[bbhost] this is the name that dbcheck will report to hobbit/bb
dbtype = Can be Oracle/Informix/SQLServer
hostname = hostname for database (not needed if you want to use oracle tnsnames or for informix)
sid = database sid (for informix this is the database name in the sqlhosts file)
username = database username
password = database password
port = database port (not needed for oracle using tnsnames and informix)
bbsessioncolumn = Session::fast
bbtablespacecolumn = TblSpace::fast
bblockscolumn = Locks::fast
Last 4 lines will enable corresponding test columns and graph will generate accordingly. More documentation is available in ini file.
Have fun.
On Wed, Apr 19, 2017 at 3:10 PM, Deepak Chaudhary <user-115a4b43ab47@xymon.invalid<mailto:user-115a4b43ab47@xymon.invalid>> wrote:
I was able to figure it out reading some documentation.
In case, if anyone gets stuck, add like last few lines -
[bbhost] this is the name that dbcheck will report to hobbit/bb
dbtype = Can be Oracle/Informix/SQLServer
hostname = hostname for database (not needed if you want to use oracle tnsnames or for informix)
sid = database sid (for informix this is the database name in the sqlhosts file)
username = database username
password = database password
port = database port (not needed for oracle using tnsnames and informix)
bbsessioncolumn = Session::fast
bbtablespacecolumn = TblSpace::fast
bblockscolumn = Locks::fast
Last 4 lines will enable corresponding test columns and graph will generate accordingly. More documentation is available in ini file.
Have fun.
On Tue, Apr 18, 2017 at 11:42 AM, Deepak Chaudhary <user-115a4b43ab47@xymon.invalid<mailto:user-115a4b43ab47@xymon.invalid>> wrote:
Hi,
I was able to install / configure oracle monitoring on my xymon install per -
https://www.xymon.com/docs/xymon-oracle.html<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.xymon.com_docs_xymon-2Doracle.html&d=DwMFaQ&c=LFYZ-o9_HUMeMTSQicvjIg&r=hvhxsFi99sfEwu3u2bGOgA&m=xJFEnWkAP_3pJXPiqp9-a04xepGC66z5-ta4Jfn_6mU&s=Vns16_71-2mc-evHmHmE6B9PQ7rAhhP0vgy5T_Z2PY8&e=>;
Can someone pls help with next steps to create graphs for oracle monitoring?
Regards,
Deepak Chaudhary
--
Deepak Chaudhary
--
Deepak Chaudhary