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: Babette Turner-Underwood <>
Date: Thu, 16 Aug 2001 19:35:22 -0700
Message-ID: <>

As everyone in this thread seems so
about NT, I would like to digress and ask a related question.
When I use oradim to create a service,
oradim -new -sid MINE -pfile c:\mine\initMINE.ora ....
The service is created, the instance is started!!
BUT, when I use svrmgrl to shutdown the instance
and then try to start it up, it complains because the
init file does not exist in
BUT the oradim DID create the entry:
ORA_MINE_PFILE = c:\mine\initMINE.ora
So what is this registry entry used
And why do I need to place the init.or
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

  Sent: Thursday, August 16, 2001 3:45
  Subject: RE: No TNSListner service after   intall 8.1.7 on Win 2k   

  think Networking services means TNSNAMES/SQLNET.ORA stuff (like a client   install).
  could do a custom install (I think) and just install TNS Listener, and not the   starter database.
  Tom Mercadante <FONT face=Arial
  size=2>Oracle Certified Professional   

<FONT face=Tahoma

    size=2>-----Original Message-----From: Cale, Rick T (Richard)     []Sent: Thursday, August 16, 2001     3:14 PMTo: Multiple recipients of list     ORACLE-LSubject: RE: No TNSListner service after intall 8.1.7 on     Win 2k
<FONT face=Arial color=#0000ff

    size=2>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

    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 <FONT 
      face=Batang>Oracle Database Administrator <FONT 
      face=Batang>Fairfield Resorts, Inc. <FONT 
        -----Original Message----- 
        From:   <FONT 
        face=Arial size=1>Cale, Rick T (Richard) 
        [] <FONT face=Arial 
        size=1>Sent:   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 
        No TNSListner service after intall 8.1.7 on Win 
        Hi All, 
        I did a typical installation of Oracle 8.1.7 
        on Win 2k. It appears to have <FONT face=Arial 
        size=2>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 <FONT 
        face=Arial size=2>from the server. Anyway the install did not create 
        service to start the listener.  
        All other installs I have done on NT always created <FONT 
        face=Arial size=2>a tnslistner service. This in my first install on Win 
        2k. 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 
        also send the HELP command for other 
        information (like subscribing). 
Received on Thu Aug 16 2001 - 21:35:22 CDT

Original text of this message