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@xxxxxxxxxxx> wrote:


 For Oracle RAC ver 10gR2


 ------------------------------

*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
oracle-l-bounce@xxxxxxxxxxxxx] *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

Other related posts: