statpack report [message #551484] |
Wed, 18 April 2012 11:46 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/5e3d913875c539fe5a14a99c089b6e7a?s=64&d=mm&r=g) |
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
|
|
|
|
|
|
|
|
|
|
|
|
|