V
V
Vladimir2019-02-08 15:54:37
Oracle
Vladimir, 2019-02-08 15:54:37

Because of what, when connecting to Oracle through sqlplus, it gives out "no listener"?

There are 2 oracle servers in the same broadcast range with no firewall.
When trying to connect from one host to another

sqlplus login/[email protected]"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP> )(PORT=1524))(CONNECT_DATA=(SID=<SID>)))"

gives out
ORA-12541: TNS:no listener
at the same time the basis is started and listener costs. and also when connecting with an error (i.e. I enter the wrong password), the connection is broken
Listener.ora

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 0.0.0.0)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/aux

Answer the question

In order to leave comments, you need to log in

3 answer(s)
V
Vapaamies, 2019-02-08
@idskill

Port 1521, not 1524.

V
Vitsliputsli, 2019-02-08
@Vitsliputsli

Listener is not running, it needs to be launched separately.

E
Eugene, 2019-02-08
@Lorien_Elf

What does lsnrctl status say?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question