Has anyone installed Statspack?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Has anyone installed Statspack?

  1. #1
    Join Date
    Jun 2000
    Posts
    295
    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,


  2. #2
    Join Date
    Nov 2000
    Posts
    25
    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

  3. #3
    Join Date
    Jun 2000
    Posts
    295
    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

  4. #4
    Join Date
    Nov 2000
    Posts
    1
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width