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\ADMINdir stats*
02/08/2000 07:36p
I had some problems with stats pack install today.
There is: 'on error exit' in the scripts. Remove it so the script can
continue. This may solved your problem.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 07,
Bob,
The scripts contain CONNECT statements which likely do not
include the @instance TNS connect-string you are using
initially. The scripts also contain WHENEVER OSERROR and
WHENEVER SQLERROR directives, so they blow out of SQL*Plus
on error, most likely...
Please consider editing the scripts
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
Bob:
Try running the scripts in the command line version of SQL Plus. In NT use
sqlplus instead of sqlplusw. The statscusr.sql prompts for a couple of
tablespaces.
Start spooling right after logging in and set termout and echo on. You
should capture some output this way.
RWB
Bob Metelsky
HOT DAMM!!
Ive taken everyones suggestions and did the following
Edited all the stats* file to change
whenever sqlerror exit;
To
whenever sqlerror continue;
And connect perfstat/perfstat
To
connect perfstat/perfstat@instance
I also ran the script from a cmd window rather than sqlplusw
I
]
hoo.com cc:
Sent by: Subject: Re: Cant install statspack
I get around the connect problem by setting oracle_sid before invoking
sqlplus (no W) from a dos box in NT.
Of course, this means that I work on the server itself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January
:
Sent by: Subject: Cant install statspack !
[EMAIL PROTECTED