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: Igor Neyman <>
Date: Thu, 16 Aug 2001 10:00:11 -0700
Message-ID: <>




You should get:


Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627<A href=""> 

style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

  Sent: Thursday, August 16, 2001 1:28
  Subject: 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 - 12:00:11 CDT

Original text of this message