title: AWR report in oracle
body: <p>I am trying the generate AWR report in oracle 11G. At the creation time, i am getting some error message. error is mentioned below</p>
  
  <blockquote>
    <p>Using the report name awrrpt_1_2504_2709.html. select output from
    table(dbms_workload_repository.awr_report_html( :dbid,
                             * ERROR at line 1: ORA-00904: : invalid identifier</p>
  </blockquote>
  
  <p>Steps that i am using for generate the AWR reports</p>
  
  <blockquote>
    <p>@$ORACLE_HOME/rdbms/admin/awrrpt.sql</p>
    
    <p>Enter value for report_type: html</p>
    
    <p>Enter value for begin_snap: 2504 Begin Snapshot Id specified: 2504</p>
    
    <p>Enter value for end_snap: 2709 End   Snapshot Id specified: 2709</p>
  </blockquote>
  
  <p>Please help me on this.</p>