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-
