Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: No TNSListner service after intall 8.1.7 on Win 2k

RE: No TNSListner service after intall 8.1.7 on Win 2k

From: Cale, Rick T (Richard) <>
Date: Thu, 16 Aug 2001 11:24:25 -0700
Message-ID: <>

Ok, I
am g<FONT face=Arial color=#0000ff
size=2>etting a little closer to figuring out what is going on. I did mis-state the type of install I did first. It was minimal installation without the starter

<FONT face=Arial color=#0000ff

size=2>database. This did NOT create a listener service. However it clearly states it would install networking services. 
<FONT face=Arial color=#0000ff

I did
a 2nd TYPICAL install and it did create a tnslistener service.
soon as I get time/ambition/curiousity I will do a 3rd install WITH starter database to see it that will create a listener service.
<FONT face=Arial color=#0000ff

really do not want a starter database installed to get a tnslistener service but I could always delete it if I do not want it(Kldugy)!!!
<FONT face=Arial color=#0000ff

<FONT face=Arial color=#0000ff


  <FONT face=Tahoma
  size=2>-----Original Message-----From: Koivu, Lisa   []Sent: Thursday, August 16, 2001   1:28 PMTo: Multiple recipients of list ORACLE-LSubject:   RE: No TNSListner service after intall 8.1.7 on Win 2k   Hi Rick,
  I ran into this as well.  I
  figured I didn't need a listener on my w2k box because everything was going to   be local.  However I couldn't connect via sqlplus gui without a listener   (no listener error - maybe because I am specifying the sid).  I guess   it's just another difference between Oracle on windows and Oracle on Unix.   

  If I remember right (it's been soooo
  long) when you connect in Unix with the $ORACLE_SID as part of your env, you   can do so without @. If you do it with the @, it looks for a   listener.   When connecting via a windows gui, you are specifying   the sid.  I'm guessing it's doing something similar to the @ in the   background.  The cmd window connects without the @ because it's in the   environment.
  By the way, how do you display an
  environment variable in Windows?  I thought it was echo %ORACLE_SID%, but   that doesn't work.  Anyone?
  Again I may be pre-coffee. 
  Lisa Koivu Oracle
  Database Administrator Fairfield Resorts,   Inc. 954-935-4117   

    -----Original Message----- <FONT

    face=Arial size=1>From:   Cale, 
    Rick T (Richard) [] <FONT 
    face=Arial size=1>Sent:   <FONT face=Arial 
    size=1>Thursday, August 16, 2001 12:36 PM <FONT face=Arial 
    size=1>To:     <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L <FONT face=Arial 
    size=1>Subject:        <FONT
    face=Arial size=1>No TNSListner service after intall 8.1.7 on Win 2k     

    Hi All,
    I did a typical installation of Oracle 8.1.7 on     Win 2k. It appears to have installed     Ok.  I can use srvmgrl -> create database -> etc.     However when I try to use worksheet I get no     listner. I should not need one from the     server. Anyway the install did not create service <FONT     face=Arial size=2>to start the listener.  All other installs I have     done on NT always created a tnslistner     service. This in my first install on Win 2k. <FONT face=Arial     size=2>Anyone have any ideas on why service did not get created and how to     correct?
    Thanks <FONT face=Arial

    size=2>Rick -- <FONT 
    face=Arial size=2>Please see the official ORACLE-L FAQ: <A target=_blank 
    href=""> <FONT 
    face=Arial size=2>-- Author: Cale, Rick T 
    (Richard)   INET:
    Fat City Network Services    --
    (858) 538-5051  FAX: (858) 538-5051 <FONT face=Arial     size=2>San Diego, California        --     Public Internet access / Mailing Lists <FONT face=Arial
    To REMOVE yourself from this mailing list, send     an E-Mail message to: (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 <FONT face=Arial     size=2>also send the HELP command for other information (like     subscribing). Received on Thu Aug 16 2001 - 13:24:25 CDT

Original text of this message