Problem for AWR in 5-nodes 10g RAC

From: <haiwu.us_at_gmail.com>
Date: 6 Nov 2005 10:40:10 -0800
Message-ID: <1131302410.896676.75810@g43g2000cwa.googlegroups.com>

I tried to run the AWR report for this 10g 5-nodes RAC, but noticed the following:
SQL> @?/rdbms/admin/awrrpti

Specify the Report Type

---

Would you like an HTML report, or a plain text report? Enter 'html' for an HTML report, or 'text' for plain text Defaults to 'html'
Enter value for report_type:

Type Specified: html

Instances in this Workload Repository schema

---

   DB Id Inst Num DB Name Instance Host ------------ -------- ------------ ------------ ------------

  874748295         1 OID          oid1         wpprddb1
  874748295         1 OID          oid2         wpprddb2
  874748295         2 OID          oid2         wpprddb2
  874748295         4 OID          oid4         wpprddb4
  874748295         5 OID          oid5         wpprddb5
* 874748295         3 OID          oid3         wpprddb3

Why there are 2 entries for instance number 1? The 2nd line shouldn't even be there, I think. Any way to troubleshoot this?

thanks, Received on Sun Nov 06 2005 - 12:40:10 CST