Problem with STATSPACK
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Problem with STATSPACK

  1. #1
    Join Date
    Feb 2001
    Posts
    41

    Question 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

  2. #2
    Join Date
    Sep 2002
    Posts
    411
    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

  3. #3
    Join Date
    Feb 2001
    Posts
    41
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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;
    .....................................

  5. #5
    Join Date
    Feb 2001
    Posts
    41

    Thumbs up

    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
  •  


Click Here to Expand Forum to Full Width