Re: AWR snapshots empty - ADDM runs fail
- From: De DBA <dedba@xxxxxxxxxx>
- To: Mark Burgess <mark@xxxxxxxxxxxxxxxxxxxxxxxxx>, Oracle-L@xxxxxxxxxxxxx
- Date: Thu, 05 Sep 2013 08:29:17 +1000
Thanks Mark,
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@xxxxxxxxxx> 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
>> --
>> //www.freelists.org/webpage/oracle-l
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
