Oracle-L: Re: Cant install statspack !

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Tue, 07 Jan 2003 10:37:21 -0800
Message-ID: <F001.00528DBE.20030107103721@fatcity.com>

Bob:
I have a slightly different version. My spcreate.sql involkes 3 scripts: @@spcusr, @@spctab,@@spcpkg. The problem that I had was that spcusr was creating some x_ views that already existed in the database (perhaps from Steve Adams' script). When the spcusr script encounters the errors, it quits and does not proceed with the remainder of the creation.

I had to modify the script and take out all the references to the x_ views (or delete them, I don't remember which) in order to get a clean install.

You should have the equivalent of an spdrop. If so you can run it and start over, but this will not remove the x_ views and synonyms.

(Also make sure you're not using svrmgrl. statspack does not like svrmgrl)

Good luck!

Barb

Bob Metelsky <bmetelsky_at_cps92.com> wrote: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).

Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--

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

Author: Barbara Baker
INET: barbarabbaker_at_yahoo.com

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