Oracle FAQ Your Portal to the Oracle Knowledge Grid

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

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

From: Reardon, Bruce (CALBBAY) <>
Date: Thu, 16 Aug 2001 18:22:06 -0700
Message-ID: <>


On NT / W2K to get a listener service I have found that you need 2 things: 1 - a (valid) listener.ora file (may be optional but certainly needed if you want a correctly functioning listener)
2 - from a CMD prompt issue the "lsnrctl start" command and this will create the service for the listener named "listener". If you (say) also have a listener named "listener2" then "lsnrctl start listener2" will create the service for this listener. You will get an error that the service could not be opened (as shown below) but then the service will be created.

You then need to set these services to autostart if that is what you want.

I am guessing that if you create a start database then the "lsnrctl start" command gets run for you - I have never used Oracle to create the starter database and so can't comment.

For example:

H:\>lsnrctl start listener2

LSNRCTL for 32-bit Windows: Version - Production on 17-AUG-2001 08:36

(c) Copyright 1998 Oracle Corporation. All rights reserved.

Starting tnslsnr: please wait...

Failed to open service <Oracle817TNSListenerlistener2>, error 1060. TNSLSNR for 32-bit Windows: Version - Production System parameter file is c:\oracle\admin\tns_admin\listener.ora Log messages written to C:\oracle\product\817\network\log\listener2.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=s357)(PORT=1526))



Alias                     listener2
Version                   TNSLSNR for 32-bit Windows: Version -
Start Date                17-AUG-2001 08:36:55
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON
SNMP                      OFF
Listener Parameter File   c:\oracle\admin\tns_admin\listener.ora
Listener Log File         C:\oracle\product\817\network\log\listener2.log
Services Summary...
  PLSExtProc            has 1 service handler(s)
  db1          has 1 service handler(s)
  db2          has 1 service handler(s)

The command completed successfully

H:\>net start | find "oracle" /i



I hope this helps.

Bruce Reardon

-----Original Message-----

Sent: Friday, 17 August 2001 7:08

Thanks for the input. I am going to have a database but I did not want the starter database I want to
create my own. A tnslistener service should get created regardless of whether I opted for the starter
database or not.


-----Original Message-----

Sent: Thursday, August 16, 2001 4:13 PM

I'll give this a whack though I suspect that there are people who could do a better job.

The Windows registry is the conceptual equivalent of the UNIX environmental variables.

ORACLE_SID, ORACLE_HOME, etc can be found under HK_LOCAL_MACHINE\Software\Oracle.

You can change these using REGEDIT; however, make a backup of the registry before you change anything (REGEDIT has that capability). If you make enough of a hash of the registry you can end up with an un-bootable machine, so be careful.

ORADIM can create the services for LISTENER and the database. It can also create the database.

I'm not sure why you would want a listener on a machine where you don't have a database?

Windows Services are a pain to remove. You have to find them in the registry and delete the entry. It's easier to go the Services under Windows Control Panel and set them for Manual startup. They add a little bit of bulk to the registry but consume no other resources.

Anyone have anything else to add or correct?


Ok, I am getting 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
database. This did NOT create a listener service. However it clearly states it would install networking services.

I did a 2nd TYPICAL install and it did create a tnslistener service. As 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.

I 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)!!!

-----Original Message-----

Sent: Thursday, August 16, 2001 1:28 PM

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.

   -----Original Message-----
   From:   Cale, Rick T (Richard) []    Sent:   Thursday, August 16, 2001 12:36 PM

   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    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.    Anyone have any ideas on why service did not get created and how to    correct?


Please see the official ORACLE-L FAQ:

Author: Reardon, Bruce (CALBBAY)

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: (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 - 20:22:06 CDT

Original text of this message