DBC:Errors/DBC-E040

From Dirty Cache Wiki
Revision as of 14:26, 5 November 2024 by Bart (talk | contribs) (Created page with "Category:DBCollect {{error|[DBC-E040] <sid>: [%s] Cannot execute AWR generation procedure [ORA-???:<message>]}} Creating AWR reports failed with the given Oracle message. More debug info should be in the <code>dbcollect.log</code> file. The most likely cause is not having <code>EXECUTE</code> privileges on the <code>DBMS_WORKLOAD_REPOSITORY</code> procedures. Solution: <code>GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user></code> {{PrevNext|DBC:Errors/DBC-E03...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


[DBC-E040] <sid>: [%s] Cannot execute AWR generation procedure [ORA-???:<message>]

Creating AWR reports failed with the given Oracle message. More debug info should be in the dbcollect.log file. The most likely cause is not having EXECUTE privileges on the DBMS_WORKLOAD_REPOSITORY procedures.

Solution: GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user>