Re: AWR snapshots empty - ADDM runs fail

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Thu, 5 Sep 2013 06:43:57 -0700 (PDT)
Message-ID: <1378388637.38842.YahooMailNeo_at_web121603.mail.ne1.yahoo.com>

What do you get when you run a manual snapshot?

David Fitzjarrell  

---

 From: De DBA <dedba_at_tpg.com.au>
To: Oracle-L_at_freelists.org
Sent: Thursday, September 5, 2013 5:49 AM Subject: Re: AWR snapshots empty - ADDM runs fail   

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

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

Received on Thu Sep 05 2013 - 15:43:57 CEST