| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Statspack Problem
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 deleted the perfstat user.
HTH,
Bruce Reardon
-----Original Message-----
Sent: Tuesday, 21 May 2002 11:39
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 attempt to run the other two scripts returning about a hundred "not connected" error messages.
The Perfstat user was created and I did not have the chance to intervene and change its password. Any ideas as to why the script would fail to connect?
I connected as internal in the first place to run the script, so I don't
think its TNS.
Tom Schruefer - tschruefer_at_mail.howard.k12.md.us
410-313-6825
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon May 20 2002 - 21:08:22 CDT
 |
 |