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" <[EMAIL PROTECTED]>@fatcity.com on 01/07/2003 12:04:45 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
