Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12541: TNS: Kein Listener
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_NAME = extproc) (PROGRAM = extproc)
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)))
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