Re: TNS Listener service question

Patrice,
SqlPlus uses the Bequeath protocol to access local databases if the "@" is omitted in the connect string. If the "@" is present (i.e. connect scott/tiger_at_db) then it uses Net8. See Note 118381.1 on Metalink. HTH
Srini Chavali
Oracle DBA
Cummins Inc

"Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>@fatcity.com on 11/21/2001 10:05:21 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

I noticed that if I leave the TNS Listener service stopped on my NT workstation, I can't access anything using the GUI tools.

But my script that runs command line can successfully login to the remote databases to verify that they are accessible. It uses c:\oracle\ora81\bin\sqlplus.exe.

Do the command-line utilities bypass the NT TNSListener service?

Just curious, I am leaving the service up now...

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Srini.Chavali_at_Cummins.com

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).