Re: TNS: no listener

From: <prabhu.srinivasan_at_ap.abnamro.com>
Date: Thu, 14 Dec 2000 17:31:26 +0800
Message-Id: <10710.124536@fatcity.com>

The SID name that u r using should appear in the SID_LIST_LISTENER section of Listener.ora. Pls. check.
You can manually create an entry in the file(open it in notepad).

ura_at_ymz.yaroslavl.ru_at_fatcity.com on 14/12/2000 03:55:26 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: TNS: no listener

Hi dear ALL

---

ORA-12541 error occured.
I am beginer oracle admin.
I just now install Oracle server 8i on winNT4. I try to logon server as sysdba from svrmgrl connect sys/pass as sysdba
and accept this error.
My tnsnames file:
ORANT.UAS =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC))

    )
    (CONNECT_DATA =
(SERVICE_NAME = OraNT)

    )
  )

ORANT =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =
          (PROTOCOL = TCP)
          (Host = 127.0.0.1)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID = ORANT)
    )
  )
My listener file:
# D:\ORACLE\ORA81\NETWORK\ADMIN\LISTENER.ORA Configuration File:D: \Oracle\Ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle Net8 Assistant

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 2481))
(PROTOCOL_STACK =

        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Oracle\Ora81)
(PROGRAM = extproc)

    )
  )
Where is bug?

---

ura_at_ymz.yaroslavl.ru
Ura!

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ura!
  INET: ura_at_ymz.yaroslavl.ru

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

Received on Thu Dec 14 2000 - 03:31:26 CST