Re: AWR snapshots empty - ADDM runs fail
- From: David Fitzjarrell <oratune@xxxxxxxxx>
- To: "dedba@xxxxxxxxxx" <dedba@xxxxxxxxxx>, "Oracle-L@xxxxxxxxxxxxx" <Oracle-L@xxxxxxxxxxxxx>
- Date: Thu, 5 Sep 2013 06:43:57 -0700 (PDT)
What do you get when you run a manual snapshot?
David Fitzjarrell
________________________________
From: De DBA <dedba@xxxxxxxxxx>
To: Oracle-L@xxxxxxxxxxxxx
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@xxxxxxxxx>
> *To:* dedba@xxxxxxxxxx
> *Cc:* Oracle-L@xxxxxxxxxxxxx
> *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>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
