RE: Statspack setup for 2nd RAC instance ?...basic Qs
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Feb 2007 22:46:40 +0530
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***
Other related posts:
