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

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 16 Aug 2001 10:00:11 -0700
Message-ID: <F001.0036D779.20010816100718@fatcity.com>

Lisa,
 

Try:
 

SET ORACLE_SID
 

You should get:
 

ORACLE_SID='your_sid'
 

Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627<A href="mailto:ineyman_at_perceptron.com">ineyman_at_perceptron.com 

<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A title=lisa.koivu_at_efairfield.com href="mailto:lisa.koivu_at_efairfield.com">Koivu, Lisa To: <A title=ORACLE-L_at_fatcity.com href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L

  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----- <FONT

    face=Arial size=1>From:   Cale, 
    Rick T (Richard) [SMTP:RICHARD.T.CALE_at_saic.com] <FONT 
    face=Arial size=1>Sent:   <FONT face=Arial 
    size=1>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:        <FONT
    face=Arial size=1>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 <FONT     face=Arial size=2>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. <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 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 <FONT face=Arial     size=2>also send the HELP command for other information (like     subscribing). Received on Thu Aug 16 2001 - 12:00:11 CDT