EM 13C: Generate AWR Report From EM Console Failed With Error "java.sql.SQLException: ORA-20020: Database/Instance/Snapshot mismatch"
(Doc ID 2980833.1)
Last updated on OCTOBER 17, 2023
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Generate AWR report from EM console for target database failed with below error :
ORA-20020: Database/Instance/Snapshot mismatch ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 17565 ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 3088 ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 1270 ORA-06512: at line 1
OMS logs showing below error :
<OMS_INST_HOME>/em/EMGC_OMS1/sysman/log/emoms.log
2023-09-13 09:02:42,086 [Thread-1528070] ERROR swrf.GlobalAwrReportBean runAwrReport.896 - java.sql.SQLException: ORA-20020: Database/Instance/Snapshot mismatch
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 17565
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 3088
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 1270
ORA-06512: at line 1
java.sql.SQLException: ORA-20020: Database/Instance/Snapshot mismatch
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 17565
ORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 3088
ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 1270
ORA-06512: at line 1
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 |
Cause |
Solution |
References |