DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Oracle EE8.1.7.2 w/Statspack

  1. #1
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Oracle EE8.1.7.2 w/Statspack

    Has anybody succesfully get statspack to work with Ver 8172 on Unix? I have had some trouble with it. We are on 8172 because the underlaying app is Oracle Clinical and it cannot goto 8174.

    thanks

    Jigar
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Sure, I've got it to work. What's the problem?
    Jeff Hunter

  3. #3
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586
    Marist89,
    when I run the SPCUSR.sql script: I get the following error message:

    Package created.


    Grant succeeded.

    from dba_object_size
    *
    ERROR at line 4:
    ORA-00942: table or view does not exist
    "High Salaries = Happiness = Project Success."

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how about creating it...?!

  5. #5
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi
    Please run the spcusr.sql by connecting as INTERNAL.Please check the username under which you are running the STATSPACK.

    Regards
    Rohit S Nirkhe,Oracle/apps DBA
    OCP 8i,9i
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    do the easiest thing

    sqlplus internal
    @?/rdbms/admin/spdrop
    @?/rdbms/admin/spcreate

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