Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: TNS Listener service question

Re: TNS Listener service question

From: <Srini.Chavali_at_Cummins.com>
Date: Wed, 21 Nov 2001 08:06:52 -0800
Message-ID: <F001.003CAAB7.20011121072604@fatcity.com>

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).
Received on Wed Nov 21 2001 - 10:06:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US