Statspack setup for 2nd RAC instance ?...basic Qs

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 6 Feb 2007 20:07:31 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302002899A39@BLRKECMSG11.ad.infosys.com>

Folks

What additional SETUP is needed to ADD the 2nd instance to STATSPACK?

NOTE - SQL>?/rdbms/admin/spcreate has been Run from the 1st RAC instance.

Running sprepins shows only 1 instance, below

SQL> @?/rdbms/admin/sprepins

Instances in this Statspack schema

---

   DB Id Inst Num DB Name Instance Host

• -------- ------------ ------------ ------------

  408243075 1 PNBRAC PNBRAC1 spesuns4p-2

Running spreport.sql DIRECTLY from the 2nd instance gives the following Error

SQL> @?/rdbms/admin/spreport

Current Instance

---

   DB Id DB Name Inst Num Instance

• ------------ -------- ------------

  408243075 PNBRAC 2 PNBRAC2 Instances in this Statspack schema

---

   DB Id Inst Num DB Name Instance Host

• -------- ------------ ------------ ------------

  408243075 1 PNBRAC PNBRAC1 spesuns4p-2

Using 408243075 for database Id

Using 2 for instance number

declare

*

ERROR at line 1:

ORA-20200: Database/Instance 408243075/2 does not exist in

STATS$DATABASE_INSTANCE ORA-06512: at line 23

Unable to find this in the Manuals / google search

Thanks indeed

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS*** -- http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 06 2007 - 08:37:31 CST