Re: AWR snapshots empty - ADDM runs fail

From: De DBA <dedba_at_tpg.com.au>
Date: Thu, 05 Sep 2013 21:49:55 +1000
Message-ID: <52286FE3.2000800_at_tpg.com.au>

I should have been more specific. When I said "enabled management pack access for the Diagnostic & Tuning packs" , I meant to state that control_management_pack_access = 'DIAGNOSTIC+TUNING'; This exact same problem occurs in all 6 configured 11.1.0.6 databases. The databases are installed in 2 separate LPARs, 3 in each. Perhaps MMON on AIX has a known bug that may cause this?

Cheers
Tony

Update: today configured 2 production instances as described earlier and noted that all existing AWR snapshots in these instances (8 days worth) are also empty. These are busy OLTP instances, located in a third LPAR. Sadly, there are no AWR snapshot or MMON problems logged in any of the 8 instances (alert logs go back to March 2012).

Cheers,
Tony

On 05/09/13 00:13, Job Miller wrote:
> is control_management_pack_access in init.ora set by any chance?
>
> Job
>
>
> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 --
> *From:* Martin Klier <usn_at_usn-it.de>
> *To:* dedba_at_tpg.com.au
> *Cc:* Oracle-L_at_freelists.org
> *Sent:* Wednesday, September 4, 2013 8:40 AM
> *Subject:* Re: AWR snapshots empty - ADDM runs fail
>
> Hi,
>
> 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:

<snip due to overquoting>

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

Received on Thu Sep 05 2013 - 13:49:55 CEST