Re: AWR snapshots empty - ADDM runs fail

recently had a stuck MMON on 11gR2 that caused having no snapshots at all. My lesson learned: Check alert log at corresponding time.

Don't know if it's helpful, but MMON should be a good starting point for investigation for AWR issues.

Regards
Martin

De DBA schrieb:
> G'day.
>
> I'm stumped about this one. We've got a few 11gR1 databases that have been in use for several years. They work well, had dbconsole configured but no management packs. Today I added them to the 12c Cloud Control and enabled management pack access for the Diagnostic & Tuning packs. Immediately the database began collecting hourly AWR snapshots, level TYPICAL. The problem is that all snapshots are empty. No data at all.
>
> When I go to the 'realtime ADDM' page in EMCC, there is plenty data flowing. Real time analysis fails though, because apparently DBSNMP pl/sql packages need to be installed - new in 12c? I don't remember having to do that in previous versions... However, the absence of DBSNMP packages associated with ADDM should not result in empty snapshots, or should it? As I understand it, AWR snapshots are created by the database using native functionality, not by the EMCC agent?
>
> Running AWR reports results in stacks of warning messages and trying to display the ADDM runs (hourly) shows an array index out of bounds type error.
>
> All this works very well for 11gR2 databases, including creating and displaying ADDM runs. The same EMCC instance is used to manage both the 11gR1 and 11gR2 databases.
>
> Version info:
>
> - Database: 11.1.0.6.0
> - EMCC & agent: 12.1.0.3.0
> - OS: AIX
>
> The dbconsole repository is still present in the databases, but the dbconsoles are shutdown.
>
> Helpful hints welcome.
>
> Cheers,
> Tony
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Usn's IT Blog for Oracle and Linux
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l