Prerequisites

Supported Operating Systems and Database Versions

DBSAT supports various operating systems, including Linux x86-64, Linux 64-bit ARM, and Windows x64. It can run on Oracle Database 11.2.0.4 and later releases, both on-premises and in the cloud, with specific editions and services. The tool collects database configuration queries and provides targeted recommendations for different database types. For Unix/Linux systems, DBSAT requires the BASH shell to execute.

Security Requirements

The output files generated by DBSAT are sensitive and should be handled securely. Directories containing these files must have appropriate permissions, and the files should be deleted securely after implementing recommendations. Sharing and encrypting the files is recommended, and user permissions for the DBSAT user should be granted on a short-term basis.

Collector Prerequisites

The DBSAT Collector gathers data by querying database views and using OS commands. It requires an OS user with read permissions on ORACLE_HOME files and directories. Privileges such as CREATE SESSION, SELECT on specific views, and roles like SELECT_CATALOG_ROLE and DV_SECANALYST (if Database Vault is enabled) must be granted to the DBSAT user.

Sample Script To Create A User With Minimum Privileges

A sample script is provided to create a DBSAT user with the required minimum privileges. This user will have the necessary permissions to run the DBSAT Collector script.

Reporter Prerequisites

The Reporter component of DBSAT requires Oracle Java Runtime Environment (Oracle JRE) 17 (Oracle JDK 17) or later. Oracle recommends using Oracle JDK 21 or later for optimal performance. The JAVA_HOME environment variable must be set to the installation directory containing the bin and lib directories.

Discoverer Prerequisites

Similar to the Reporter, the Discoverer component also requires Oracle JRE 17 (Oracle JDK 17) or later. The JAVA_HOME environment variable setup is the same. The Discoverer collects metadata from database dictionary views and relies on accurate table statistics, so a DBMS_STATS execution is recommended before running.
Read More: Discoverer Prerequisites