[Xymon] Graphs for Oracle Monitoring

[LOZOVSKY, DANIEL L]

I checked the rrd_status log and see nothing in regard to this issue.  But, I noticed a bug being reported in regard to conn and http tests being graphed.

2017-04-17 06:22:28.210829 osprd578/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1492428148, different data
2017-04-18 02:26:11.593443 emprateplan/tcp.http.https:,,emprateplan.edc.cingular.net,erp,.rrd: Bug - duplicate RRD data with same timestamp 1492500371, different data
2017-04-18 21:45:31.242045 osprd578/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1492569931, different data

From: Deepak Chaudhary [mailto:chaudharydeepak08 at gmail.com]
Sent: Wednesday, April 19, 2017 3:46 PM
To: LOZOVSKY, DANIEL L <dl1025 at att.com>
Cc: xymon at xymon.com
Subject: Re: [Xymon] Graphs for Oracle Monitoring

I didnt faced any such problem, after a while data started populating in charts. Can you see inside your 'trends' column? or anything in log files
Regards,
Deepak

On Wed, Apr 19, 2017 at 3:26 PM, LOZOVSKY, DANIEL L <dl1025 at att.com<mailto:dl1025 at att.com>> wrote:
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<mailto:xymon-bounces at xymon.com>] On Behalf Of Deepak Chaudhary
Sent: Wednesday, April 19, 2017 3:12 PM
To: xymon at xymon.com<mailto: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 <chaudharydeepak08 at gmail.com<mailto:chaudharydeepak08 at gmail.com>> 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 <chaudharydeepak08 at gmail.com<mailto:chaudharydeepak08 at gmail.com>> 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



--
Deepak Chaudhary
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.xymon.com/pipermail/xymon/attachments/20170419/a3b940e2/attachment.html>