Can one IP for multiple port codes
We are using Oracle One Node RAC ( 11.2.0.3). There are two type of listeners running on the server: local listener and scan listener. There are multiple databases running on the server also.
Per application request, we need to use different port code for each database.
In the listener.ora file, can we setup one IP (host ip) per multiple port codes as:
LISTENER =
(address_list =
(
address=(protocol=tcp)
(host = my-hostIP)
(port = 1521)
)
(
address=(protocol=tcp)
(host = my-hostIP)
(port = 1522)
)
(
address=(protocol=tcp)
(host = my-hostIP)
(port = 1523)
)
(ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))
)