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@cps92. To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
com> cc:
Sent by: Subject: Cant install statspack !
[EMAIL PROTECTED]
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@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://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: [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).
_____________
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: [EMAIL PROTECTED]
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: [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).
