Local Listener Parameter in Data Guard Environment (Non-RAC)
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;