RE: No TNSListner service after intall 8.1.7 on Win 2k

[Cale, Rick T (Richard)]

Title: RE: No TNSListner service after intall 8.1.7 on Win 2k

Ok, I am getting 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

database. This did NOT create a listener service. However it clearly states it would install networking services. 

 

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.

 

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)!!!

 

Rick

-----Original Message-----
From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 1:28 PM
To: Multiple recipients of list ORACLE-L
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).