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

if you open spdrop you see

Code:

---


--
--  Drop PERFSTAT's tables and indexes

@@spdtab


--
--  Drop PERFSTAT user

@@spdusr

---

if you open spdusr.sql you see

Code:

---

...........................
Rem
Rem  Drop PERFSTAT user cascade
Rem

drop user perfstat cascade;
.....................................

---

:D :D :D :D :D

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