Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Statspack setup for 2nd RAC instance ?...basic Qs

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

From: Arul Ramachandran <contactarul_at_gmail.com>
Date: Wed, 7 Feb 2007 10:26:20 -0800
Message-ID: <1c1a62990702071026v21f795a7uc1156618e8864986@mail.gmail.com>


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
Received on Wed Feb 07 2007 - 12:26:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US