Re: Cant install statspack !

I think the SQL_PATH is not pointing to $ORACLE_HOME/rdbms/admin - so its unable to find the scripts...

Open a DOS window, cd to the folder and try running using "sqlplus" and not "sqlplusw".. Or edit the SQL_PATH in yr registry.. Or edit the STATSCRE.SQL to include the full path

Babu

                                                                                                                                                    
                      Bob Metelsky                                                                                                                  
                      <bmetelsky_at_cps92.        To:       Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>                                
                      com>                     cc:                                                                                                  
                      Sent by:                 Subject:  Cant install  statspack !                                                                  
                      root_at_fatcity.com                                                                                                              
                                                                                                                                                    
                                                                                                                                                    
                      01/07/03 01:04 PM                                                                                                             
                      Please respond to                                                                                                             
                      ORACLE-L                                                                                                                      
                                                                                                                                                    
                                                                                                                                                    

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




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