One command one-click collection of oracle inspection information (including dbhc, awr reports), dbhcawr
The preliminary steps are as follows:
SQL> @ nb
------ Oracle Database health Check STRAT
------ Starting Collect Data Information!
------ Part 1.DB Overview...
------ Part 2.DB File Overview...
------ Part 3. Perfermance Overview...
------ Part 4. Security and Privilege Overview...
------ Part 5. Objects Overview...
------ Part 6.RAC Overview...
------ Part 7. Backup Controlfile...
-------------- Start collect AWR reports
Enter value for trace_file_name:
------ Oracle Database Health Check END
/Home/oracle
-Rw-r -- 1 oracle oinstall 242088 Jul 28./dbhc. lixora.2014-07-28/awr.lixora.html
-Rw-r -- 1 oracle oinstall 280758 Jul 28./dbhc. lixora.2014-07-28/db_health_check_lixora.2014-07-281658.html
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0-64bit Production
With the Partitioning, OLAP and Data Mining options
[Oracle @ lixora ~] $ Ls-trl
-Rw-r -- 1 oracle oinstall 48803 Jul 28 nb. SQL
Drwxr-xr-x 2 oracle oinstall 4096 Jul 28 dbhc. lixora.2014-07-28
[Oracle @ lixora ~] $ Cd dbhc. lixora.2014-07-28/
[Oracle @ lixora dbhc. lixora.2014-07-28] $ ls-trl
Total 524
-Rw-r -- 1 oracle oinstall 280758 Jul 28 db_health_check_lixora.2014-07-281658.html
-Rw-r -- 1 oracle oinstall 242088 Jul 28 awr.lixora.html