Has anyone installed Statspack?

[sysdba]

Hi,

I try to install statpack for our Oracle 8.1.6 database
3 times. So far, no luck.

Anyone have successfully installed it?

Thanks,

[sanrak]

Yes ,

I Installed and tested it in a NT / 8.1.6 environment . Any specific problems? What is the error message


Santhoshkumar
Certified Oracle DBA - 8i

[sysdba]

Here is the error message (Note I log on as sys):
SQL> @?/rdbms/admin/statscre
... Installing Required Packages

Package created.


Grant succeeded.


View created.


Package body created.


Package created.


Synonym dropped.


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


Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

[Muthu]

Hi,

The indications are that the objects already exist and the script disconnects.You can copy
the $ORACLE_HOME/rdbms/admin/statscre.sql file to another name and REM's out the create statements for those views that the script
was erroring out on since these statements were creating views that already existed. Try this.....

Muthu


[QUOTE][i]Originally posted by sysdba [/i]
[B]Here is the error message (Note I log on as sys):
SQL> @?/rdbms/admin/statscre
... Installing Required Packages

Package created.


Grant succeeded.


View created.


Package body created.


Package created.


Synonym dropped.


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


Disconnected from Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production [/B][/QUOTE]