Ifg you have a look at the scripts you will see that they issue connects
without a tnsnames alias at the end. Correct the script (or run from the
console - not terminal services - with the sid set).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Marc Eggenberger" <marc.eggenberger_at_itc.alstom.com> wrote in message
news:MPG.18fb80f294ebee6b98968f_at_localhost...
> Hi there.
>
> I tried to install the statspack package on one of my servers.
>
> there is a textfile in %ORACLE_HOME%\rdbms\admin which explains how to
> do it .. but I fail.
>
> System is
> Oracle 8.1.7 OPS on Win2 Advanced Server (Cluster).
>
> in the textfail it says I should do:
>
> on NT:
> SQL> connect / as sysdba
> SQL> @%ORACLE_HOME%\rdbms\admin\spcreate
>
> I do a
>
> sqlplus sys/password_at_mydbserver
> then
> SQL> @%ORACLE_HOME%\rdbms\admin\spcreate
>
> It runs the first script (statsdtab.sql) and promts me for the
> tablespace for the perfstat user. But then I think it tried to execute
> the second and third script (statsctab.sql and statspack.sql) but I get
> errors SP2-0640: that say I'm not connected.
>
> What am I doing wrong here?
>
>
> --
> mfg
> Marc Eggenberger
Received on Mon Apr 07 2003 - 09:26:17 CDT
