Appendix B

Troubleshooting

This section provides guidance on troubleshooting the Oracle Database Security Assessment Tool (DBSAT). It covers enabling diagnostics to diagnose errors, handling issues with the DBSAT Reporter, and resolving problems related to the DBSAT process. Users can refer to this section to address common errors and improve the tool's performance. The diagnostics feature helps capture vital information for debugging, and users can enable it using the -d option. Additionally, specific error scenarios are addressed, such as the "No JSON object could be decoded" issue, which can be resolved by granting execute privilege on DBMS_SQL to the DBSAT database user. The section also highlights potential issues with running DBSAT on IBM AIX platforms and provides solutions, including installing the bash shell or running DBSAT collect remotely. To address long-running or incomplete DBSAT collect processes, users can limit the number of rows collected using the -r option. Finally, if a DBSAT process ends unexpectedly, restarting the command is recommended to refresh the results.
Read More: Troubleshooting