RE: Statspack Problem

2002-05-21 Thread Tom Schruefer
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, Bruce (CALBBAY) Sent: Monday, May 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack Problem Have you connected via BEQ or Net8 initially? Have you got

RE: Statspack Problem

2002-05-21 Thread Tom Schruefer
: Statspack Problem -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Reardon, Bruce (CALBBAY) Sent: Monday, May 20, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: RE: Statspack Problem Have you connected via BEQ or Net8

Statspack Problem

2002-05-20 Thread Tom Schruefer
I am running 8.1.6 on a Win2000 SP2 machine. When I try running 'statscre.sql' as SYS, the first script completes fine, but when the second script tries to connect perfstat/perfstat , I get the error, You are no longer connected to Oracle TNS:ORA-12154. Of course the system then proceeds to

RE: Statspack Problem

2002-05-20 Thread Reardon, Bruce (CALBBAY)
Have you connected via BEQ or Net8 initially? Have you got oracle_sid set as an environment variable, as it looks like the connect perfstat/perfstat uses a BEQ connection. After connecting as sys, can you now do a connect perfstat/perfstat (though maybe the scripts cleaned up on error and