LOCAL_LISTENER

How to Resolve ORA-00132: syntax error or unresolved network name

by Ed Chen
March 31, 2023March 27, 2023

ORA-00132 Found error ORA-00132 in the alert log, when we're starting up a database. 2023-03-01T22:41:54.802021-05:00 WARNING: Invalid value for listener related parameter MIXED LISTENER 2023-03-01T22:41:54.803545-05:00… Read More »

How Srvctl Status Listener

by Ed Chen
December 28, 2022April 21, 2023

In this post, we would like to check not only the statuses of listeners, but also services registered with those listeners. srvctl status listener lsnrctl… Read More »

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 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 Add a Standalone Listener on Second IP to Grid

by Ed Chen
December 25, 2016August 5, 2020

Suppose you have added a second IP on OS. You want a second listener to listen port 1521 of the new IP address for the… 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.