Home » Infrastructure » Linux » statpack report
statpack report [message #551484] Wed, 18 April 2012 11:46 Go to next message
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
Re: statpack report [message #551485 is a reply to message #551484] Wed, 18 April 2012 11:53 Go to previous messageGo to next message
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

Re: statpack report [message #551486 is a reply to message #551484] Wed, 18 April 2012 11:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And did you FIRST gather some statspack snapshots?

Regards
Michel
Re: statpack report [message #551489 is a reply to message #551486] Wed, 18 April 2012 12:33 Go to previous messageGo to next message
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?
Re: statpack report [message #551492 is a reply to message #551489] Wed, 18 April 2012 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read spdoc.txt you'll find at the same place there is spreport.sql and spcreate.sql.

Regards
Michel
Re: statpack report [message #551694 is a reply to message #551492] Fri, 20 April 2012 02:58 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks michel. i successfully create my statpack report.
icon7.gif  Re: statpack report [message #551981 is a reply to message #551694] Mon, 23 April 2012 01:32 Go to previous messageGo to next message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
how can i check the statpack is alreday install in my database.
Re: statpack report [message #551987 is a reply to message #551981] Mon, 23 April 2012 01:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at spcreate.sql and check if someone is owning these objects.

Regards
Michel
icon7.gif  Re: statpack report [message #552608 is a reply to message #551987] Thu, 26 April 2012 21:25 Go to previous messageGo to next message
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
Re: statpack report [message #552611 is a reply to message #552608] Thu, 26 April 2012 23:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give the file full path when asked for?

Regards
Michel
icon7.gif  Re: statpack report [message #552616 is a reply to message #552611] Fri, 27 April 2012 00:23 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks michel

regards
pritesh ranjan
Previous Topic: oracle on OEL vs REDHAT
Next Topic: Memory Utilization Issue
Goto Forum:
  


Current Time: Thu Mar 28 07:33:22 CDT 2024