Graphs for Oracle Monitoring

8 messages in this thread

list Deepak Chaudhary · Tue, 18 Apr 2017 11:42:27 -0700 ·

Hi,

I was able to install / configure oracle monitoring on my xymon install per
• https://www.xymon.com/docs/xymon-oracle.html

Can someone pls help with next steps to create graphs for oracle monitoring?

Regards,
Deepak Chaudhary

list Deepak Chaudhary · Wed, 19 Apr 2017 15:10:22 -0700 ·

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::fastbbtablespacecolumn =
TblSpace::fastbblockscolumn = 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 <

▸ quoted from Deepak Chaudhary

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

Can someone pls help with next steps to create graphs for oracle
monitoring?

Regards,
Deepak Chaudhary

--


Deepak Chaudhary

list Deepak Chaudhary · Wed, 19 Apr 2017 15:11:46 -0700 ·

▸ quoted from Deepak Chaudhary

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

▸ quoted from Deepak Chaudhary


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 <

▸ quoted from Deepak Chaudhary

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::fastbbtablespacecolumn =
TblSpace::fastbblockscolumn = 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> wrote:

Hi,

I was able to install / configure oracle monitoring on my xymon install
per -

https://www.xymon.com/docs/xymon-oracle.html

Can someone pls help with next steps to create graphs for oracle
monitoring?

Regards,
Deepak Chaudhary

--
Deepak Chaudhary

--


Deepak Chaudhary

list Daniel L Lozovsky · Wed, 19 Apr 2017 22:26:47 +0000 ·

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?

▸ quoted from Deepak Chaudhary

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=>;

▸ quoted from Deepak Chaudhary

Can someone pls help with next steps to create graphs for oracle monitoring?

Regards,
Deepak Chaudhary


--
Deepak Chaudhary


--
Deepak Chaudhary

list Deepak Chaudhary · Wed, 19 Apr 2017 15:46:07 -0700 ·

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

▸ quoted from Daniel L Lozovsky


On Wed, Apr 19, 2017 at 3:26 PM, LOZOVSKY, DANIEL L <user-5085da3588ee@xymon.invalid> 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] *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> 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> 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=>;

▸ quoted from Daniel L Lozovsky


Can someone pls help with next steps to create graphs for oracle
monitoring?


Regards,

Deepak Chaudhary


--

Deepak Chaudhary


--

Deepak Chaudhary

-- 
Deepak Chaudhary

list Daniel L Lozovsky · Wed, 19 Apr 2017 22:48:22 +0000 ·

The trends column has charts but they are not being populated with the exception of rollback and invalid objects.  The rest of the charts are blank.  Occasionally when I bounced Xymon, I saw a dot appear on the empty charts and then nothing.  Let me double check the logs again.

▸ quoted from Deepak Chaudhary

From: Deepak Chaudhary [mailto:user-115a4b43ab47@xymon.invalid]
Sent: Wednesday, April 19, 2017 3:46 PM
To: LOZOVSKY, DANIEL L <user-5085da3588ee@xymon.invalid>
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 <user-5085da3588ee@xymon.invalid<mailto:user-5085da3588ee@xymon.invalid>> 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 <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

--
Deepak Chaudhary

list Daniel L Lozovsky · Wed, 19 Apr 2017 23:20:48 +0000 ·

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

▸ quoted from Deepak Chaudhary

From: Deepak Chaudhary [mailto:user-115a4b43ab47@xymon.invalid]
Sent: Wednesday, April 19, 2017 3:46 PM
To: LOZOVSKY, DANIEL L <user-5085da3588ee@xymon.invalid>
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 <user-5085da3588ee@xymon.invalid<mailto:user-5085da3588ee@xymon.invalid>> 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 <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

--
Deepak Chaudhary

list Daniel L Lozovsky · Thu, 20 Apr 2017 01:52:54 +0000 ·

▸ quoted from Daniel L Lozovsky


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<http://emprateplan.edc.cingular.net>,erp,.rrd: Bug - duplicate RRD data with same timestamp 1492500371, different data

▸ signature

2017-04-18 21:45:31.242045 osprd578/tcp.conn.rrd: Bug - duplicate RRD data with same timestamp 1492569931, different data

▸ quoted from Deepak Chaudhary

From: Deepak Chaudhary [mailto:user-115a4b43ab47@xymon.invalid]
Sent: Wednesday, April 19, 2017 3:46 PM
To: LOZOVSKY, DANIEL L <user-5085da3588ee@xymon.invalid<mailto:user-5085da3588ee@xymon.invalid>>
Cc: xymon at xymon.com<mailto: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 <user-5085da3588ee@xymon.invalid<mailto:user-5085da3588ee@xymon.invalid>> 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 <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

--
Deepak Chaudhary

Graphs for Oracle Monitoring 🔗 link

Graphs for Oracle Monitoring