| 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
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 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 - 11:41:45 CDT
 |
 |