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
To: Multiple recipients of list ORACLE-L
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?
"Cale, Rick T
(Richard)" To: Multiple recipients of
list ORACLE-L
<RICHARD.T.CALE <[EMAIL PROTECTED]>
@saic.com> cc:
Sent by: Subject: RE: No TNSListner
service after
[EMAIL PROTECTED] intall 8.1.7 on Win 2k
m
08/16/2001
03:13 PM
Please respond
to ORACLE-L
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
To: Multiple recipients of list ORACLE-L
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
To:���� Multiple recipients of list ORACLE-L
Subject:������� 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
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: Cale, Rick T (Richard)
� 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Cale, Rick T (Richard)
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).
