Cant install statspack !

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Tue, 07 Jan 2003 10:04:45 -0800
Message-ID: <F001.00528CD5.20030107100445@fatcity.com>

Hello All

        I seem to be missing something very basic as no matter what I do I cant get statspack to install

This is 8.16 on WIN2kpro

I downloaded the newest version of stataspack and placed it into %oracle_home%\rdbms\admin

C:\Oracle\Ora81\RDBMS\ADMIN>dir stats*

02/08/2000  07:36p               1,805 statsauto.sql
02/08/2000  07:36p                 891 statscauto.sql
12/30/1999  02:13p               1,832 statscbps.sql
02/08/2000  07:36p                 882 statscre.sql
02/08/2000  07:36p              28,088 statsctab.sql
02/08/2000  07:36p              27,879 statsctaba.sql
02/08/2000  07:36p               5,098 statscusr.sql
02/08/2000  07:36p               4,384 statscusra.sql
02/08/2000  07:36p                 829 statsdrp.sql
02/08/2000  07:36p               3,344 statsdtab.sql
02/08/2000  07:36p               1,136 statsdusr.sql
02/08/2000  07:34p              28,516 statspack.doc
02/08/2000  07:36p              51,400 statspack.sql
02/08/2000  07:36p              48,205 statsrep.sql
01/19/2000  06:53p              52,610 statsrep80.sql
02/08/2000  07:36p                 579 statsuexp.par
              16 File(s)        257,478 bytes

I log onto the db sqlplusw internal/pw_at_instance

SQL>@%oracle_home%\rdbms\admin\statscre.sql the script seems to create the user.. but then blinks out. Apparently its soupposed to generate .lis files but there are no such files

I tried to spool a log file but It only captures the first line... as the script blinks out

if I try to

SQL> execute statspack.snap

I get
PLS-00201: identifier 'STATSPACK.SNAP' must be declared

I try to prefix it with perfstat. or sys. but no joy

what can I be doing wrong??

Ive tried to hack the scripts(so they would "stay up") but there are so many variables that it dosnt seem practical

Thanks
bob
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Bob Metelsky
  INET: bmetelsky_at_cps92.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jan 07 2003 - 12:04:45 CST