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 0
cc:
Sent by: Subject: Re: Cant install statspack !
[EMAIL P
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 bel
Bob Metelsky
com> cc:
Sent by: Subject:
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
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 q
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 script
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,
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
