DBCollect/AWR Reports: Difference between revisions
Created page with " = Overview = By default, {{dbcollect}} tries to generate AWR reports for each detected and running database instance on the host. However, creating AWR reports require the Oracle Diagnostics Pack license. This page explains how {{dbcollect}} deals with this requirement. {{stub}}" |
No edit summary |
||
| (5 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Category:DBCollect]] | |||
{{stub}} | |||
= Overview = | = Overview = | ||
By default, {{dbcollect}} tries to generate | By default, {{dbcollect}} tries to generate [[AWR_Report]]s for each detected and running database instance on the host. | ||
However, creating AWR reports require the Oracle Diagnostics Pack license. This page explains how {{dbcollect}} deals with this requirement. | However, creating AWR reports require the Oracle Diagnostics Pack license. This page explains how {{dbcollect}} deals with this requirement. | ||
{{ | = Diagnostics Pack = | ||
Diagnostics Pack is a licensed option on top of Oracle Database Enterprise Edition. It is required to run AWR reports. You can run AWR reports without the license, however, this will be registered in the database and is a licensing violation that can have consequences when customers are audited. Therefore, {{dbcollect}} has some safeguards against accidental usage. | |||
= Detecting Diagnostics Pack license = | |||
It is impossible to detect contract details using automated tools on a host. Therefore, {{dbcollect}} checks for previous usage of AWR Reports instead. See [https://oracle-base.com/articles/misc/tracking-database-feature-usage Oracle Base - Tracking Database Feature Usage] for a detailed explanation and example script. | |||
Currently - the detection is per database - so it is possible to have one database running AWR reports without problems and another one not due to missing AWR usage. This is intentional - a database without prior usage could later be migrated to another host that is not properly licensed and therefore cause issues. | |||
If prior AWR Usage is detected, then either the system is licensed with Diagnostics Pack, or (worst case scenario) the system is in license violation anyway. In both cases, {{dbcollect}} will proceed creating AWR reports (unless disabled via CLI parameters) | |||
= No prior AWR usage = | |||
If no prior AWR usage is detected, then {{dbcollect}} will '''''NOT''''' automatically generate AWR reports, but issue an error instead, unless the <code>--force-awr</code> flag is used. | |||
Latest revision as of 13:05, 28 May 2024
This article is a stub. You can help us by expanding it.
Overview
By default, dbcollect tries to generate AWR_Reports for each detected and running database instance on the host.
However, creating AWR reports require the Oracle Diagnostics Pack license. This page explains how dbcollect deals with this requirement.
Diagnostics Pack
Diagnostics Pack is a licensed option on top of Oracle Database Enterprise Edition. It is required to run AWR reports. You can run AWR reports without the license, however, this will be registered in the database and is a licensing violation that can have consequences when customers are audited. Therefore, dbcollect has some safeguards against accidental usage.
Detecting Diagnostics Pack license
It is impossible to detect contract details using automated tools on a host. Therefore, dbcollect checks for previous usage of AWR Reports instead. See Oracle Base - Tracking Database Feature Usage for a detailed explanation and example script.
Currently - the detection is per database - so it is possible to have one database running AWR reports without problems and another one not due to missing AWR usage. This is intentional - a database without prior usage could later be migrated to another host that is not properly licensed and therefore cause issues.
If prior AWR Usage is detected, then either the system is licensed with Diagnostics Pack, or (worst case scenario) the system is in license violation anyway. In both cases, dbcollect will proceed creating AWR reports (unless disabled via CLI parameters)
No prior AWR usage
If no prior AWR usage is detected, then dbcollect will NOT automatically generate AWR reports, but issue an error instead, unless the --force-awr flag is used.