-
Problem with STATSPACK
Hi Guys,
Database: Oracle 8.1.7 EE
OS: Solaris 7
I would like to use STATSPACK. When I ran spcreate.sql got the following errors:
$ cat spcusr.lis
... Installing Required Packages
Package created.
Grant succeeded.
View created.
Package body created.
Package created.
Synonym created.
Grant succeeded.
create view X_$KCBFWAIT as select * from X$KCBFWAIT
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
Could you please explain why I am getting this?
Thanks in advance.
Cheers!
Farrukh
-
don't know what happened but you can certainly drop statspack and recreate it by doing the following:
be sure using SQL not SVRMGRL
1. log in as SYS
2. run spdrop.sql to drop statspack
3. log in as perfstat/perfstat
4. run spcpkg.sql
5. run statspack.snap
-
Thanks for quick reply.
I have done the same as you mentioned. After running spdrop.sql I tried to connect with perfstat user:
test2:sys> @spdrop.sql
test2:sys> conn perfstat
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied
Thanks once again for your time.
Cheers.
Farrukh
-
-
Hi guys,
After RTFM, found that if we need to run spcreate.sql as batch mode, we have to specify default & temporary tablespaces. Otherwise, it will create PERFSTAT user, tables, indexes and packages under SYSTEM tablespace.
STATSPACK is ready to use now!
Anyway, thanks guys for help!
Cheers!
Farrukh
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|