How to configure Oracle Listener for Advanced Queuing only?

user2739689

Hi,

is there any way to limit Oracle listener to provide AQ access only?

I mean not providing general database access through the queue provider at all.

We have the idea to configure a service to only provide AQ while the other service of that instance is available through the other listener. However did not find a way to limit the listener to only provide a specific service identified by a SERVICE_NAME rather than the whole instance with the SID.

Any advice?

Regards,

Eero

WGabriel

Hello,

it is not a good idea to manage a restricted AQ access only via the listener. In principle you need, of course, a database access. You could set up a dedicated db user with very restricted grants (or roles) to the corresponding AQ objects ( AQ queue, AQ queue table etc.).

Kind regards,

WoG