Answer the question
In order to leave comments, you need to log in
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>)))"
ORA-12541: TNS:no listener
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
Listener is not running, it needs to be launched separately.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question