Oracle Database Security Assessment Tool

 1- Download Oracle Database Security Assessment Tool using below link.

https://www.oracle.com/database/technologies/security/dbsat.html

2- Download Java JDK RPM if not already installed.

https://www.oracle.com/java/technologies/javase/javase-jdk8-downloads.html

3- Now install Java

   rpm -Uvh jdk-8u181-linux-x64.rpm

4- Export Java Variables

export JAVA_HOME=/usr/java/jdk1.8.0_181-amd64

export PATH=$JAVA_HOME/bin:$PATH

5- Now Unzip DB stat file into any directory.

cd /u01/app/oracle/

unzip /backup/dbsat.zip

cd /u01/app/oracle/dbstat/

6- Now Run DB State Tool 

 ./dbsat collect system/yourpassword /u01/app/oracle/dbstat/statreport

This will create a new zip file named as statreport.

./dbstat collect system/yourpassword  /u01/app/oracle/dbstat/statreport

./dbsat report  /u01/app/oracle/dbstat/statreport

Now cd to discoverer folder.

cd Discover/

and copy sample_dbsat.config  to dbstat_config and change hostname and service_name and port no in this file.

 ./dbsat discover -c Discover/conf/dbstat_config nameofdatabase

After successful execution of last command. New zip file named as dbname_report.zip will be created. Copy this file to your machine and open .html file.

7-