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

If it is 10GR2 why statspack? Just use AWR.

Arul

On 2/6/07, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
>
> 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***
>

-- 
Arul

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