Re: Cant install statspack !

I had some problems with stats pack install today. There is: 'on error exit' in the scripts. Remove it so the script can continue. This may solved your problem.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, January 07, 2003 8:04 PM

> 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: Yechiel Adar
  INET: adar76_at_inter.net.il

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