Re: Cant install statspack !

Bob,

The scripts contain CONNECT statements which likely do not include the "@instance" TNS connect-string you are using initially. The scripts also contain WHENEVER OSERROR and WHENEVER SQLERROR directives, so they blow out of SQL*Plus on error, most likely...

Please consider editing the scripts to add the TNS connect-strings?

Hope this helps...

-Tim

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