DBCollect/Usage: Difference between revisions

From Dirty Cache Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 25: Line 25:
# or
# or
dbcollect --overwrite
dbcollect --overwrite
</syntaxhighlight>
== Resolve AWR reporting issues ==
{{dbcollect}} checks for prior AWR usage to make sure it will not trigger Oracle license violations ([[DBCollect/AWR_Reports | More info]])
If you get Error [[DBC:Errors/DBC-E021| [DBC-E021] No AWR or Statspack detected]]:
<syntaxhighlight lang=bash>
# If you are sure you have Diagnostics Pack license:
dbcollect --force-awr
# If you want to ignore databases without AWR usage:
dbcollect --ignore-awr
</syntaxhighlight>
</syntaxhighlight>

Revision as of 13:36, 28 May 2024

Usage

Verify correct install

# Show version
dbcollect -V

# Show usage
dbcollect -h

# Update to last version (if the system has https access to github)
dbcollect --update

Run with default settings

# Default run
dbcollect

# If you get Error DBC-020 (zipfile already exists), you can overwrite the old zipfile:
dbcollect -o
# or
dbcollect --overwrite


Resolve AWR reporting issues

dbcollect checks for prior AWR usage to make sure it will not trigger Oracle license violations ( More info)

If you get Error [DBC-E021] No AWR or Statspack detected:

# If you are sure you have Diagnostics Pack license:
dbcollect --force-awr

# If you want to ignore databases without AWR usage:
dbcollect --ignore-awr