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
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 - 08:41:44 CST