For 8i and higher databases, you can rely on dynamic registration to set certain instances to use certain listeners....
For that configuration, you will need to set the local_listener parameter for each instance since you won't be using the default listener port (for at least 4 of the listeners). Set the local_listener parameter to a value like this:
local_listener = "(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))"
The PORT number will be different depending on which listener you want the database to register with. The local_listener parameter can be modified dynamically and you can use the "alter system register;" statement to force PMON to register with the listener immediately (otherwise it does a service_update about every 60 seconds).
Related Q&A from Dan Norris
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.