| 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
<SPAN
class=697145017-16082001>Lisa,
<SPAN
class=697145017-16082001>
<SPAN
class=697145017-16082001>C:\> set
ORACLE_SID=SID_NAME
<SPAN
class=697145017-16082001>Then...
<SPAN
class=697145017-16082001>C:\> set ORACLE_SID
<SPAN
class=697145017-16082001>ORACLE_SID=SID_NAME
<SPAN
class=697145017-16082001>
Ed
Haskins
Oracle
DBA
<SPAN
class=697145017-16082001>Verizon Wireless
<FONT face=Tahoma
size=2>-----Original Message-----From: Koivu, Lisa
[mailto:lisa.koivu_at_efairfield.com]Sent: Thursday, August 16, 2001
2:22 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: No TNSListner service after intall 8.1.7 on Win 2k
Hi Igor, thanks for your reply.
Call me a bonehead... but I got
nothing. What am I missing?
C:\>set ORACLE_SID
Environment variable
ORACLE_SID not defined
C:\>sqlplus system
SQL*Plus: Release 8.1.7.0.0 -
Production on Thu Aug 16 13:18:15 2001
(c) Copyright 2000 Oracle
Corporation. All rights reserved.
Enter password:
Connected to:
Oracle8i Release 8.1.7.0.0 -
Production JServer
Release 8.1.7.0.0 - Production
SQL> select name from
v$database;
NAME <FONT
color=#0000ff face="Courier New" size=2>--------- <FONT
color=#0000ff face="Courier New" size=2>VIKING
SQL>
-----Original Message----- <FONT
face=Arial size=1>From: Igor
Neyman [SMTP:ineyman_at_perceptron.com] <FONT face=Arial
size=1>Sent: Thursday, August
16, 2001 2:07 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
face=Arial size=1>Re: No TNSListner service after intall 8.1.7 on Win
2k
face=Arial>ineyman_at_perceptron.com <<A
href="mailto:ineyman_at_perceptron.com">mailto:ineyman_at_perceptron.com><FONT
face=Arial>
----- Original Message ----- <FONT
face=Arial>From: <FONT color=#0000ff
face=Arial>Koivu, Lisa <<A
href="mailto:lisa.koivu_at_efairfield.com">mailto:lisa.koivu_at_efairfield.com><FONT
face=Arial> To:<FONT
face=Arial> Multiple recipients
of list ORACLE-L <<A
href="mailto:ORACLE-L_at_fatcity.com">mailto:ORACLE-L_at_fatcity.com><FONT
face=Arial> Sent:<FONT
face=Arial> Thursday, August 16, 2001 1:28 PM <FONT
face=Arial>Subject: 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=Arial>Oracle Database
Administrator<FONT
face=Batang>Fairfield Resorts, Inc.<FONT
face=Arial>954-935-4117<FONT
face=Arial>
-----Original Message-----<FONT
face=Arial><FONT face=Arial
size=1>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:
Multiple recipients of list
ORACLE-L<FONT face=Arial
size=1>Subject: <FONT
face=Arial> 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.<FONT face=Arial
size=2>However when I try to use worksheet I get no listner. I should not
need onefrom
the server. Anyway the install did not create service<FONT
face=Arial>to start the listener.
All other installs I have done on NT always created<FONT
face=Arial>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
href="http://www.orafaq.com"
target=_blank>http://www.orafaq.com><FONT
face=Arial>--<FONT
face=Arial size=2>Author: Cale, Rick T (Richard)<FONT
face=Arial> INET:
RICHARD.T.CALE_at_saic.com
Fat City Network Services --
(858) 538-5051 FAX: (858) 538-5051<FONT
face=Arial>San Diego,
California -- Public Internet
access / Mailing Lists<FONT face=Arial
size=2>--------------------------------------------------------------------<FONT
face=Arial>To REMOVE yourself from this
mailing list, send an E-Mail message<FONT
face=Arial>to: ListGuru_at_fatcity.com
(note EXACT spelling of 'ListGuru') and in<FONT
face=Arial>the message BODY, include a
line containing: UNSUB ORACLE-L<FONT
face=Arial size=2>(or the name of mailing list you want to be removed
from). You may<FONT face=Arial
size=2>also send the HELP command for other information (like
subscribing).
Received on Thu Aug 16 2001 - 13:02:25 CDT
 |
 |