DBAAS Tooling: Using dbaascli to Collect Cloud Tooling Logs and Perform a Cloud Tooling Health Check
Using the dbaascli diag command allows you to collect domU dbaas tooling logs for Exadata Database Service on Dedicated Infrastructure and Exadata Database Service on Cloud@Customer systems. You can use these logs to troubleshoot issues related to dbaas tooling.
Starting with DBaaS Tools Cloud Tooling RPM 21.2.1, you can use the diag
command to collect dbaastools logs and perform a health check on all nodes in an Exadata
cluster.
- dbaascli diag commands must be run as the root user
- Running the
dbaascli diag collect
command on a single node will collect log data for all nodes - We recommend running the commands documented in this topic using the nohup option for long-running commands. Redirect the command output to a location you can monitor.
For information on updating Exadata Cloud Tooling, see How to upgrade DBAAS Cloud Tooling using dbaascli (Doc ID 2350471.1).
Syntax for Collecting Tooling Log Data
The dbaascli dbaascli diag collect
command uses the syntax shown
below to collect tooling log data:
dbaascli diag collect [parameters]
Parameter | Description | Required | Accepted Values | Default Values |
---|---|---|---|---|
--help | Access help for the command. | No | not applicable | none |
--destLocation | The domU directory location to store collected logs. | No | A valid full path location present on all nodes in the cluster. |
If parameter is not specified, system collects log files as follows: System collects logs at
If that location cannot be used, system collects logs at
Command output displays which directory location is being used to collect logs. |
--dbNames | The dbName value of the database for which you want to collect logs. Currently, only one dbName can be specified per command. | No | A valid dbName value for the system. | none |
--startTime | The start time for log collection. Requires the use of the --endTime parameter. | No | Format: YYYY-MM-DDTHH24:MM:SS. Must be used together with the
--endTime parameter. |
If parameter is not specified, system sets start time as 24 hours prior to the current system time. |
--endTime | The start time for log collection. Requires the use of the --startTime parameter. | No | Format: YYYY-MM-DDTHH24:MM:SS. Must be used together with the
--startTime parameter. |
If parameter is not specified, system sets end time as current system time. |
--nodes | A comma-separated list of nodes to collect logs. | No |
Format: node1,node2 |
If parameter is not specified, system collects logs for all nodes in the cluster. |
--components | A list of components for log collection. | No |
One of: db|gi|os|dbaastools|all |
If parameter is not specified, logs are collected for dbaastools. |
--objectStoreBucketUri | An Object Storage service pre-authenticated request (PAR) URL used to upload collected logs. Logs are collected from domU. See Using Pre-Authenticated Requests for more information. | No | URL that has been pre-authenticated. | none |
[root@exampleOracleDB ~]# dbaascli diag collect
DBAAS CLI version MAIN
Executing command diag collect
dbaascli diag collect called without component
INFO: Starting diag collect
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210322-2130.tar.gz
[root@exampleOracleDB ~]# dbaascli diag collect --dbNames myOracleDatabase19cName
DBAAS CLI version MAIN
Executing command diag collect --dbNames myOracleDatabase19cName
dbaascli diag collect called without component
INFO: Starting diag collect
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210322-2128.tar.gz
[root@exampleOracleDB ~]# dbaascli diag collect --destLocation /tmp/test/
DBAAS CLI version MAIN
Executing command diag collect --destLocation /tmp/test
dbaascli diag collect called without component
INFO: Starting diag collect
INFO: Collected diag logs at: /tmp/test/diag_cloudlogs_20210322-1731.tar.gz
[root@exampleOracleDB ~]# dbaascli diag collect --startTime 2021-03-19T10:00:00 --endTime 2021-03-20T10:00:00
DBAAS CLI version MAIN
Executing command diag collect --startTime 2021-03-19T10:00:00 --endTime 2021-03-20T10:00:00
dbaascli diag collect called without component
INFO: Starting diag collect
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210322-2245.tar.gz
[root@exampleOracleDB ~]# dbaascli diag collect --nodes rbcl1,rbcl2
DBAAS CLI version MAIN
Executing command diag collect --nodes rbcl1,rbcl2
dbaascli diag collect called without component
INFO: Starting diag collect
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210421-1848.tar.gz
[root@exampleOracleDB ~]# dbaascli diag collect --components dbaastools
DBAAS CLI version MAIN
Executing command diag collect --components dbaastools
dbaascli diag collect called with component dbaastools
INFO: Starting diag collect
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210421-1851.tar.gz
[root@exampleOracleDB ~]# dbaascli diag collect --objectStoreBucketUri https://objectstorage.us-phoenix-1.oraclecloud.com/p/t0Z-kRV5pSmFzqnf-y5XhaAbM4LS82epeBnulKnCr31IeHVjxI9tOkntLF2kq7fP/n/MyNamespace/b/MyParBucket/o/
DBAAS CLI version MAIN
Executing command diag collect --objectStoreBucketUri https://objectstorage.us-phoenix-1.oraclecloud.com/p/t0Z-kRV5pSmFzqnf-y5XhaAbM4LS82epeBnulKnCr31IeHVjxI9tOkntLF2kq7fP/n/MyNamespace/b/MyParBucket/o/
dbaascli diag collect called without component
INFO: Starting diag collect
INFO: Collected diag logs at: https://objectstorage.us-phoenix-1.oraclecloud.com/p/t0Z-kRV5pSmFzqnf-y5XhaAbM4LS82epeBnulKnCr31IeHVjxI9tOkntLF2kq7fP/n/MyNamespace/b/MyNamespace/o/diag_cloudlogs_20210421-1839.tar.gz
[root@exampleOracleDB ~]# nohup dbaascli diag collect > /tmp/nohup.out 2>&1 &
After running the command, monitor /tmp/nohup.out
for
completion.
[root@exampleOracleDB ~]# dbaascli diag collect --help
DBAAS CLI version MAIN
Executing command diag collect --help
diag collect - collect.
[--destLocation - Location on domU to collect logs. Default : /var/opt/oracle/dbaas_acfs ]
[--startTime - startTime for log collection. Ex : YYYY-MM-DDTHH24:MM:SS]
[--dbNames - dbName for which to collect logs. Only one dbName can be specified]
[--endTime - endTime for log collection. Ex : YYYY-MM-DDTHH24:MM:SS]
Syntax for Performing a Health Check
The dbaascli dbaascli diag healthcheck
command uses the syntax shown
below to perform a health check on all system nodes:
dbaascli diag healthcheck [parameters]
Parameter | Description | Required | Accepted Values | Default Values |
---|---|---|---|---|
--help | Access help for the command. | No | not applicable | none |
--destLocation | The domU directory location to store collected log information. | No | A valid full path location present on all nodes in the cluster. |
If parameter is not specified, system collects log files as follows: System collects logs at
If that location cannot be used, system collects logs at
Command output displays which directory location is being used to collect logs. |
--nodes | A comma-separated list of nodes to collect logs. | No |
Format: node1,node2 |
If parameter is not specified, system collects logs for all nodes in the cluster. |
--objectStoreBucketUri | An Object Storage service pre-authenticated request (PAR) URL used to upload collected logs. Logs are collected from domU. See Using Pre-Authenticated Requests for more information. | No | URL must be pre-authenticated. | none |
[root@exampleOracleDB ~]# dbaascli diag healthcheck
DBAAS CLI version MAIN
Executing command diag healthcheck
INFO: Starting diag healthcheck
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210322-2246.tar.gz
[root@exampleOracleDB ~]# dbaascli diag healthcheck --destLocation /tmp/test
DBAAS CLI version MAIN
Executing command diag healthcheck --destLocation /tmp/test
INFO: Starting diag healthcheck
INFO: Collected diag logs at: /tmp/test/diag_cloudlogs_20210322-2250.tar.gz
[root@exampleOracleDB ~]# dbaascli diag healthcheck --nodes rbcl1,rbcl2
DBAAS CLI version MAIN
Executing command diag healthcheck --nodes rbcl1,rbcl2
INFO: Starting diag healthcheck
INFO: Collected diag logs at: /var/opt/oracle/dbaas_acfs/diag_cloudlogs_20210421-1915.tar.gz
[root@exampleOracleDB ~]# dbaascli diag healthcheck --objectStoreBucketUri https://objectstorage.us-phoenix-1.oraclecloud.com/p/t0Z-kRV5pSmFzqnf-y5XhaAbM4LS82epeBnulKnCr31IeHVjxI9tOkntLF2kq7fP/n/MyNamespace/b/MyParBucket/o/
DBAAS CLI version MAIN
Executing command diag healthcheck --objectStoreBucketUri https://objectstorage.us-phoenix-1.oraclecloud.com/p/t0Z-kRV5pSmFzqnf-y5XhaAbM4LS82epeBnulKnCr31IeHVjxI9tOkntLF2kq7fP/n/MyNamespace/b/MyParBucket/o/
INFO: Collected diag logs at: https://objectstorage.us-phoenix-1.oraclecloud.com/p/t0Z-kRV5pSmFzqnf-y5XhaAbM4LS82epeBnulKnCr31IeHVjxI9tOkntLF2kq7fP/n/MyNamespace/b/MyParBucket/o/diag_cloudlogs_20210421-1839.tar.gz
[root@exampleOracleDB ~]# dbaascli diag healthcheck --help
DBAAS CLI version MAIN
Executing command diag healthcheck --help
diag healthcheck - healthcheck.
[--destLocation - Location on domU to collect logs. Default : /var/opt/oracle/dbaas_acfs ]