DBC:Errors/DBC-E040: Difference between revisions
		
		
		
		
		
		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-  | {{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>