Re: ORA-12541: TNS: Kein Listener

From: Christoph Kukulies <kuku_at_gil.physik.rwth-aachen.de>
Date: 28 Jan 2000 16:17:02 GMT
Message-ID: <86sfdu$q5q$1@nets3.rz.RWTH-Aachen.DE>

Sigrid Ehrenreich <Sigrid.Ehrenreich_at_carus.de> wrote:

:> I've got a big Problem with my Oracle- Server! I always get the message: :> ORA-12541 : TNS: Kein Listener. But I've got a Listener!! Wat can I Do??!!

: If your listener is running: What port is it listening on and do you : reference this port in the tnsnames.ora of your client?

: Yours Sigrid Ehrenreich
: seh_at_carus.de

I have the same problem as the original poster. And it happened on machine configurations that used to work two months ago.

using lsnrctl80 I find messages saying that the listener did not accept a password (in german: Listener hat das Passwort nicht angenommen - TNS-01169).

Don't know if thats only the connection bewteen lsnrctl80 and the listener or if it refers to the client connection.

# D:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:D:\orant\net80\admin\listener.ora # Generated by Oracle Net8 Assistant

PASSWORDS_LISTENER= (oracle)

STARTUP_WAIT_TIME_LISTENER = 0 LISTENER =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle.world))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(ADDRESS = (COMMUNITY = NMP.world)(PROTOCOL = NMP)(SERVER = DMSERVER)(PIPE = ORAPIPE))
(ADDRESS = (PROTOCOL = TCP)(Host = dmserver)(Port = 1521))
(ADDRESS = (PROTOCOL = TCP)(Host = dmserver)(Port = 1526))
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = ORC0))
(ADDRESS = (PROTOCOL=IPC)(KEY=ORC1))
  )

CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = dmserver)
      (SID_NAME = ORCL)

    )
(SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM = extproc)

    )
(SID_DESC =

      (SID_NAME = ORC0)
    )
(SID_DESC = (SID_NAME=ORC1))

  )

TRACE_LEVEL_LISTENER = 0 TNSNAMES.ORA: # D:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configuration File:D:\orant\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant

CMEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = tcp)(PORT = 1610)(HOST = CM_SERVER))
      (ADDRESS = (PROTOCOL = tcp)(PORT = 1521)(HOST = LSNR_SERVER))

    )
(CONNECT_DATA = (SID = ORCL))
(SOURCE_ROUTE = yes)

  )

TCPEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = Production1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

NEWAORA.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DMSERVER)(PORT = 1521))
(CONNECT_DATA = (SID = ORC1))

  )

NMPEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = NMP)(Server = FinanceServer1)(Pipe = ORAPIPE))
(CONNECT_DATA = (SID = ORCL))

  )

MIXBSP.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DMSERVER)(PORT = 1521))
(CONNECT_DATA = (SID = ORC0))

  )

EXTPROC_CONNECTION_DATA.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
(CONNECT_DATA = (SID = extproc))

  )

BEQ-LOCAL.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = oracle80)(ARGV0 = oracle80ORCL)(ARGS = '(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))
(CONNECT_DATA = (SID = ORCL))

  )

MY_BSP.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmserver)(PORT = 1521))
(CONNECT_DATA = (SID = ORC0))

  )

SPXEXAMPLE.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = SPX)(Service = Server_lsnr))
(CONNECT_DATA = (SID = ORCL))

  )

EXAORA.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dmserver)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

TCP-LOOPBACK.WORLD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

--
Chris Christoph P. U. Kukulies kuku_at_gil.physik.rwth-aachen.de Received on Fri Jan 28 2000 - 10:17:02 CST