Usually, I configure and run multiple listeners listening at different ports, for the production database. For some important instances like PILOT and TRAINING also I configure multiple listeners, depending on criticality of the instance maintained.

You can configure different listener service in different ports for different purposes. One listener for process schedulers and one listener for external app servers and one listener for internal app servers and more importantly one listener for your maintenance purpose. I do not disclose the port numbers to others which I use for maintenance for obvious reasons.

Also you can configure the specific port numbers to a network card so that the traffic is divided if you have high traffic and heavy usage like CRM.

If you are experienced DBA, you should not have much difficulty in configuring multiple listeners.

If you need more information on how to configure multiple listener or configuring a port to a specific network card [needs root access],  I would be glad to help, just leave a note here.

One final note: Don’t forget to secure the listeners, especially if you are using older versions.

If you are new DBA, read this security document by Integrigy on listeners’ security. It has good information.

Comments (9) | Add as favourites (39) | Quote this article on your site | Views: 1366 | Print | Read more...