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
---------
VIKING
SQL>
-----Original Message-----
From: Igor Neyman [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: No TNSListner service after intall 8.1.7 on Win 2k
Lisa,
�
Try:
�
SET ORACLE_SID
�
You should get:
�
ORACLE_SID='your_sid'
�
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
�
----- Original Message -----
From: Koivu, Lisa <mailto:[EMAIL PROTECTED]>
To: Multiple recipients of list ORACLE-L <mailto:[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 1:28 PM
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
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).
