Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problem with statspack
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 EggenbergerReceived on Mon Apr 07 2003 - 06:35:38 CDT