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 <[EMAIL PROTECTED]> 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 sta! tsrep80.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://w! ww.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).
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
