Hi,
the output ok mk_oracle -t is:
<<<oracle_instance>>>
<<<oracle_sessions>>>
<<<oracle_logswitches>>>
<<<oracle_undostat>>>
<<<oracle_recovery_area>>>
<<<oracle_processes>>>
<<<oracle_recovery_status>>>
<<<oracle_longactivesessions>>>
<<<oracle_dataguard_stats>>>
<<<oracle_performance>>>
<<<oracle_locks>>>
<<<oracle_tablespaces>>>
<<<oracle_instance>>>
<<<oracle_processes>>>
<<<oracle_asm_diskgroup>>>
ORA-99998 Couldn’t find /etc/check_mk/sqlnet.ora
···
On Sun, Jul 2, 2017 at 11:15 PM, Thorsten Bruhns thorsten.bruhns@googlemail.com wrote:
Hi Gad,
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.
Kind Regards
Thorsten
2017-07-02 8:31 GMT+02:00 Gad Shaked gad.shaked@gmail.com:
Hi
the query “select * from dba_free_space;” returns the result instantly.
Regards,
Gad
On Fri, Jun 30, 2017 at 10:43 PM, Thorsten Bruhns thorsten.bruhns@googlemail.com wrote:
Hi Gad,
this sound like a known issue in Oracle…
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.
Kind Regards
Thorsten Bruhns
2017-06-29 9:23 GMT+02:00 Gad Shaked gad.shaked@gmail.com:
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.
what am I doing wrong.
p.s,
I am running
Check_MK 1.4.0p7
Thank you,
Gad
checkmk-en mailing list