Database Networking (MOSC)

MOSC Banner

Brief explanation of Listener_networks and how to configure

edited Aug 23, 2019 7:56AM in Database Networking (MOSC) 1 comment

The following document describes how to use the LISTENER_NETWORKS setting in RAC where 2 distinct networks are configured.

How to Set the LISTENER_NETWORKS Parameter for Multiple Distinct Networks (Doc ID 2493943.1)

See also:

https://docs.oracle.com/en/database/oracle/oracle-database/18/refrn/LISTENER_NETWORKS.html#GUID-7062054B-4522-4742-9ABB-…

Important to note:  Never attempt to use a single SCAN host in a TNS alias that might be referenced by any  REMOTE_LISTENER setting.
In other words, don't try to do this.  It will not work. 

alter system set REMOTE_LISTENER="MY_SCAN" scope=both sid='*';

tnsnames.ora file entry:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center