LOCAL_LISTENER

How to Set Multiple Listeners in Database

by Ed Chen
November 24, 2022November 24, 2022

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, 2016April 27, 2022
32 Comments

The listener supports no services I newly created a database called SMALLDB, but I can't see any service registered with the new LISTENER2 which is… Read More »