2 Replies Latest reply: Nov 2, 2012 1:57 AM by Belt RSS

    Global AWR on 10.2

    Belt
      Dear all,

      I try to gather a global AWR on 10.2.0.1. I copy the awrgrpt.sql,awrgrpti.sql,awrginp.sql to 10.2.0.1 from 11.2.
      When i exec awrgrpt.sql ,i get an error:

      insts AWRRPT_INSTANCE_LIST_TYPE;
      *
      ERROR at line 15:
      ORA-06550: line 15, column 11:
      PLS-00201: identifier 'AWRRPT_INSTANCE_LIST_TYPE' must be declared
      ORA-06550: line 15, column 11:
      PL/SQL: Item ignored
      ORA-06550: line 47, column 24:
      PLS-00320: the declaration of the type of this expression is incomplete or
      malformed
      ORA-06550: line 48, column 4:
      PL/SQL: ORA-00904: : invalid identifier
      ORA-06550: line 46, column 4:
      PL/SQL: SQL Statement ignored