If I understand you correctly, you are shutting down a listener on your NT box, and then, from your NT box, you are connecting to a remote database using SQL*Plus. Am I understanding you correctly?
You shouldn't need to have a listener running on your NT box to connect to a remote database, so that fact that SQL*Plus can connect doesn't surprise me. I don't understand why your GUI tools wouldn't connect, though I may also be misunderstanding your original note. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com Wednesday, November 21, 2001, 10:05:20 AM, you wrote: BPJ> I noticed that if I leave the TNS Listener service stopped on my NT BPJ> workstation, I can't access anything using the GUI tools. BPJ> But my script that runs command line can successfully login to the remote BPJ> databases to verify that they are accessible. It uses BPJ> c:\oracle\ora81\bin\sqlplus.exe. BPJ> Do the command-line utilities bypass the NT TNSListener service? BPJ> Just curious, I am leaving the service up now... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
