Listener Registration (LREG)

Alter System set Local_Listener Multiple Examples

by Ed Chen
November 24, 2022June 27, 2023

Multiple Listeners in LOCAL_LISTENER Theoretically, you don't have to configure parameters related to listener in database, neither LOCAL_LISTENER nor REMOTE_LISTENER. A background process, Listener Registration… Read More »

How to Resolve ORA-12514: TNS:listener does not currently know of service requested in connect

by Ed Chen
February 14, 2019August 18, 2023
28 Comments

ORA-12514 ORA-12514 means that the listener cannot find any matched service with yours, so it cannot establish the connection with the database for you. As… Read More »

How Oracle Prevent TNS Listener Remote Poisoning

by Ed Chen
August 4, 2018February 22, 2023

A vulnerability related to TNS listener has been reported in Oracle Security Alert for CVE-2012-1675, which is disclosed as "TNS Listener Poison Attack". Attackers may… Read More »

How Srvctl Add Listener to Second Network

by Ed Chen
January 3, 2017December 11, 2022
4 Comments

I assume that you have added the second network to the grid infrastructure. Let's continue our work. Make sure the second network is available in… Read More »

How Srvctl Add Listener to Default Network

by Ed Chen
December 26, 2016November 18, 2022
4 Comments

Cluster listeners have a very special feature that can generate endpoint listeners dynamically on all nodes, one for each, to establish the connections either from… Read More »

How to Resolve The listener supports no services

by Ed Chen
November 5, 2016January 17, 2023
38 Comments

The listener supports no services Let's see the current status of listener. [oracle@primary01 ~]$ lsnrctl status ... Listener Log File /u01/app/oracle/diag/tnslsnr/primary01/listener/alert/log.xml… Read More »

JavaScript is not enabled. Please enable it and reload the page.