OraFAQ Forum: Linux » statpack report

Home » Infrastructure » Linux » statpack report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

statpack report [message #551484]

Wed, 18 April 2012 11:46

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

i intall successfully statpack i my database but when i goes to create the report it gives the following error kindely help me what cause this error?

SQL> @ d:\oracle\product\10.2.0\db_1\rdbms\admin\spreport.sql;

Current Instance
~~~~~~~~~~~~~~~~

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
1307631668 ORCL 1 orcl

Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Using 1307631668 for database Id
Using 1 for instance number
declare
*
ERROR at line 1:
ORA-20200: Database/Instance 1307631668/1 does not exist in
STATS$DATABASE_INSTANCE
ORA-06512: at line 23

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

thanks & regards
pritesh ranjan

Report message to a moderator

Re: statpack report [message #551485 is a reply to message #551484]

Wed, 18 April 2012 11:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I get the same.
Did you run the necessary preparatory script?

09:51:16 SQL> set echo off feedback off pagesize 60 newpage 1 recsep off;


Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  from stats$database_instance
       *
ERROR at line 7:
ORA-00942: table or view does not exist



Using 2232234187 for database Id
Using	       1 for instance number
       from stats$database_instance

Report message to a moderator

Re: statpack report [message #551486 is a reply to message #551484]

Wed, 18 April 2012 11:58

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And did you FIRST gather some statspack snapshots?

Regards
Michel

Report message to a moderator

Re: statpack report [message #551489 is a reply to message #551486]

Wed, 18 April 2012 12:33

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

i cant understand please clear me about which snapshot statistics and necessary preparatory script u talk?

Report message to a moderator

Re: statpack report [message #551492 is a reply to message #551489]

Wed, 18 April 2012 12:50

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read spdoc.txt you'll find at the same place there is spreport.sql and spcreate.sql.

Regards
Michel

Report message to a moderator

Re: statpack report [message #551694 is a reply to message #551492]

Fri, 20 April 2012 02:58

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

thanks michel. i successfully create my statpack report.

Report message to a moderator

Re: statpack report [message #551981 is a reply to message #551694]

Mon, 23 April 2012 01:32

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

how can i check the statpack is alreday install in my database.

Report message to a moderator

Re: statpack report [message #551987 is a reply to message #551981]

Mon, 23 April 2012 01:52

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at spcreate.sql and check if someone is owning these objects.

Regards
Michel

Report message to a moderator

Re: statpack report [message #552608 is a reply to message #551987]

Thu, 26 April 2012 21:25

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

when i create the statspack report,awr report,addm report it display on the screen and by default it made into oracle home in linux and in c drive in window environment. can it redirect on the another location if yes then how?

pritesh ranjan

Report message to a moderator