My Oracle Support Banner

EM13c: AWR Enable Snapshot Upload Fails with error: EMDB-00769: <Unknown facility: EMDB> (Doc ID 2343992.1)

Last updated on FEBRUARY 12, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Using DBSNMP user for AWR Warehouse setup in a target database.
Observe that AWR Snapshot job is disabled. 

Select Database and from Action Click Enable Snapshot Upload, but getting error EMDB-00769:



Observe below error in emoms.log / trace file, but from AWR maintancance privileges is set.

emoms.trc
=========
2017-12-24 14:27:46,462 [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ui.DbAwrDashboardBean logp.251 - DB user set in Preferred Credentials does not have AWR warehouse privileges <target_name>. Upload Snapshot could not be enabled
2017-12-24 14:27:46,464 [[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN error.ErrorManager logp.251 - ErrorManager (144691408): Unknown facility [EMDB] for EMDB-00769
...
2017-12-24 14:31:04,439 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ui.DbAwrDashboardBean logp.251 - DB user set in Preferred Credentials does not have AWR warehouse privileges <target_name>. Upload Snapshot could not be enabled
2017-12-24 14:31:04,440 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN error.ErrorManager logp.251 - ErrorManager (144691408): Unknown facility [EMDB] for EMDB-00769
...
2017-12-24 14:37:59,972 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ui.DbAwrDashboardBean logp.251 - DB user set in Preferred Credentials does not have AWR warehouse privileges <target_name>. Upload Snapshot could not be enabled
2017-12-24 14:37:59,973 [[ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN error.ErrorManager logp.251 - ErrorManager (144691408): Unknown facility [EMDB] for EMDB-00769
...
2017-12-24 21:45:25,640 [[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR ui.DbAwrDashboardBean logp.251 - DB user set in Preferred Credentials does not have AWR warehouse privileges <target_name>. Upload Snapshot could not be enabled
2017-12-24 21:45:25,641 [[ACTIVE] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'] WARN error.ErrorManager logp.251 - ErrorManager (144691408): Unknown facility [EMDB] for EMDB-00769

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.