Database - RAC/Scalability (MOSC)

MOSC Banner

add an additional port to the scan_listener / local_listener different pdb database

edited Nov 5, 2018 2:42PM in Database - RAC/Scalability (MOSC) 12 commentsAnswered

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.

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