| 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 intall 8.1.7 on Win 2k
Ok, I
am g<FONT face=Arial color=#0000ff
size=2>etting 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
<FONT face=Arial color=#0000ff
size=2>database. This did NOT create a listener service. However it clearly
states it would install networking services.
<FONT face=Arial color=#0000ff
size=2>
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.
<FONT face=Arial color=#0000ff
size=2>
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)!!!
<FONT face=Arial color=#0000ff
size=2>
<FONT face=Arial color=#0000ff
size=2>Rick
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]Sent: Thursday, August 16, 2001
1:28 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: No TNSListner service after intall 8.1.7 on Win 2k
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----- <FONT
face=Arial size=1>From: Cale,
Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com] <FONT
face=Arial size=1>Sent: <FONT face=Arial
size=1>Thursday, August 16, 2001 12:36 PM <FONT face=Arial
size=1>To: <FONT face=Arial
size=1>Multiple recipients of list ORACLE-L <FONT face=Arial
size=1>Subject: <FONT
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 <FONT
face=Arial size=2>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. <FONT face=Arial
size=2>Anyone have any ideas on why service did not get created and how to
correct?
Thanks <FONT face=Arial
size=2>Rick -- <FONT
face=Arial size=2>Please see the official ORACLE-L FAQ: <A target=_blank
href="http://www.orafaq.com">http://www.orafaq.com <FONT
face=Arial size=2>-- Author: Cale, Rick T
(Richard) INET:
size=2>--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send
an E-Mail message to:
 |
 |