AW: no listener

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Thu, 14 Dec 2000 10:30:08 +0100
Message-Id: <10710.124537@fatcity.com>

Hi Ura,

your Listener.ora isn't correct. Your listner won't listen to Intance = ORANT.
Try teh folowing listener configuration. Restart your listener and = start
svrmgrl. Then try this connect string:
connect sys/PW_at_ORANT as sysdba;

hope this woll Help

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

        (PRESENTATION =3D TTC)
        (SESSION =3D NS)
      )

    )
    (DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 127.0.0.1)(PORT =3D =
1521))

(PROTOCOL_STACK =3D

        (PRESENTATION =3D TTC)
        (SESSION =3D NS)
      )

    )
    (DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 127.0.0.1)(PORT =3D =
2481))

(PROTOCOL_STACK =3D

        (PRESENTATION =3D GIOP)
        (SESSION =3D RAW)
      )

    )
  )

SID_LIST_LISTENER =3D
  (SID_LIST =3D

     (SID_DESC =3D


      (GLOBAL_DBNAME =3D ORANT)

      (ORACLE_HOME =3D D:\ORANT8)

      (SID_NAME =3D ORANT)

    (SID_DESC =3D


      (SID_NAME =3D PLSExtProc)

      (ORACLE_HOME =3D D:\Oracle\Ora81)

      (PROGRAM =3D extproc)

    )
  )

     (SID_DESC =3D


      (GLOBAL_DBNAME =3D EW80)

      (ORACLE_HOME =3D D:\ORANT8)

      (SID_NAME =3D EW80)

Mit freundlichen Gr=FC=DFen

i. V. Volker Sch=F6n
INPLAN RUHR
Informationstechnik GmbH
Tel.: +49 208 / 65 91 - 950
Fax: +49 208 / 65 91 - 980
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

-----Urspr=FCngliche Nachricht-----
Von: Ura! [mailto:ura_at_ymz.yaroslavl.ru]
Gesendet: 14. December 2000 08:55
An: Multiple recipients of list ORACLE-L Betreff: 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 =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D
(ADDRESS =3D (PROTOCOL =3D IPC))

    )
    (CONNECT_DATA =3D
(SERVICE_NAME =3D OraNT)

    )
  )

ORANT =3D
  (DESCRIPTION =3D
    (ADDRESS_LIST =3D

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

    )
    (CONNECT_DATA =3D (SID =3D 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 =3D
  (DESCRIPTION_LIST =3D
    (DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D IPC)(KEY =3D EXTPROC0))
(PROTOCOL_STACK =3D

        (PRESENTATION =3D TTC)
        (SESSION =3D NS)
      )

    )
    (DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 127.0.0.1)(PORT =3D =
1521))

(PROTOCOL_STACK =3D

        (PRESENTATION =3D TTC)
        (SESSION =3D NS)
      )

    )
    (DESCRIPTION =3D
(ADDRESS =3D (PROTOCOL =3D TCP)(HOST =3D 127.0.0.1)(PORT =3D =
2481))

(PROTOCOL_STACK =3D

        (PRESENTATION =3D GIOP)
        (SESSION =3D RAW)
      )

    )
  )

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

    )
  )
Where is bug?

 =20

 =20

--------------------------------------=20
ura_at_ymz.yaroslavl.ru
Ura!                         =20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20
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 Received on Thu Dec 14 2000 - 03:30:08 CST