Re: Cant install statspack !

Bob:

Try running the scripts in the command line version of SQL Plus. In NT use sqlplus instead of sqlplusw. The statscusr.sql prompts for a couple of tablespaces.
Start spooling right after logging in and set termout and echo on. You should capture some output this way.

RWB "Bob Metelsky" <bmetelsky_at_cps92.com>@fatcity.com on 01/07/2003 12:04:45 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

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).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Reginald.W.Bailey_at_jpmorgan.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).