RE: TNS: no listener

From: Clinton Naude <clintonn_at_meb.co.za>
Date: Thu, 14 Dec 2000 12:20:12 +0200
Message-Id: <10710.124544@fatcity.com>

Also check that you are logging into the correct enviroment. run the following command .oraenv and it will ask what your Ora home and database are that you want to connect to. This will point oracle to the correct files.

Thanks

Clint

-----Original Message-----
From: prabhu.srinivasan_at_ap.abnamro.com
[mailto:prabhu.srinivasan_at_ap.abnamro.com] Sent: Thursday, December 14, 2000 11:31 AM To: Multiple recipients of list ORACLE-L Subject: Re: TNS: no listener

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:

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
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: prabhu.srinivasan_at_ap.abnamro.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

Received on Thu Dec 14 2000 - 04:20:12 CST