Manually run SPREPORT, AWR, ADDM and ASH Oracle Reports

1. Check the Oracle home location first

In Windows: Open the services.msc and right click on Oracle Services for know the location of Oracle Home.

E:\oracle\11.2.0\dbhome_1
In Linux: Open the oratab file and check the Oracle Home location
/u01/oracle/11.2.0/dbhome_1

2. Go to the location in CMD or terminal window:
Windows:
Cd E:\oracle\11.2.0.\dbhome_1\rdbms\admin

Linux:
cd /u01/oracle/11.2.0/dbhome_1/rdbms/admin

3. Connect with the database with sysdba privileges:

Sqlplus sys as sysdba

4. Run the following script to generate the AWR report

SQL>@awrrpt.sql;

5. Run the following to generate the ADDM Report:

SQL>@addmrpt.sql;

6. Run the following command to generate the ASH Report:

SQL>@ashrpt.sql

7. Run the following command for Statspack report:

SQL>@spreport.sql