| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
Hi,
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 8.1.7.1.0 - Production on 17-AUG-2001
08:36
50
(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 8.1.7.1.0 - 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))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=s357)(PORT=1526))
STATUS of the LISTENER
Alias listener2 Version TNSLSNR for 32-bit Windows: Version 8.1.7.1.0 -Produ
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)
H:\>net start | find "oracle" /i
Oracle817TNSListenerlistener2
H:\>
I hope this helps.
Regards,
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.
Thanks
Rick
-----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)!!!
Rick
-----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.
954-935-4117
-----Original Message-----
From: Cale, Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com]
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?
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Thu Aug 16 2001 - 20:22:06 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |