DBC:Errors/DBC-E040: Difference between revisions

From Dirty Cache Wiki
Jump to navigation Jump to search
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..."
 
No edit summary
 
Line 8: Line 8:
Solution: <code>GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user></code>  
Solution: <code>GRANT EXECUTE ON DBMS_WORKLOAD_REPOSITORY to <user></code>  


{{PrevNext|DBC:Errors/DBC-E038|DBC:Errors/DBC-E040}}
{{PrevNext|DBC:Errors/DBC-E039|DBC:Errors/DBC-E041}}

Latest revision as of 14:27, 5 November 2024


[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>