[AWR Warehouse] extractAWR of "Upload Snapshot now" fails every time. What should I do to fix it?

Aug 24, 2014 10:38AM

Hello. I'm Yuji.

I configured AWR Warehouse recently.

I kicked Action that is "Upload Snapshot now" sometime.

But every time its job fail at "extractAWR".

In job message is below.

SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 24 23:06:08 2014
Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> SQL> Connected.
SQL> SQL> SQL> BEGIN dbsnmp.mgmt_caw_extract.run_job_now; END;

*
ERROR at line 1:
ORA-20137: NO NEW SNAPSHOTS TO EXTRACT
ORA-06512: at "DBSNMP.MGMT_CAW_EXTRACT", line 528
ORA-06512: at line 1

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Error from SQLPLUS: 1

Managing Databases using Enterprise Manager (MOSC)

[AWR Warehouse] extractAWR of "Upload Snapshot now" fails every time. What should I do to fix it?

Howdy, Stranger!

Category Leaderboard

Top contributors this month