Re: AWR snapshots empty - ADDM runs fail

Do you happen to know where this would be documented? I did read the EMCC docs, but found nothing to indicate that this could be a problem. Indeed, I seem to remember that on this list not too long ago someone (Peter Sharman perhaps?) alluded to the fact that both could be used side-by-side, albeit that jobs defined in one will not show up in the other and similar gotchas.

Cheers,
Tony

On 04/09/13 20:20, Mark Burgess wrote:
> Hi Tony,
>
> you may have to deinstall the DB Control repository in the targets and then configure the 11.1 targets under 12c CC. From memory you can't have a target managed by both DB Control and EMGC/CC - but I maybe wrong. Even if you do have to deinstall this should still preserve the AWR data.
>
> Regards,
>
> Mark
>
> On 04/09/2013, at 8:07 PM, De DBA <dedba_at_tpg.com.au> wrote:
>
>> 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
>>
>>
>

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