Oracle-L: Re: Cant install statspack !

From: <babu.nagarajan_at_Cummins.com>
Date: Tue, 07 Jan 2003 11:08:47 -0800
Message-ID: <F001.00528EDF.20030107110847@fatcity.com>

I remember seing a script on Steve Adam's site that will delete the views created so that STATSPACK can install correctly

Babu

                                                                                                                                                    
                      Barbara Baker                                                                                                                 
                      <barbarabbaker_at_ya        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                
                      hoo.com>                 cc:                                                                                                  
                      Sent by:                 Subject:  Re: Cant install  statspack !                                                              
                      root_at_fatcity.com                                                                                                              
                                                                                                                                                    
                                                                                                                                                    
                      01/07/03 01:37 PM                                                                                                             
                      Please respond to                                                                                                             
                      ORACLE-L

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 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_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://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: 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

This e-mail transmission and any attachments to it are intended solely for the use of the individual or entity to whom it is addressed and may contain confidential and privileged information. If you are not the intended recipient, your use, forwarding, printing, storing, disseminating, distribution, or copying of this communication is prohibited. If you received this communication in error, please notify the sender immediately by replying to this message and delete it from your computer.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: babu.nagarajan_at_Cummins.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).

Received on Tue Jan 07 2003 - 13:08:47 CST