| 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
As everyone in this thread seems so
knowledgeable
about NT, I would like to digress and ask a related
question.
When I use oradim to create a service,
oradim -new -sid MINE -pfile c:\mine\initMINE.ora
....
The service is created, the instance is
started!!
BUT, when I use svrmgrl to shutdown the
instance
and then try to start it up, it complains because
the
init file does not exist in
%ORACLE_HOME%\pfile
BUT the oradim DID create the entry:
ORA_MINE_PFILE = c:\mine\initMINE.ora
So what is this registry entry used
for?
And why do I need to place the init.or
under
%ORACLE_HOME%\pfile
Thanks
Babette
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
Sent: Thursday, August 16, 2001 3:45
PM
Subject: RE: No TNSListner service after
intall 8.1.7 on Win 2k
<SPAN
class=232022918-16082001>Rick,
<SPAN
class=232022918-16082001>
I
think Networking services means TNSNAMES/SQLNET.ORA stuff (like a client
install).
<SPAN
class=232022918-16082001>
You
could do a custom install (I think) and just install TNS Listener, and not the
starter database.
Tom Mercadante <FONT face=Arial
size=2>Oracle Certified Professional
<FONT face=Tahoma
size=2>-----Original Message-----From: Cale, Rick T (Richard)
[mailto:RICHARD.T.CALE_at_saic.com]Sent: Thursday, August 16, 2001
3:14 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: No TNSListner service after intall 8.1.7 on
Win 2k
<FONT face=Arial color=#0000ff
size=2>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 <FONT
face=Batang>Oracle Database Administrator <FONT
face=Batang>Fairfield Resorts, Inc. <FONT
face=Batang>954-935-4117
-----Original Message-----
From: <FONT
face=Arial size=1>Cale, Rick T (Richard)
[SMTP:RICHARD.T.CALE_at_saic.com] <FONT face=Arial
size=1>Sent: 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:
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 <FONT face=Arial
size=2>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 <FONT
face=Arial size=2>from the server. Anyway the install did not create
service to start the listener.
All other installs I have done on NT always created <FONT
face=Arial size=2>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 <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:
RICHARD.T.CALE_at_saic.com
Fat City Network Services
-- (858) 538-5051 FAX: (858) 538-5051 <FONT face=Arial
size=2>San Diego, California
-- Public Internet access / Mailing Lists <FONT face=Arial
size=2>--------------------------------------------------------------------
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 - 21:35:22 CDT
 |
 |