| 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
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 <ORACLE-L_at_fatcity.com>
@saic.com> cc:
Sent by: Subject: RE: No TNSListner service
after
root_at_fatcity.co 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:RICHARD.T.CALE_at_saic.com] Sent: Thursday, August 16, 2001 12:36 PM To: Multiple recipients of list ORACLE-LSubject: 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: RICHARD.T.CALE_at_saic.com
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).
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: tday6_at_csc.com 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: 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 - 13:58:53 CDT
 |
 |