DBCollect Options

-h, --help

List available options (help)

# show this help message and exit
dbcollect -h, --help

-V, --version

Show version info

# Version and copyright info
dbcollect -V, --version

-D, --debug

Prints many debug messages, dumps the dbcollect.log after finishing)

# Debug (Show errors)
dbcollect -D, --debug

-q, --quiet

Quiet (only print error messages)

# Suppress output
dbcollect -q, --quiet

--complete

Dump bash completion code

# Bash completions. Run "source <(dbcollect --complete)"
dbcollect --complete

--update

Update to latest version (requires https)

# Check for updates
dbcollect --update

-u USER, --user USER

Use a non-standard Oracle user (only needed if running as root and user detection fails)

# Switch to user (if run as root)
dbcollect -u USER, --user USER

--filename FILENAME

Write DBCollect ZIP file with different filename (will go to /tmp,
unless you specify a full path): dbcollect --filename /home/oracle/mydbcollect.zip

# output filename, default dbcollect-<hostname>-<timestamp>.zip
dbcollect --filename FILENAME

--cleanup

Remove old dbcollect ZIP files from /tmp

# Remove old dbcollect zipfiles from /tmp
dbcollect --cleanup

--tempdir TEMPDIR

Use alternative temp directory (if you run out of space in /tmp)

# TEMP directory, default /tmp
dbcollect --tempdir TEMPDIR

-d DAYS, --days DAYS

Collect more than 10 days of AWR data (if available)

# Number of days ago to START collect of AWR data (default 10, max 999)
dbcollect -d DAYS, --days DAYS

--end_days END_DAYS

Shift collect period so you pick up from 30 days ago to 10 days ago

# Number of days ago to END AWR collect period, default 0, max 999
dbcollect --end_days END_DAYS

--logons

Use logons file instead of connect using OPS$ This allows dbcollect to run as non-privileged user (i.e., 'nobody'), and a read-only Oracle user (i.e., DBSNMP). See [Logons File]

# Use logons file
dbcollect --logons <file>

--orahome

Specify the ORACLE_HOME Use if the OS user has no access to oratab/oracle inventory

# ORACLE_HOME to run SQL*Plus (comma separated for multiple)
dbcollect --orahome <dir>

--license-ok

note this also picks up AWRs that have been generated with init.ora setting control_management_pack_access=NONE

# Override Diagnostics Pack detection (always generate AWRs). Diagnostics Pack required!
dbcollect --license-ok

--statspack

Generate Statspack where possible (even if AWR usage is detected)

# Prefer Statspack reports even if AWR usage is detected
dbcollect --statspack

--strip

Removes all SQL code sections from AWR reports (not for statspack)

# Strip SQL sections from AWR reports
dbcollect --strip

--no-rac

Pick up local AWRS only (Oracle RAC) - if you plan to run dbcollect on ALL RAC nodes

# Generate AWRs for local instance only (then run dbcollect on all nodes)
dbcollect --no-rac

--no-stby

Do not pick up AWRs from Data Guard Standby databases

# Generate AWRs for primary DB only (ignore standby DB)
dbcollect --no-stby

--no-awr

Don't create AWR reports at all (only the dbinfo sql reports)

# Skip AWR reports
dbcollect --no-awr

--no-sar

Don't pick up SAR reports

# Skip SAR reports
dbcollect --no-sar

--no-ora

Don't run any Oracle specific tasks

# Skip Oracle collection
dbcollect --no-ora

--no-sys

Don't run any OS specific tasks (only the Oracle stuff)

# Skip System info collection
dbcollect --no-sys

--no-root

Don't run root tasks (even if executed as root)

# Skip root commands (even if we are root)
dbcollect --no-root

--no-acct

Don't pick up process accounting even if available

# Skip process accounting collection
dbcollect --no-acct

--no-orainv

Ignore problematic Oracle inventory

# Ignore ORACLE_HOMES from Oracle Inventory
dbcollect --no-orainv

--no-oratab

Ignore problematic oratab

# Ignore ORACLE_HOMES from oratab
dbcollect --no-oratab

--no-timeout

Ignore timeout when detecting instances

# Don't abort on SQL*Plus timeout when detecting instances
dbcollect --no-timeout

--nmon PATH

Pick up NMON files from directory

# Where to look for NMON files (comma separated)
dbcollect --nmon PATH

--script SCRIPT

# Write SQL script to /tmp for usage with SQL*Plus
dbcollect --script SCRIPT

--skip-sql SCRIPTS

Skip problematic/hanging SQL scripts

# Skip SQL scripts (comma separated)
dbcollect --skip-sql SCRIPTS

--skip-cmd COMMANDS

Skip problematic/hanging OS commands

dbcollect --skip-cmd lshw,dmidecode

# Skip OS commands (comma separated)
dbcollect --skip-cmd COMMANDS

--include INSTANCES

Only include a subset of databases (ignore all others)

dbcollect --include probdb1,probdb3

# Include Oracle instances (comma separated)
dbcollect --include INSTANCES

--exclude INSTANCES

Exclude one or more problem databases

dbcollect --exclude probdb1,probdb3

# Exclude Oracle instances (comma separated)
dbcollect --exclude INSTANCES

--tasks TASKS

Limit amount of concurrent AWR collection tasks (CPUs): dbcollect --tasks 2 or set to 0 for using all CPUs: dbcollect --tasks 0

# Max number of tasks (default 50% of cpus (up to 8), 0=use all cpus)
dbcollect --tasks TASKS

--timeout TIMEOUT

Set timeout (in minutes) on AWR generation (default 10 minutes)

# Timeout (minutes) for SQL statements (default 10)
dbcollect --timeout TIMEOUT

--error

Show details on an error message: dbcollect --error E001

# Get info on error, warning or informational message (i.e., E001)
dbcollect --error <error>