Database Administration (MOSC)

MOSC Banner

Local Listener Parameter in Data Guard Environment (Non-RAC)

edited Oct 30, 2025 2:28PM in Database Administration (MOSC) 2 commentsAnswered ✓

We have a 2 node 19c database with Oracle Restart and Active Data Guard configured. We are planning to enable TLS for multi-factor authentication. We have implemented our procedure on single node Oracle Restart non-Data Guard servers successfully but we don't have a 2 node servers with Data Guard in test to test.

One of the commands we are executing is (configuring it for both protocols, both ports)

SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xxx)(PORT=1521))','(ADDRESS=(PROTOCOL=TCPS)(HOST=xxx.xxx.xxx.xxx)(PORT=2484))' scope=both;

SQL> alter system register;

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