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
tion
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
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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
