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

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 6 Feb 2007 22:46:40 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302002899A4F@BLRKECMSG11.ad.infosys.com>

For Oracle RAC ver 10gR2  

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Tuesday, February 06, 2007 8:08 PM 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 - 11:16:40 CST