add an additional port to the scan_listener / local_listener different pdb database
Hi! We've got following scenario: we have and existing multitenant architecture on Oracle Exadata X7-2, and we hardly need to configure different port/listener to connect each pdb, we have for example 3 pdbs databases and for each one we need to configure 1521, 1522 and 1523 as well.
We are able to add scan listener new ports with
srvctl modify scan_listener -p “TCP:1521/TCP:1522/TCP:1523″
and adding new local listener as well with
srvctl add listener -endpoints ...
but scan redirection is not working propertly, cause for example a 1523 connection could wrongly redirect to 1521, and so on.
This is a firewall requirement, cause users' different network segments has to be monitored and audited on firewall security team with diferent ports on database.