I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
Hi Cuong,
I did everything according to the guide you mentioned and also according to the guide one check_mk’s web site
discovering the host using WATO finds all kinds of parameters concerning the Oracle instance however none of them regarding the table spaces themselves.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
What version of Check_MK agent and server are you using?
Do you see a section 'oracle_tablespaces' in the agent output?
Regards,
Evy
···
On 30/06/17 17:18, Gad Shaked wrote:
Hi Cuong,
I did everything according to the guide you mentioned and also according
to the guide one check_mk's web site
<https://mathias-kettner.de/checkmk_oracle.html>
discovering the host using WATO finds all kinds of parameters concerning
the Oracle instance however none of them regarding the table
spaces themselves.
any ideas?
thank you,
Gad
On Fri, Jun 30, 2017 at 5:55 PM, Cường Lê <lecuongitlc@gmail.com > <mailto:lecuongitlc@gmail.com>> wrote:
Hi Gad,
I did it on Oracle 10g in AIX 5.3 and Oracle 11g in Redhat 6. Which
steps did you do? I think you've missing something.
It's Vietnamese language. Please use Google translate to English.
Hope this help you.
Rgds,
Cuong.
Sent from my BlackBerry 10 smartphone.
*From: *Gad Shaked
*Sent: *Friday, June 30, 2017 21:47
*To: *checkmk-en@lists.mathias-kettner.de
<mailto:checkmk-en@lists.mathias-kettner.de>
*Subject: *Re: [Check_mk (english)] Monitoring free space in Oracle
11 Database
Hi,
Anyone here had success discovering oracle database instances table
spaces?
Thank you,
Gad
On Thu, Jun 29, 2017 at 10:23 AM, Gad Shaked <gad.shaked@gmail.com > <mailto:gad.shaked@gmail.com>> wrote:
Hi,
I am trying to monitor free space in oracle 11 database
tablespace. the oracle is running on a Red Hat Enterprise Linux
Server release 5 .
to do so, I have installed the
"check-mk-agent-1.4.0p7-1.noarch.rpm" on the oracle server and
configured the relevant setting in mk_oracle.cfg after granting
the check_mk user the relevant permissions on the Oracle level.
also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high
level of the specific oracle instance performance details, but
does not provide any table space specific details.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
are you sure that the tablespace section is the problem?
The RMAN and tablespace sections are executed in async mode.
Did you execute the test mode?
mk_oracle -t
What is the output?
Edit the mk_oracle.cfg
ASYNC_SECTIONS=“tablespaces”
Repeat the testmode and execute the plugin when async_sections only display the tablespace. You can add the other async_sections from the 1st test to find the section with the problem.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
are you sure that the tablespace section is the problem?
The RMAN and tablespace sections are executed in async mode.
Did you execute the test mode?
mk_oracle -t
What is the output?
Edit the mk_oracle.cfg
ASYNC_SECTIONS=“tablespaces”
Repeat the testmode and execute the plugin when async_sections only display the tablespace. You can add the other async_sections from the 1st test to find the section with the problem.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
The “ORA-99998 Couldn’t find /etc/check_mk/sqlnet.ora” message is from these lines in mk_oracle:
TNS_ADMIN=${TNS_ADMIN:-$MK_CONFDIR}
test -f ${TNS_ADMIN}/sqlnet.ora || ( echo "ORA-99998 Couldn’t find "${TNS_ADMIN}/sqlnet.ora ; exit 1)
I saw no good reason for needing a sqlnet.ora file in $MK_CONFDIR so I just commented those two lines out.
I also changed the following in mk_oracle (v1.30):
SQL in “sql_sessions” to query count from v$session instead of v$resource_limit, as a non-current value was returned by v$resource_limit
SQL sub-query for “sql_jobs” to be an IN of dba_scheduler_job_run_details only
Alias of v$database in “sql_jobs” to be DB
-BK
This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Payfone, C2014
are you sure that the tablespace section is the problem?
The RMAN and tablespace sections are executed in async mode.
Did you execute the test mode?
mk_oracle -t
What is the output?
Edit the mk_oracle.cfg
ASYNC_SECTIONS=“tablespaces”
Repeat the testmode and execute the plugin when async_sections only display the tablespace. You can add the other async_sections from the 1st test to find the section with the problem.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
The “ORA-99998 Couldn’t find /etc/check_mk/sqlnet.ora” message is from these lines in mk_oracle:
TNS_ADMIN=${TNS_ADMIN:-$MK_CONFDIR}
test -f ${TNS_ADMIN}/sqlnet.ora || ( echo "ORA-99998 Couldn’t find "${TNS_ADMIN}/sqlnet.ora ; exit 1)
I saw no good reason for needing a sqlnet.ora file in $MK_CONFDIR so I just commented those two lines out.
I also changed the following in mk_oracle (v1.30):
SQL in “sql_sessions” to query count from v$session instead of v$resource_limit, as a non-current value was returned by v$resource_limit
SQL sub-query for “sql_jobs” to be an IN of dba_scheduler_job_run_details only
Alias of v$database in “sql_jobs” to be DB
-BK
This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Payfone, C2014
are you sure that the tablespace section is the problem?
The RMAN and tablespace sections are executed in async mode.
Did you execute the test mode?
mk_oracle -t
What is the output?
Edit the mk_oracle.cfg
ASYNC_SECTIONS=“tablespaces”
Repeat the testmode and execute the plugin when async_sections only display the tablespace. You can add the other async_sections from the 1st test to find the section with the problem.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
The “ORA-99998 Couldn’t find /etc/check_mk/sqlnet.ora” message is from these lines in mk_oracle:
TNS_ADMIN=${TNS_ADMIN:-$MK_CONFDIR}
test -f ${TNS_ADMIN}/sqlnet.ora || ( echo "ORA-99998 Couldn’t find "${TNS_ADMIN}/sqlnet.ora ; exit 1)
I saw no good reason for needing a sqlnet.ora file in $MK_CONFDIR so I just commented those two lines out.
I also changed the following in mk_oracle (v1.30):
SQL in “sql_sessions” to query count from v$session instead of v$resource_limit, as a non-current value was returned by v$resource_limit
SQL sub-query for “sql_jobs” to be an IN of dba_scheduler_job_run_details only
Alias of v$database in “sql_jobs” to be DB
-BK
This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Payfone, C2014
are you sure that the tablespace section is the problem?
The RMAN and tablespace sections are executed in async mode.
Did you execute the test mode?
mk_oracle -t
What is the output?
Edit the mk_oracle.cfg
ASYNC_SECTIONS=“tablespaces”
Repeat the testmode and execute the plugin when async_sections only display the tablespace. You can add the other async_sections from the 1st test to find the section with the problem.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.
The “ORA-99998 Couldn’t find /etc/check_mk/sqlnet.ora” message is from these lines in mk_oracle:
TNS_ADMIN=${TNS_ADMIN:-$MK_CONFDIR}
test -f ${TNS_ADMIN}/sqlnet.ora || ( echo "ORA-99998 Couldn’t find "${TNS_ADMIN}/sqlnet.ora ; exit 1)
I saw no good reason for needing a sqlnet.ora file in $MK_CONFDIR so I just commented those two lines out.
I also changed the following in mk_oracle (v1.30):
SQL in “sql_sessions” to query count from v$session instead of v$resource_limit, as a non-current value was returned by v$resource_limit
SQL sub-query for “sql_jobs” to be an IN of dba_scheduler_job_run_details only
Alias of v$database in “sql_jobs” to be DB
-BK
This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use, or distribution of the information included in this message and any attachments is prohibited. If you have received this communication in error, please notify us by reply e-mail and immediately and permanently delete this message and any attachments. Payfone, C2014
are you sure that the tablespace section is the problem?
The RMAN and tablespace sections are executed in async mode.
Did you execute the test mode?
mk_oracle -t
What is the output?
Edit the mk_oracle.cfg
ASYNC_SECTIONS=“tablespaces”
Repeat the testmode and execute the plugin when async_sections only display the tablespace. You can add the other async_sections from the 1st test to find the section with the problem.
There were some issues in the plugin in the past but the current problems are related to the data dictionary in Oracle.
Does the following SQL return a result in a very short time?
select * from dba_free_space;
If Oracle need >5 Seconds for this SQL then look at the recycle bin. There are a lot of issue with recycle bin and dba_free_space which are really known from 11.2 up to 12.1. I didn’t tested it on 12.2, bedause I disable the recycle bin in every database. Don’t forget to purge the objects - otherwise the SQL is still slow.
Finally don’t forget to gather dictionary statistics and the problem should be gone.
This has nothing to do with Check_MK. Every monitoring who tries to gather data from dba_free_space is hitting this issue.
I am trying to monitor free space in oracle 11 database tablespace. the oracle is running on a Red Hat Enterprise Linux Server release 5 .
to do so, I have installed the “check-mk-agent-1.4.0p7-1.noarch.rpm” on the oracle server and configured the relevant setting in mk_oracle.cfg after granting the check_mk user the relevant permissions on the Oracle level. also I have the /usr/lib/check_mk_agent/plugins/mk_oracle in place.
My problem is the the discovery of the host only returns high level of the specific oracle instance performance details, but does not provide any table space specific details.