[Check_mk (english)] CheckMK 1.5.0p11 mk_oracle plugin

Thorsten Bruhns thorsten.bruhns at googlemail.com
Thu Feb 28 06:27:51 CET 2019


Hi Minh,
I thought that this is related to 'Werk #6738: mk_oracle: Plugin is
compatible against 18c', but I think it is a different problem.
It looks like the 'ASYNC'-Sections are not executed.. This is mostly due to
performenance problems with oracle_rman and/or oracle_tablespace SQL.
Please try to create new statistics for fixed objects and data dictionary
objects with dbms_stats. This is not automatically done by Oracle with the
daily job.

One of the most common problems is the stupid recyclebin in Oracle. Try to
purge the recyclebin. This problem is known since the implementation in 10g.

Another issue is the select for RMAN in combination with the controlfile.
Mostly fresh statistics can solve this issue. If you had a high number of
archivelogs between a backup, the section for delete rews in the
controlfile can increase with problems during the selection of backup
information from the Controlfile. This is also a known issue in Oracle for
many years...


Kind Regards
Thorsten Bruhns

Am Mi., 27. Feb. 2019 um 08:15 Uhr schrieb Minh Tuan Nguyen via checkmk-en <
checkmk-en at lists.mathias-kettner.de>:

> Hi everyone,
>
>
>
> We want to monitor Oracle Db version 18. Unfortunately, only few checks
> show up
>
> checkmk at ASKO30SWLOGGP1 /home/checkmk: mk_oracle
>
> <<<oracle_instance>>>
>
> <<<oracle_performance>>>
>
> <<<oracle_recovery_area>>>
>
> <<<oracle_recovery_status>>>
>
> <<<oracle_jobs>>>
>
> <<<oracle_locks>>>
>
> <<<oracle_logswitches>>>
>
> <<<oracle_longactivesessions>>>
>
> <<<oracle_processes>>>
>
> <<<oracle_resumable>>>
>
> <<<oracle_rman>>>
>
> <<<oracle_sessions>>>
>
> <<<oracle_tablespaces>>>
>
> <<<oracle_ts_quotas>>>
>
> <<<oracle_undostat>>>
>
> <<<oracle_instance>>>
>
> <<<oracle_instance:sep(124)>>>
>
>
> ASLPROD|18.0.0.0.0|OPEN|ALLOWED|STARTED|3326154|1511745936|ARCHIVELOG|PRIMARY|NO|ASLPROD
>
> <<<oracle_recovery_status:sep(124)>>>
>
> <<<oracle_logswitches:cached(1551247931,1800)>>>
>
> ASLPROD 2
>
> <<<oracle_processes:cached(1551247931,1800)>>>
>
> ASLPROD 449 1000
>
> <<<oracle_resumable:sep(124):cached(1551247931,1800)>>>
>
> ASLPROD|||||||||
>
> <<<oracle_sessions:cached(1551247931,1800)>>>
>
> ASLPROD 586
>
> <<<oracle_tablespaces:sep(124):cached(1551247931,1800)>>>
>
> <<<oracle_ts_quotas:sep(124):cached(1551247931,1800)>>>
>
> ASLPROD|||
>
> <<<oracle_undostat:sep(124):cached(1551247931,1800)>>>
>
>
>
> From what I read, from version 1.5.0p6, it supports Oracle 18.
>
>
>
> Does anybody have same issue?
>
>
>
> Thanks,
>
>
>
>
> *Minh Tuan Nguyen *System Engineer
>
> Warehouse & Distribution Solutions – Central Europe
>
>
>
> *Swisslog VN*   55 Suong Nguyet Anh, Ben Thanh Ward, District 1 /
> Vietnam   www.swisslog.com
> minhtuan.nguyen at swisslog.com
> T +84 28 392 525 91  F +84 28 392 525 81  M +84 866 541 444
>
>
>
> [image: 1] <https://www.linkedin.com/company/swisslog>[image: 2]
> <https://twitter.com/SwisslogInspire> [image: 3]
> <https://www.youtube.com/user/SwisslogWDS> [image: 4]
> <http://www.swisslog.com/Home/Corporate/Blog>
>
>
>
> [image: swl_logo_KUKAGroup_RGB]
>
>
>
> *About Swisslog*
> Swisslog designs, develops and delivers best-in-class automation solutions
> for forward-thinking health-systems, warehouses and distribution centers.
> We offer integrated systems and services from a single source – from
> consulting to design, implementation and lifetime customer service. Behind
> the company´s success are 2,500 employees worldwide, supporting customers
> in more than 50 countries. Swisslog is a member of the KUKA Group, a
> leading global supplier of intelligent automation solutions.
>
>
>
> This message may contain legally privileged or confidential information
> and is therefore addressed to the named persons only. The recipient should
> inform the sender and delete this message, if he/she is not named as
> addressee. The sender disclaims any and all liability for the integrity and
> punctuality of this message. The sender has activated an automatic virus
> scanning, but does not guarantee the virus free transmission of this
> message.
> _______________________________________________
> checkmk-en mailing list
> checkmk-en at lists.mathias-kettner.de
> Manage your subscription or unsubscribe
> https://lists.mathias-kettner.de/cgi-bin/mailman/listinfo/checkmk-en
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20190228/ad38452a/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 358 bytes
Desc: not available
URL: <https://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20190228/ad38452a/attachment-0005.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 395 bytes
Desc: not available
URL: <https://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20190228/ad38452a/attachment-0006.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 321 bytes
Desc: not available
URL: <https://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20190228/ad38452a/attachment-0007.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 460 bytes
Desc: not available
URL: <https://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20190228/ad38452a/attachment-0008.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 12177 bytes
Desc: not available
URL: <https://lists.mathias-kettner.de/pipermail/checkmk-en/attachments/20190228/ad38452a/attachment-0009.png>


More information about the checkmk-en mailing list