DBCollect/Usage
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
# If the problem databases are not important, try excluding them:
dbcollect --exclude inst1,inst2
Explanation of all options
help
--help or -h
Shows usage (list of all arguments)
version
-V | --version
Shows detailed version, build and copyright details
debug
-D | --debug
enables debugging. This will result in more logging (sometimes dumping unhandled Python exceptions and traces.
Even without this option, debug info is written to the dbcollect logfile for troubleshooting purposes.
quiet
-q | --quiet
Hides most normal terminal output (except errors). Useful for scripted runs (such as with DBCollect/Ansible)
overwrite
-o | --overwrite
Overwrites the previous dbcollect ZIP file if it exsts.
update
--update
Downloads new version of dbcollect from github and replaces the old version.
Requires https access to github.com
sudoers
--sudoers
Writes sudoers settings to /etc/sudoers.d/dbcollect. This allows dbcollect to run some commands as root, that otherwise would fail.
This retrieves some extra, optional information. Not required, but on HP-UX highly recommended, as otherwise disk devices cannot be properly detected.
filename
--filename FILENAME
Write to the given FILENAME instead of /tmp/dbcollect-<hostname>.zip.
If FILENAME is only an identifier, the new name will be /tmp/<filename>.zip.
If FILENAME is a full path, dbcollect will use it as new location (.zip extension will be added if needed)
tempdir
--tempdir TEMPDIR
Use TEMPDIR as alternative temporary folder (for example /var/tmp.
Useful if /tmp freespace is insufficient. dbcollect will always create a subdirectory such as /tmp/dbcollect_uwfb4li0 so it will never overwrite existing files or directories.